Expand my Community achievements bar.

SOLVED

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

Avatar

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
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

Thanks, Sathees

View solution in original post

2 Replies

Avatar

Correct answer by
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

Thanks, Sathees

Avatar

Level 2

Hi @SatheeskannaK ,

 

Thanks for your explanation! Pretty clear

 

Best regards!

 

Mario