Save and reuse queries #

The Saved queries pane of the query editor automatically saves and stores all queries run in the query editor. Saved queries are sorted into three tabs:

• Recent: Lists all query tabs run during the past seven days.
• My saved queries: Lists the query tabs run during the past seven days, plus named queries.
• Shared with me: Lists any queries that another user has granted access to you.

The entries you can see in My saved queries match your current login name, regardless of your currently selected role. The entries you can see in Shared with me are based on your currently selected role, which can include access inherited from another role. The count of entries in those tab titles reflect the number of entries you can see in each tab.

Manage your saved queries from the list in any tab.

Create a new query #

From the Recent or My saved queries lists, select Create new query to open a new query editor tab.

Search queries #

Search for queries by name from the lists on either tab. You can sort any of the three lists by query name or by last updated date.

Saved query management #

The Recent tab displays the list of timestamped, auto-saved queries that were run in the past seven days. To save your queries beyond seven days, you must change the query name. Newly named queries remain in the Recent tab for an additional seven days. After seven days, named queries are located in the My saved queries list until you run them again or edit their name.

The My saved queries tab displays a list with named queries as well as the timestamped, auto-saved queries from the Recent query list. Timestamped queries disappear from the My saved queries list after seven days. Delete a query at any time from either list. Deleting a query from one list removes it from the other list.

Sort query list #

By default, queries are sorted to display the most recent or recently edited query at the top of the list. Reorder the query list on all three tabs using the query name or the last updated timestamp.

• Click Name to sort queries alphabetically. Click Name again to sort in reverse alphabetical order. The down arrow and up arrow show the current direction of the sort.
• Click Last updated to sort queries by oldest, last edited at the top. Click Last updated again to sort with newest, most recently edited at the top.

Tab management #

You can manage your queries in separate editor tabs. Your queries are automatically stored as Saved queries.

Organize your queries into separate tabs. For example, with a long-running query active in one tab, use the button in the query editor to open another tab for different queries.

The default name for newly created tabs is the date and time of creation. Rename a tab by double-clicking the tab name. To reorder your tabs, drag and drop the tabs to the desired arrangement.

By default, timestamped tab contents and tab names persist across login sessions for until the tab is closed. After the tab is closed, timestamped editor tabs are still available in the Recent list in the Saved queries pane for seven days. Named editor tabs are permanently stored in the My saved queries list until you delete that saved query.

Change a query tab name #

Query tabs that you have renamed are automatically saved in the My saved queries section.

To rename a query tab from all three lists, follow these steps:

• In the query list, locate the query you want to rename.

• In that query’s row, click the options menu and select Change name.

  

• In the Change query name dialog, in the Name field, edit or replace the query name.

  

• Click Save changes.

Delete a query #

Deleting a query from the Recent or My saved queries lists means you cannot restore the query or its editor tab. Deleting a timestamped or named query from the Recent list also deletes it from the My saved queries list.

In Shared with me, you must be the owner of the shared query to be able to delete it.

To delete a query, follow these steps:

• In the query list, locate the query of interest.
• In that query’s row, click the options menu.
• Select Delete.

• In the Delete query dialog, click Yes, delete.

  

Open query editor #

To open the query editor to edit a query:

• In any of the three saved query lists, locate the query of interest.

• From the options menu for that query’s row, select Open to display the query in its existing editor tab. If there is no open editor tab for that query, a new one is created.

  

Preview a query #

To preview a query, follow these steps:

• In any of the three saved query lists, locate the query of interest.

• From the options menu for that query’s row, select Preview to display the query in a dialog. The Preview query dialog has the following options:

  • Click Open in editor to display the query in its existing query editor tab. If there is no open editor tab for that query, a new one is created.
  • Click Close to exit the preview dialog.