Selecting Join Path


When you are using columns from more than one table in the same information link you have to specify a join path between all used tables. If multiple joins are created, you can specify which joins will be the default ones. The default joins will be presented in the join path field when the Suggest Joins button is clicked (if they are suitable for the current information link).

However, sometimes you may want to specify a different join path for an information link.

Let's say the default join path between Table 1 and Table 4 is via Table 3 and the joins TABLE1.ID=TABLE3.ID and TABLE3.NAME=TABLE4.NAME.

id_select_join_path.png

For a certain information link this is not what you want, instead you wish to configure the link to join via Table 2 using the joins TABLE1.ID=TABLE2.ID and TABLE2.COST=TABLE4.COST.

This can be done in the Join Path section for the information link by simply selecting the desired joins instead of the suggested ones.

  1. Go to the Join Path section on the information link tab.

  2. Select a join from the Joins tree that you wish to use and click Add.

    Response: The new join is added to the Selected Joins list.

  3. Repeat step 2 for any additional joins.

  4. Click Save to save the information link.

    Comment: The Selected Joins will be saved with the information link, and will always be used when retrieving data via the information link.

Note: When executing an information link against several data sources, all subqueries are run first and then the main query, joining all subresults. This means that the joins in the main query are performed after all joins in the subqueries.

See also:

Information Link Tab