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 Management2017.11

Administer > Database administration > Data persistence > Queries > Stored queries > Update a stored query

Update a stored query

Applies to User Roles:

System Administrator

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 from 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.

In this example, we update and save a stored query for Incident Management (the probsummary file).

To update a stored query:

Open the query window.
- To open the query window from an ITSMA Service Management application:
  1. Open the application Search form. For this example, click Incident Management > Search Incidents.
  2. Open the More Actions menu.
  3. Select Expert Search.
- To open the query window from a Database Manager search form:
  1. Open the form in Database Manager. For this example, type =probsummary in the Form field, and then press Enter.
  2. Open the More Actions menu.
  3. Select Advanced Search.
    
    The Query window opens.
Click Select to display the list of stored queries for the associated file.
Double-click a query to select it. For this example, select status.resolved.

The Stored Query record opens.
Click Select to edit the query as desired. In this example, change the query to flag=true and problem.status<>"Resolved".
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.
Specify any other controls you want.
Click Store to save your edits to the selected query.

The Stored Query Maintenance form opens.
Give the query a unique Name. For this example, not.resolved.
Add a Description. For this example, type Unresolved records.
Click Add.

Service Management returns you to the Query window and displays the message: “Query added to querystored file”.

You can click Execute Search to run the saved query at this point, or click Back to exit.

Send Help Center feedback