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 > Create stored queries from the Query Maintenance form

Create stored queries from the Query Maintenance form

You can add, edit or run stored queries from the Query window, which is accessible from the form in Database Manager or from the Application search form. Data entered into the form is automatically entered into the Query window to form the query. Depending on your permissions, you can edit and run that query, or select a query from a list of stored queries.

Click Tailoring > Tailoring Tools > Stored Queries.

A blank Stored Query Maintenance form opens.
Click Search.

A list of existing queries opens.
You can copy an existing query, create a brand new query, or create a new query from an existing query.
Note In Service Manager, you can use field name information in field help to identify the field names you want to use in your stored queries. To display field name information in field help, make sure one of the following conditions is fulfilled:
- In the Windows client, the “Show context-sensitive help debug information” preference is enabled.
- In the Web client, “viewcontexthelp=true” is appended to the URL before you log in.
Click Save to save any changes.

Caution: If you are creating a new stored query from an existing query, make sure you click Add instead of save. If you click save, you will replace the existing stored query with the new stored query you are attempting to add.
Click Add to add a new query.

You receive a message that states the record has been added to the querystored file.

Send Help Center feedback