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

Linking resources with "Use the primary keys to make the join"

mtrapiello
Level 2
Level 2

Hello,

 

I´m diving in custom resource´s creation, specially in defining links. I have always used "Define specific keys to make the join" when defining joins: i select one field from every resource involved in the link and thats how resources are joined.

 

I see that there is also another option available: "Use the primary keys to make the join".

 

mtrapiello_0-1594666030049.png

 

I would like to undertand how could i use this option to join resources. If i set this option, which field does ACS use from the source resource to link to the target resource ?(i guess that it uses target resource´s primary key)

 

Thanks and best regards!

 

Mario

Campaign Standard Custom Resource link
1 Accepted Solution
SatheeskannaK
Correct answer by
Community Advisor
Community Advisor

Hi @mtrapiello,

 

Yes, it uses both the resources primary keys to make join. For example if you have "store review" custom resource which contains store code as primary key and another custom resource "store details" custom resource which contains store code as primary key again then if you create link with option "Use the primary keys to make join" will enable link between store review and store details resource using store code as key.

You can find more information on this documentation page: Custom resource configuration 

 

Thanks, Sathees

View solution in original post

2 Replies
SatheeskannaK
Correct answer by
Community Advisor
Community Advisor

Hi @mtrapiello,

 

Yes, it uses both the resources primary keys to make join. For example if you have "store review" custom resource which contains store code as primary key and another custom resource "store details" custom resource which contains store code as primary key again then if you create link with option "Use the primary keys to make join" will enable link between store review and store details resource using store code as key.

You can find more information on this documentation page: Custom resource configuration 

 

Thanks, Sathees

View solution in original post

mtrapiello
Level 2
Level 2

Hi @SatheeskannaK ,

 

Thanks for your explanation! Pretty clear 🙂

 

Best regards!

 

Mario