Page Comparison

...

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. 

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.