Salesforce

Link Left Outer Join (Magic xpa 3.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Link Left Outer Join (Magic xpa 3.x)

Magic xpa can implement the Link definition as a Left Outer Join if both the Main and Joined tables are SQL tables from the same database. Also, the relationship between the Main and Joined tables must be a many-to-one relationship: at least one main record that links to either one or no supplemental records in the joined table. A Link Left Outer Join definition joins a record from the Main Source in Magic xpa to either a matching record in the joined table, or a set of null values returned if no matching record is found.

When a matching row is found, a true value is returned. If no matching row is found, a false value is returned.

Related Topics

Reference
Attachment 
Attachment