Question

Search for documents that have either Field1 or Field2

Search and Retrieval Web Client Laserfiche

Updated September 16, 2019

asked on September 13, 2019

Hello,

We have a template that contains VendorID and Vendor Name. Is there an easy way to search using the Advanced Search (not Advanced Search Syntax) for all documents that have either VendorID 123 or the name contains Laser*

If not, what would be the advanced search syntax to do that type of search?

Thanks in advance!

0 0

Answer

APPROVED ANSWER

replied on September 13, 2019 • Show version history

There isn't a way to use the 'OR' operator for field values in Advanced Searching; you will need to use the Advanced Search Syntax. The syntax illustrated by Cassandra Lint will search for any entry names that start with "Laser" OR with the Vendor ID field containing "123" (remove the extra curly bracket after Type="D").

If I understood you correctly, you are looking for an 'OR' operator with 2 fields (Vendor Name and Vendor ID), instead of the document name. For that, use the below syntax:

{[]:[Vendor ID]="123"} | {[]:[Vendor Name]="Laser*"}

This will search for any document with a Vendor ID field value of "123" OR a Vendor Name field value starting with "Laser".

2 0

Replies

replied on September 13, 2019

I don't know of a way to do it with Advanced Search but you can do the following with the Advanced Search Syntax:

{LF:Name="Laser*", Type="D"}} | {[]:[VendorID]="123"}

0 0

You are not allowed to follow up in this post.

Question

Question

Search for documents that have either Field1 or Field2

Answer

Replies

Sign in to reply to this post.