Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.41

Administer > Database Administration > Data persistence > Queries > Complex query expressions > Logical operators

Logical operators

Logical operators evaluate Boolean expressions and determine whether the entire expression is true or false based on the operator used.

You can use logical operators to do the following:

Construct simple queries that return true, false, or unknown results using Boolean logic.
Perform queries using combinations of logical operators that are not available to use with the Record list query method, use the Retrieving records method from the query window.

Operator	Symbol	Usage	Operation
AND	&	value AND value	Returns TRUE if both component conditions are TRUE. Returns FALSE if either is FALSE. Otherwise returns UNKNOWN.
OR	\|	value OR value	Returns TRUE if either component condition is TRUE. Returns FALSE if both are FALSE. Otherwise returns UNKNOWN.
NOT	~	not value	Returns TRUE if the following condition is FALSE. Returns FALSE if it is TRUE. If it is UNKNOWN, then it remains UNKNOWN.

Logical operators take precedence in the following order: (1) NOT, (2) AND, (3) OR.

Results of applying the NOT operation to an expression:

--	TRUE	FALSE	UNKNOWN
NOT	FALSE	TRUE	UNKNOWN

Results of combining two expressions by using AND:

Results of combining two expressions by using OR: