Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Link between schemas

Rajesh_SS01
Level 3
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
Deb007
Correct answer by
Level 6
Level 6

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
Deb007
Correct answer by
Level 6
Level 6

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