Skip to main content

The Query History Page

The Query History page captures the queries that you have run in the current organization.

From the navigation pane, select Analytics ToolsQuery History to open the Query History page.

Query_History_Page.png

Column Headings

The Query History page has the following columns:

Column

Description

Filter?

Sort?

Created On

The date and time of the activity

Checkmark

Checkmark

User

  • Your user name

  • Users who are assigned the Automation Engineer or Super User roles can see all user names and corresponding query history for the organization.

Checkmark

X mark for lack of support

Status

The current status of the query, which can be one of the following:

  • Running

  • Success

  • Error

Checkmark

Checkmark

SQL

The SQL code that you ran in SQL Editor

Checkmark

X mark for lack of support

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 Query History

You can use the Query History page to view your past queries and open them in SQL Editor.

If you are assigned the Automation Engineer or Super User role, you can see all user names and corresponding query history for the organization.

Procedure. To view query history:
  1. In the left-hand pane, select Analytics ToolsQuery History .

    The Query History page is displayed.

  2. To open a query in SQL Editor, search for it in the Query History list, click its More Options menu (more-options-icon.png), and select Open in Editor.

    You can then run the query again in SQL Editor again and save it if you want to give it a name and keep it on the Saved Queries page.

  3. To view the full query, click its row to expand the side panel.

  4. To open the query in SQL Editor, click Open in Editor.

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

Side Panel

When you click on a row on the Query History page, the side panel displays the Query Detail tab, which includes the following sections:

  • Status: Displays the query status, which is either Success or Error.

  • Query: Displays the SQL query, which you can copy or open in SQL Editor.

Query_History-Side_Panel.png