Linking resources with "Use the primary keys to make the join" | Community
Skip to main content
Level 2
Jul 13, 2020 6:52 PM UTC
Solved

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

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".

 

 

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SatheeskannaK
SatheeskannaKAccepted solution
Level 1
Jul 13, 2020 9:22 PM UTC

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

Thanks, Sathees

2 replies

SatheeskannaK
SatheeskannaKAccepted solution
Level 1
Jul 13, 2020 9:22 PM UTC

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

Translate
Thanks, Sathees
Level 2
Jul 13, 2020 11:11 PM UTC

Hi @satheeskannak ,

 

Thanks for your explanation! Pretty clear 🙂

 

Best regards!

 

Mario

Translate