Aeros VISION Query Modifying Query Joins Created by VISION

Owned by Denise Blackford
Last updated: Feb 15, 2022
2 min read

While Aeros VISION is created with intuitive features to assist in creating moderately complex queries, occasionally the need will arise to edit or change that Joins that VISION created automatically when you first designed your query.

By default, the Joins created are INNER JOINS. For example, you may want to view an OUTER Join, or RIGHT JOIN in the query.

Pre-Requisites

  1. It is recommended that the person making changes to a VISION generated query, have a good understanding of SQL queries and JOINS.

Step-by-Step Guide

To modify the VISION created Joins:

    1. Log in to Aeros VISION.

    2. Click on Settings in main menu bar.

    3. Select Manage Data Models/Connections

 

 

       

 

 

    4. Select the Data Model that is used in the Query to be modified. KEEP IN MIND, all queries and reports that use this Data Model, will be affected by the change. 

 

       

 

    5. Click on the Data Model Editor icon to open the editor for changes. 

    6. There are two tabs in the Editor. Click on the Joins tab, to view existing joins created by VISION.

    7. There are 3 sections displayed. Tables, Joins and Properties sections.

 

       

 

    8. In the Tables section, select the main table (left table in this example) that is requiring a modified join. 

    9. Once the table is selected, the existing joins are displayed in the Joins section. 

    10. Select an existing join and click Edit button, or Click Add button to add a new JOIN to the data model. Shown below, is Add procedure. 

 

       

 

    11. The table selected is shown in the Table #1 box. Select the type of JOIN you need to add for the data model and query. 

    12.  In the Table #2 box, click on the drop down and select the table to which you will join to the table displayed in Table #1 box. 

    13. In the column grid beneath the Table selection section, in Table 1 Column, select the column from the first table that will be compared to a column in Table 2. 

       

 

    14. In Table 2 Column drop down, select the column from the second table that will be compared to the column selected from table 1 above. 

 

       

 

    15. Click Save and Close to save the newly created JOIN.

    16. The new JOIN will be listed in the Joins section and when selected, the Join's properties are displayed in the Properties section.

 

    17. When you run a query that is associated with that newly modified Data Model, the query results will now reflect the additional Join and the data displayed will be presented accordingly.