Expand my Community achievements bar.

SOLVED

Link between schemas

Avatar

Level 3

Hi All,

Can you please explain the different type of links between schemas that could be established with an example? Am finding it difficult to understand the difference between 1:1 link between Recipient to FOLDER schema and 1:1 link between Recipient to COUNTRY schema. Can you also explain what exactly the externalJoin = true property works for links between the schemas?

Thanks,

Rajesh.S.S.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi Rajesh,

You can establish relationship(1:1, 1:N, N:N) between shemas using Links.

A Recipient always belongs to a Folder and may or may not have a Country code against it.

externalJoin=true acts as a left outer join only, where all records are returned from the schema you are querying, even if there is no match.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi Rajesh,

You can establish relationship(1:1, 1:N, N:N) between shemas using Links.

A Recipient always belongs to a Folder and may or may not have a Country code against it.

externalJoin=true acts as a left outer join only, where all records are returned from the schema you are querying, even if there is no match.