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

Question

Question

Unable to Search Field With Empty Value

Version 9 Laserfiche Search and Retrieval
Updated June 24, 2016
asked on June 23, 2016 • Show version history

When I attempt the following advanced search syntax,

{[Registration]:[Unit Number]=""}

OR 

{[Registration]:[Unit Number]<>"*"}

I do not return all results. 

I can search and return results only if I populate the Unit Number field with an existing value in the repository.

0 0

Replies

replied on June 23, 2016

I am not sure if i understand you correctly but how do you know that 

{[Registration]:[Unit Number]=""}

is not returning all results with empty fields. It works for me. Are you searching in the right folder or do you have access rights required to see all the files?

could you please try something like this and see if it makes any difference.

{[Registration]:[Unit Number]=""} - {[Registration]:[Unit Number]="*"}
0 0
replied on June 23, 2016 • Show version history

Several documents that have the Registration Template with no Unit Number are not returned when I run this search.

The account is the workflow account, basically has 'god' rights to the repository. It has access rights to the documents and am able to update the template fields. 

Rights are not the issue. 

 

 

0 0
replied on June 23, 2016

Find out the entry ID of one of those documents that should be returned in the search, but doesn't. Then do an ID search or use this advanced search

{LF:ID=x}

where x is that entry ID. I'd like to confirm that the user in question really does have rights to those documents.

If the user can return the document using the above search, then the next thing I'd suggest trying is to set some value into the Unit Number field, save the change, and then remove the value and save again. Now try your original search again.

If that doesn't address the matter, then please open a support case so the matter can be further investigated.

0 0
replied on June 24, 2016

The document returned when I ran a search on the document's entry ID. 

I will try deleting and adding the value back into the field and let you know. 

 

 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...