Global Join Manager

The Global Join Manager displays all global joins in your Infor CRM SLX database, and permits the system administrator or administrative user to add, modify, and delete global joins as required. A global join is permanent and exists from session to session in the Query Builder data tree structure.

Note: Only the System Administrator can work on Global Join Manager.

Infor CRM SLX contains a series of predefined global joins (called system joins), which cannot be deleted. Anyone can use these predefined global joins by selecting a field in the Query Builder and clicking the Global Join. If a predefined join exists for this field, the option to view the join displays in the shortcut menu as Global Join To with a table name specified.

Note:

You must be careful when creating global joins, as it is possible to create a global join that can cause system performance problems.
By default, the ADDRESS table is joined to the ACCOUNT table through an Inner join. Do not change the properties of this join.

To view the Global Join Manager:

Access the Query Builder page. See Accessing the Query Builder.
Click Global Joins.
This option is displayed only if you are logged on as Administrator.

The Global Join Manager displays these fields:


Field	Description
Sys	A system join that cannot be deleted.
1:1	Indicates a one-to-one relationship.
Parent Table, Parent Field	The main table and field in the join relationship.
Child Table, Child Field	The table and field joined to the Parent Table and Parent Field.
Type	The type of join, such as Inner, Left or Right.
Cascade	How records are deleted through the join.
Visibility	How the join displays in Query Builder.