Adding a global join

A global join is permanent and exists from session to session in the Query Builder data tree structure. You can inadvertently create a global join that causes severe performance problems. See Accessing the Query Builder

Note: Only the system administrator and users with the required permissions can access these features.

To add a global join:

Click Global Joins from the Query Builder. See Accessing the Query Builder

Note: This option only displays if you are logged on as Admin.
Click Add in the Global Join Manager screen.
Select the table and field for the global join in the Add Global Join screen, under Parent Table and Join field.
Select the table and field to join to the parent table and field in Child Table and Join Field.
Select the type of join in Join Type. See Join types

Note: The default value is Left.
Perform these tasks in Join Options:
1. Select a Visibility option to specify how the join displays in the Query Builder. The default value is Allow. See Visibility Options
2. Select a Cascade type to specify how records are deleted through the join. The default value is Ignore (Do not use in cascade). See Cascade options
Click OK.