If I have an entity-backed record dashboard (say, for Record 1), and want to dis

dylanf over 10 years ago

If I have an entity-backed record dashboard (say, for Record 1), and want to display data from another entity-backed record (Record 2) on that (Record 1) record dashboard, does Record 2 need to have a foreign key value for the primary key of Record 1, or can it be any value in Record 1?

The reason I'm asking is that we need to create a database view that will be the basis of Record 1, and, in doing so, the PK of Record 1 would just be a random guid that doesn't exist in any other tables/views.

Thanks,
Dylan...

Discussion posts and replies are publicly visible

Parents

0 Christine
Appian Employee
over 10 years ago

A foreign key would definitely help with the performance of any query rule that you would create. However, you can query any entity you like via a SAIL expression to pull back related data.
Hope that helps and I am understanding what you are asking
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Christine
Appian Employee
over 10 years ago

A foreign key would definitely help with the performance of any query rule that you would create. However, you can query any entity you like via a SAIL expression to pull back related data.
Hope that helps and I am understanding what you are asking
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data