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.

1. Click Tailoring > Tailoring Tools > Stored Queries.

   A blank Stored Query Maintenance form opens.

2. Click Search.

   A list of existing queries opens.

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

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

5. Click Add to add a new query.

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

Related concepts

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

Related tasks

Grant access to stored queries
Run a stored query
Update a stored query
Add a stored query
Append stored queries
Show context–sensitive help debug information