Hi All,
I have 2 tables TABLE1 and TABLE1_HISTORY. I need to combine latest 1 row from TABLE1 and few historical rows from TABLE1_HISTORY and display the values in a single grid.
Instead of using UNION to combine the 2 tables using DB views or querying the 2 tables separately and combine in Appian side , is there a way to union 2 tables using recordtypes ? relationship creation is not working as the PK / FK relationship doesn't exist.
Note Here: As per our current design , the common field between the 2 tables are not a PK field in either of the tables because of which i am not able to create relationship as join / union in SQL.
Appreciate the suggestions. Thanks in advance
Raj
Discussion posts and replies are publicly visible
Only solution to this issue is somewhat convoluted. You could create a 2 Web APIs that query the same fields on both tables. Create a single Service Backed Synced Record Type that combines the results of the 2 Web APIs.
yes it can work, but it is convoluted.