Boolean Operators

Boolean operators enable you to define searches that include more than one search phrase. Searches made up of two or more search phrases can include multiple index fields and index values.

The Boolean operators are located on the Search page.

NOTE: This list is not visible, until you select a document group and document type, and click the Add condition button under the Search Criteria heading.

Click the drop-down arrow to select a Boolean operator from the list.

NOTE: While the AND operator can be used to link search criteria containing different index fields, the OR operator can only be used to link search criteria containing the same index field.

 

The following Boolean operators are available:

Examples:

Ship Date > 01/31/2001 AND Ship Date < 03/02/2001 — This retrieves all documents with ship dates from February 1, 2001 through March 1, 2001.

Customer name = Betty's Music Store AND Ship Date = 01/31/2001 — This returns only documents for Betty's Music Store that have a ship date of January 31, 2001.

Examples:

Customer Name = Bluegrass Records OR Customer Name = The Glass Harmonica — This search returns documents for either Bluegrass Records or The Glass Harmonica (or both, if the document type selected contains documents for both stores).

Invoice Number = 11187 OR Invoice Number = 11189 — This search will return documents for either invoice 11187 or invoice 11189 or both.