Page Comparison

...

C - Select All

D - Deselect All / Clear Selection

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

...

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. 

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 AllImage 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.