Skip to main content
P
piyusha6151
May 30, 2025
Question

Any plan to introduce the join between record type other than Primary key

  • May 30, 2025
  • 7 replies
  • 0 views

In many cases, we have to do join other than primary key for the tables as same can't be configured with sync Record type and ultimately, we need to depend on  Database views and we loose many capabilities of Sync Record type

7 replies

stefanhelzle0001
stefanhelzle0001
May 30, 2025

I think that you can already use custom record fields for relationships.

docs.appian.com/.../record-type-relationships.html

harshas2775
harshas2775
May 31, 2025

Record relationships are there as a compliment to the joins between multiple records. And using relationships much of the features of views are replicable. 

E
erickp0002
Known Participant
December 23, 2025

Did you ever figure out how to do this? Stefan's answer didn't help me much.

stefanhelzle0001
stefanhelzle0001
December 24, 2025

Create a sync-time custom record field on each side and define it as unique.

E
erickp0002
Known Participant
December 24, 2025

How do we create a unique sync-time custom record field? The question is imagine I have CASE table with 2 columns TRANSACTION_ID and ROLE_ID (primary key id CASE_ID). Imagine I have another table that doesn't have CASE_ID as a reference but it has TRANSACTION_ID and ROLE_ID (primary key as SKILL_ID). How do I join these 2 on TRANSACTION_ID and ROLE_ID?

Terms & ConditionsAccessibility statement