Query Page Reference

Query page consists of the following elements:

ExpandedToggleIcon        Tab Bar

Tab bar is the uppermost part of the query page. The left part of tab bar displays currently opened queries. The right part of the tab bar contains the following buttons:

Open new tab

Opens a new tab with an empty query.

Open Gallery

Opens Query Gallery, which allows you to select and open a previously stored or predefined query.

< and >

These buttons are available when too many queries are open on the page. They allow scrolling tabs when there are too many of them to fit in the tab bar.

 

ExpandedToggleIcon        Toolbar

Query Toolbar is located under tab bar. It contains the following user interface elements:

Connection list

Allows you to select a connection for a query.

Execute

Executes the query.

Save

Allows saving the query to Query Gallery.

Clear

Clears the current query.

Clone

Opens a copy of the current query in a new tab.

Builder

Opens the Builder view of the query (see Query Page Basics for details).

SQL

Opens the SQL view of the query.

Data

Opens the Data view of the query.

 

ExpandedToggleIcon        Connection Object List

Connection Object List in the left part of the query displays the list of the list of objects from the currently selected connection. Read more about Connection Object List...

 

ExpandedToggleIcon        Query Builder

Query Builder is available in the right part of the page on the Builder view. Read more about Query Builder...

 

ExpandedToggleIcon        SQL Editor

SQL Editor is available in the right part of the page on the SQL view. It allows you to enter SQL statements and provides syntax highlighting for them.

 

ExpandedToggleIcon        Results

The Results area displays query results as a grid with data or as a chart. Read more about the Results area...

 

ExpandedToggleIcon        Status Bar

Status bar displays query execution status, duration, and the number of displayed or affected records.

query-icon-quote - this button hides and shows the Connection Object List.

query-icon-show-results - this button shows the Results pane on the Builder and SQL views.

query-icon-hide-results - this button shows the Results pane on the Builder and SQL views in order to give more space for Query Builder or SQL code. If you hide the Results pane and execute a query, the Data view with the result data is automatically opened.