Updating Existing Queries

At times, you might want to update a query to reflect new conditions or copy an existing query and modify it for other uses. You can open a query, examine it to determine whether it is suitable, and then use the Save As function to save it with a new name.

Note:

When you save an existing query after editing it, Query Manager deletes the old version of it and then recreates the query. The query definition table entries and language table entries related to the query definition are deleted.

To update an existing query:

1. Select Reporting Tools, and then Query, and then Query Manager.

2. On the Query Manager search results page, find the query that you want to modify and click its Edit link.

   The Fields page appears.

3. Access the tab that you want to modify the information—except the Run tab.

4. Enter the new information.

5. Click either the Save button to update the existing query, or the Save As link to save a different instance of the query under a new name.

Note:

When using Microsoft Windows-based Query Designer, any modification to a previously saved query must be saved before downloading query results to Microsoft Excel. A message appears reminding you to save your work. This is to ensure that accurate data are displayed. New ad hoc queries that have never been saved before in the database can be downloaded to Microsoft Excel without having to save after every modification.