#SAIL Show correct data from different Data Stores Entities based on the referrence key

jurajb1 over 7 years ago

#SAIL
Hello,
I need a help with my SAIL Interface. What is the best solution to display corresponding data for each row in the record (request) from different Data Store Entities based on the referrence key. Using the Query Rule, by saving the query entity to a local variable or using different way?

Thanks

Discussion posts and replies are publicly visible

0 abhinavg712
Certified Lead Developer
over 7 years ago

if you can use your reference key to join multiple tables( different Data Store Entities ), try using a view to show data. Please find more information below.

docs.appian.com/.../Database_Schema_Best_Practices.html
forum.appian.com/.../Database_Performance_Best_Practices.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 7 years ago

I think the best way is to create a view in database and create a CDT for this specific use case that maps to the view. Then use this data to show in the grid.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aloks0189
Certified Lead Developer
over 7 years ago

I agree with @stefanh791, i think going for View is the easiest approach, but not to forget, while switching to other environment, you need to create the view manually in the Target environment
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 harrys over 7 years ago

Using a view is also likely to give you better performance than accomplishing through rules, depending on the complexity of your joins.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 venkateshs329 over 7 years ago

In interface level we can form adhoc cdt and bind data to grid if you have less data but insted of doing this we can go with view is the best approach and performance also good .
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jurajb1 over 7 years ago

thanks for help, guys. Indeed, creating the view seems to be the best approach also taking into account the performance.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel