Query Designer Ribbon
Query Designer functions are accessed through its ribbon. This topic describes these functions.
- To add a function to the Quick Access Toolbar, right-click the desired function and select Add to Quick Access Toolbar.
- If the Quick Access Toolbar is hidden, right-click anywhere in the ribbon and select Show Quick Access Toolbar below the Ribbon. If desired, right-click again and select Show Quick Access Toolbar above the Ribbon to change the position of the toolbar.
See the following table for more information about the available functions in the Query Designer ribbon.
Menu Item |
Description |
|---|---|
Folder icon |
Returns the user to the homepage. If any modifications have been made to the current query, a save prompt appears. |
Query icon |
The main menu used to maintain and execute queries. |
Save |
Saves the current query. The first time a new query is saved, the Save As dialog box appears (see Save a Query for the First Time for more information). |
Save As |
Click the drop-down list, then click Save As to save the query to a different target location and/or update file name. |
Show table list |
This function in the Display drop-down list allows the user to add an available table from the current connection. |
Summary field (GEXQ) |
Allows users to summarize (total, count, average, etc.) a selected numeric field (see Create the Summary Field for more information). |
Run Query |
Executes the current query and returns all records. Tip: Pressing F5 in the SQL window can be used as a shortcut to execute the query. |
Test Query |
|
Run Summary |
Executes the summary query. |
Query Options |
Click the button to make additional query options available. |
Settings |
This function in the Options drop-down list opens the Settings panel, allowing the user to define various criteria to control processing (see Query Designer Settings for more information). |
View log |
This function in the Options drop-down list opens the Log Viewer panel where the user may view information and error log entries, copy selected log entries, email, or clear the log file (see Query Designer View Log for more information). |
Query Exchange |
Opens insightsoftware's online query depository, Query Exchange, allowing the user to download queries to Query Designer (see Download Queries from Query Exchange for more information). |
Tools: |
The menu used to manage connections. |
View all test connections |
Opens the Test Connections panel, allowing the user to view and test connections to which the user is authorized (see Connections for more information). |
Update all query connections |
Opens the Update All Connections panel allowing the user to modify all original connections assigned to queries to a new connection. |
Update connections by file |
Opens the Update Connections by File panel allowing the user to modify a file assigned to a query to a new connection. |