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:

  1. Open the query window.

    • To open the query window from an Service Manager 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.

  2. Click Select to display the list of stored queries for the associated file.
  3. Double-click a query to select it. For this example, select status.resolved.

    The Stored Query record opens.

  4. 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.
  5. Specify any other controls you want.
  6. Click Store to save your edits to the selected query.

    The Stored Query Maintenance form opens.

  7. Give the query a unique Name. For this example, not.resolved.
  8. Add a Description. For this example, type Unresolved records.
  9. Click Add.

    Service Manager 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.

Related topics

Record retrieval
Retrieving records using the Query window method
Stored queries
The Database Manager utility
More Actions menu

Add a stored query
Create stored queries from the Query Maintenance form
Append stored queries
Show context–sensitive help debug information

Stored query option definitions