Analyser Query - SQL Statement tab

Purpose

Define the SQL statement for Query Builder.

Query

This section contains the SQL query which is defined for the Analyser Report. The user will define the query here which will query the required data in the database for the Analyser Report.

Data Dictionary in Analyser Report

This section contains a Data Dictionary which will assist the user in constructing the SQL query. The user can expand the tables and views in order to view the database table and column names. It will contain Tables and Views:

Copy and Paste functionality

The user can select a field name in the Data Dictionary section and then double click on it. This will then copy the field name and paste it in the query above.

Please note!

Refer to Using Query Builders for information about using Query Builder functionality.