Query Tab

Query tabs are used to run raw SQL queries on the database. Query tabs require Query Analyzer access. To open a new query tab select Query Analyzer tab then expand the database object in the tree and select New Query.

ToolBar Description :

Icon	Name	Description
	Run	Runs the SQL query entered into the query box.
	Undo	Will undo the last text edit in the query box short key Ctrl-Z.
	Redo	Will redo the last undo in the query box short key Ctrl-Y.
	Show / Hide Calculator	Will show hide the calculator.
	Show / Hide Shift Selector	Will show hide the Shift Selector when visible {0} and {1} will be replaced in the query with start and end of shift link in the reports.
	Save Query	Will save the query to file in my documents folder and is accessible in User queries in the Query Analyzer tree.

Results of a query are shown at the bottom. If a query fails an error message will be in the Messages tab. The query window supports the return of multiple result sets. The different tables returned can be selected from the dropdown list. Pressing the save button will allow the saving of the current selected grid to excel.

Query Execution Time As a query is executing this timer will be counting up. Once the query is completed this will show how long it took to execute.

1. Toolbar : Section to test, edit, calculate, undo, redo and save the query.

2. Shift Selector : Section to select the date/time range for viewing the result.

3. Query : Section to write the query.

4. Result : Section to view the result of the query.