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 > Create a query using a simple query expression

Create a query using a simple query expression

Applies to User Roles:

System Administrator

In this example, a query is performed on a specific assignee for all contracts in Configuration Management. Once stored, operators or groups of operators can access the query and automatically generate a list of records without reentering the detailed search criteria.

Note: You must have the capability word QueryAdmin or query.stored.mod operator record to add or edit stored queries.

To create a query using a simple query expression:

Click Configuration Management > Contracts > Contracts.
Use the Fill function in the Assignee field to choose an assignee. For this example, Carlton Hulman was chosen.
Open the More Actions menu and choose Expert Search.

The Query form opens. The new query is displayed in the Query field. For this example, the query for Carlton Hulman is displayed as follows: assignee#"Carlton.Hulman"
On the Query form, click Keys.

Note: Do not modify the automatically-generated query string, assignee#"Carlton.Hulman", as it appears in the Query field.
On The Key Window (keylist form), type a key number to select the number of positions for the assignee.name key in the query. For example, type the number 3 to select 3 positions.
Click OK.

The Sort Fields field in the Query Window is now modified to agree with the key definition you selected.
On the Query form, click Store to create the querystored file.
Fill in the following fields:
- In the Access List field, type in the Query Groups or Operator Names that you want to have access to this query. If you want all users to have access, leave the list blank.
- In the Name field, type a unique name for your query.
- In the Description field, type an explanatory description.
Click Add.

The following message confirms your entry was successful: Query added to querystored file.
Continue to further refine your search criteria, or click Search. You can also click any record in the list of returned records to view the details.

Send Help Center feedback