Page Comparison

Overview

The Query Designer screen is where you will define a query against your database. The screen consists of the following elements:

...

C - Select All

D - Deselect All / Clear Selection

E - Add Checked / Selected Attributes to the Columns listing.

...

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.

Image Added

6 - Properties
This sections lists different configuration options specific to the Query. 

Image Added

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. 

...

Step-by-Step Guide

Creating a New Query

1. Access the Vision Main Menu.
     
2. Click New Query.
    
3. Select a Data Model from the drop-down list. Generally the default is automatically selected.
   
   
4. Click OK.
   
   
5. In the Properties panel, specify a Name of the Query.
   
   
6. Optional: Specify any other options desired within the Properties panel.
   
   
7. In the Entities panel, expand the Entities to located the desired columns.
   
   
8. Click the checkbox next to the desired columns. 
   
   
9. Click the Add Columns Image Added button to add the checked columns to the Columns panel.
   
   
10. Optional: Alter column names and configured options within the Columns panel.
    
    
11. Recommended: Add options to the Conditions panel to filter your results.
    Note: If you leave this section empty before clicking Run Query, all records will be returned from the database. Depending on the size and number of records, this may take a large amount of time to return data.
     
    
    1. Click the Deselect All Image Added button at the bottom of the Entities panel.
       
       
    2. Locate the columns that you wish to add a condition for.
       
       
    3. Click the checkbox next to the desired columns. 
       
       
    4. Click the Add Conditions Image Added button to add the checked columns to the Conditions panel.
       
       
    5. Within the Conditions panel, specify a Value for each of the Condition options.
       Image Added
       
       
12. Suggested: Click Save.
     
13. Click Run Query in the Ribbon Bar.
    
    
14. Your results will display within the Results panel. 

Editing a Query

1. Access the Vision Main Menu.
2. Locate the Query you wish to edit.
   
   
3. Click the pencil / edit icon next the Query name.
   
   
4. The Query Designer screen will appear.