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

Develop > Tailoring > Data management > Stored queries > Using stored queries in scripts

Using stored queries in scripts

You can use a stored query to execute a script, and you can write a script that uses a stored query to locate specific records.

A script calls stored queries to populate forms with useful data. Use this capability to grant limited database access to certain users.

For example: You could allow Level 1 technicians access to a user information form through which they can update selected elements of a caller’s contact record. The script calls the stored query. The query retrieves and displays the data from the contacts file. The technician makes the updates and saves them. The script then continues walking the Level 1 technician through the normal workflow.

Send Help Center feedback