Run a stored query

Depending on your permissions, 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.

Example: Selecting and running a stored query.

In this example, a stored query for Incident Management (the probsummary file) is selected and run.

1. Open the query window.
   • To open the query window from a 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 Expert 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.

   Service Manager returns you to the Query window.

5. Click Execute Search to run the stored query.

   Records matching the query display in a record list.

   • If only one record matches your search criteria, that record opens.
   • If no records match, the server displays the following message: No records found.

Related topics

Stored queries
Using stored queries in display objects
Using menu buttons to run stored queries
Using stored queries to produce charts and marquees
Using stored queries in scripts
Menu option searches
More Actions menu

Grant access to stored queries
Add a stored query
Create stored queries from the Query Maintenance form
Update a stored query
Append stored queries