You are viewing limited content. For full access, please sign in.

Question

Question

Can't set new constraint; get error 9250

Laserfiche Version 9 Search and Retrieval
Updated October 27, 2015
asked on October 23, 2015

I've run into this before and it is very frustrating.  I try to set a constraint on a field, but because I have some entries in this field in documents that don't match the constraint, LF won't let me make the constraint.  Can it not be set to work for future documents?

I have searched out the documents with the entries that do not match the constraint and have made them match... all but one, that is in the recycle bin.  Unfortunately, the recycle bin can't be searched so I don't know which item in there is the problem.

Is there a way around this?

Thx, Connie Prendergast (Flagstaff County, AB, Canada)

0 0

Replies

replied on October 27, 2015

Hi Connie,

You can perform a SQL query on the Laserfiche database to find the entries that don't match the constraint. The following SQL query will return the Entry ID of those entries in the recycle bin. You will need to replace WHERE prop_name = 'MyField' with the field name. 

SELECT toc.tocid [Entry ID], name [Entry Name], pos [Value#], str_val [Value] 
FROM toc JOIN propval ON toc.tocid = propval.tocid 
WHERE toc.toc_flags & 0x800 <> 0 
AND prop_id IN ( 
  SELECT prop_id FROM propdef WHERE prop_name = 'MyField') 
ORDER BY toc.tocid, pos

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...