Page Comparison

Overview

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

...

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  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  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  button to add the checked columns to the Conditions panel.
       
       
    5. Within the Conditions panel, specify a Value for each of the Condition options.
       
       
       
12. Suggested: Click Save.
     
13. Click Run Query in the Ribbon Bar.
    
    
14. Your results will display within the Results panel. 

...