Search Operators

You can combine multiple terms with Boolean operators to form a more complex query. Boolean operators include AND, OR, and NOT.

Boolean operators must be in all capital letters.

Other search operators include quotation marks, open and closed parenthesis, and the |, -, and * symbols.

To find a specific record, best practice is to use quotation marks around the entire name.

Also refer to Search Wildcards for information on using wildcard characters to refine your search.

Search Operators
Operator Description Example

AND

The AND operator matches records where both terms exist anywhere in the searchable fields.

David AND Jones would find records in which both names David and Jones exist in the searchable fields.

1 AND month finds records that include both 1 and month.

OR

The OR operator is the default conjunction operator. This means that if there is no operator between two terms, the OR operator is used. The OR operator links two terms and finds a matching document if either of the terms exist in a record's searchable fields.

David OR Jones would find all records in which David or Jones exists in the searchable fields. It would also find records such as Don Jones and David Johnson.

1 OR month finds records that include 1 or month, such as 1 Month, 1 Year, Sub-1, month end. 1 month finds the same records.

NOT

The NOT operator excludes records that contain the term after NOT.

Jones NOT David would find records that include Jones but not David.

1 NOT month finds records that include 1 but not month, such as 1 Year and Sub-1 but not 1 month.

“ “

Quotations. The search results would include records that only include a word or phrase in all searchable fields.

“SRE1” would find records that include SRE1.

To find a specific record, best practice is to use quotation marks around the entire name.

|

Vertical bar or pipe. Same as using the OR operator.

 

David | Jones would find all records in which David or Jones exists in the searchable fields. It would also find records such as Don Jones and David Johnson. See also OR.
- Dash. The search results would include records that do not mention a word or phrase.

SRE -maximum would find records that include SRE but do not include maximum.

*

Asterisk. The search results would include the letter, word, or phrase, depending on where the asterisk is used.

*Z would find all records containing Z.

Z* would final all records beginning with Z.

( )

Parenthesis. Group multiple searches within the parenthesis.

(David OR Jones) Smith would find records for either David Smith or David Jones.

 

 

 

Topic updated: 03/2024.