Skip to main content

The Saved Queries Page

If you have a query that you run often, you can open it in SQL Editor, give it a name, and save it.

When you want to run a query again, go to the Saved Queries page, click in the row for your saved query, and select Open in Editor to populate SQL Editor with the query.

Saved_Queries_More_Options_Menu.png

You can also view a saved query or delete it if you no longer need it.

From the navigation pane, select Analytics ToolsSaved Queries to open the Saved Queries page.

Column Headings

The Saved Queries page has the following columns:

Column

Description

Filter?

Sort?

Name

The name you gave to the query

Checkmark

Checkmark

SQL

The SQL code that you ran in SQL Editor

Checkmark

X mark for lack of support

Created on

The date when you saved the query

Checkmark

Checkmark

Modified on

The date when you last modified the query

Checkmark

Checkmark

Note

You can change columns that are displayed, sort by a specific column, or change the column order. See "Changing the Table Display" for more information.

Actions You Can Perform on the Query History Page

You can use the Saved Queries page to view your saved queries, open them in SQL Editor, or copy them to your clipboard.

Procedure. To view a saved query:
  1. From the navigation pane, select Analytics ToolsSaved Queries.

    The Saved Queries page is displayed.

  2. Find the query that you are interested in and click its row.

    The query's side panel displays the query.

    Saved_Queries_Side_Panel.png
  3. To open the query in SQL Editor, click Open in Editor.

  4. To copy the query to your clipboard, click the Copy SQL.

Side Panel

When you click on a row on the Saved Queries page, the side panel displays the Query section, which shows the saved SQL query and buttons for copying the SQL to your clipboard or opening it in SQL Editor.