Linking resources with "Use the primary keys to make the join" | Community
Skip to main content
Level 2
July 13, 2020
Solved

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

  • July 13, 2020
  • 1 reply
  • 1299 views

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.
Best answer by SatheeskannaK

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

1 reply

SatheeskannaK
Community Advisor
SatheeskannaKCommunity AdvisorAccepted solution
Community Advisor
July 13, 2020

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
Level 2
July 13, 2020

Hi @satheeskannak ,

 

Thanks for your explanation! Pretty clear 🙂

 

Best regards!

 

Mario