Working with Saved Queries

Saving a Query

To save a query:

1. Build a query:

   1. Navigate to Query Builder

   2. Select objects from the Object Selection pane.

   3. Add objects to the Design pane and select columns.

   4. Execute the query.

2. Click Save.

3. Enter a name and description and click Save.

   The saved query displays in the Saved SQL view.

Note that Query Builder does not support duplicate query names. If you open an existing query, keep the existing name, and save it again, Query Builder over-writes the existing query. If you change the name of an existing query and save it again,Query Builder saves the query again under the new name.

Editing a Saved Query

Once you save a query, you can access it in the Saved SQL view.

To edit a Saved SQL query:

1. Navigate to Query Builder:

   1. Click the SQL Workshop icon on the Workspace home page.

   2. Click Query Builder.

      Query Builder appears.

2. Select the Saved SQL tab.

3. To filter the display, you can:

   • Make a selection from the Owner list and click Go.

   • Enter a search query in the Name field and click Go.

4. To edit a query, select the appropriate name.

   The saved query appears. The selected objects display in the Design pane and the Conditions view appears.

Deleting a Saved Query

To delete a Saved SQL query:

1. Navigate to Query Builder:

   1. Click the SQL Workshop icon on the Workspace home page.

   2. Click Query Builder.

      Query Builder appears.

2. Select the Saved SQL tab.

3. Select the queries to be deleted and click Delete Checked.