Question

Advanced search syntax: include empty and specific field values

Laserfiche Search and Retrieval

Updated May 26, 2015

asked on May 22, 2015

I am trying to create a succinct (I have limited character space) search that looks for documents with a specific value as well as blank.

In my examples, I'm looking for documents that fit certain criteria that either have a specific deposit account number as well as those that may have a blank deposit account number.

This works:

{[Corporate Member]:[Organization Number]="9157", [Organization Document Group]="Corp Signing Authorizations", [Document Status]="Active"}&({[Corporate Member]:[Deposit Account Number - Signers]=""}|{[Corporate Member]:[Deposit Account Number - Signers]="123456"})

This does not:

{[Corporate Member]:[Organization Number]="9157", [Deposit Account Number - Signers]in("","123456"), [Organization Document Group]="Corp Signing Authorizations", [Document Status]="Active"}

It looks like I can use [Field Name]in("","123456") to return both empty and specific values. Is this a bug? Is it intentional? It would be nice it if worked. If it isn't as logical as I think it is, please explain why.

Thanks for your help.

0 0

Answer

SELECTED ANSWER

replied on May 26, 2015

I would suggest applying Laserfiche 9.1.1 SP2 and see if that resolves the issue. I wasn't able to recreate the issue in that version.

Sample documents in the repository:

Search Results:

If you're still having an issue, please contact your Laserfiche reseller to open a support case so the matter can be further looked into.

0 0

Replies

replied on May 22, 2015

Hi Kenny,

I used your exact same advanced search syntax (copied from your post) and the search works fine for me in Laserfiche 9.2.1. Are you on an earlier version of Laserfiche? If so, what's the version? Also, can you clarify in what way the shorter search syntax isn't working? Are you getting an error message or is it just not returning the correct documents?

Regards

0 0

replied on May 26, 2015

My apologies. I shouldn't post late on Friday...

The shorter version does not return documents. The first/long one does.

We are using 9.1.1 build 545

0 0

SELECTED ANSWER

replied on May 26, 2015

I would suggest applying Laserfiche 9.1.1 SP2 and see if that resolves the issue. I wasn't able to recreate the issue in that version.

Sample documents in the repository:

Search Results:

If you're still having an issue, please contact your Laserfiche reseller to open a support case so the matter can be further looked into.

0 0

You are not allowed to follow up in this post.

Question

Question

Advanced search syntax: include empty and specific field values

Answer

Replies

Sign in to reply to this post.