...
5 - SQL
This area displays the SQL code used to run against the database. This is display for debugging purposes only and will most likely not be used except by Administrators and Aeros Customer Care.
6 - Properties
This sections lists different configuration options specific to the Query.
Name - The title of the Query. Required to save.
Description - Optional text to describe the purpose of the Query.
Category - The first level grouping of the Query. Select from available options.
Sub Category - The second level grouping of the Query. Select from available options.
Active - When checked, the user can run the Query from the Main Menu.
Delete - Flag to mark the Query to delete. Note: The system does NOT delete any Queries. Must contact Customer Care to delete a Query.
Distinct Records - Selects only the unique records to return in the Results grid.
Select Top Rows - Numeric value option to specify how many records to return. For example: 100
Pivot as Source - When selected, the results data will return a Pivot Table as the raw data.
Pivot Settings - Configuration for the Pivot Source option.
Lock Criteria - When checked, when the user runs the Query, they cannot modify the Conditions options.
Lock Values - When check, when the user runs the Query, they cannot modify the Values in the Conditions options.
Release - Not Yet Implemented
System Query - Not Yet Implemented
Last Modified - Display option review of the last time the Query was saved.
Version # - Display option of a counter of Query revisions.
Query ID - Display option of the unique identifier of the Query stored in the database.
Data Model ID - Display option of the unique Data Model used as the source for the Query.
Connection - Display option of the Connection used by the Data Model to connect to the raw data source.
7 - Results
This section displays the results of the query in an Excel-like type grid format. For further documentation and usage of the grid, please view the Query Grid page.
...