Please let me know the solution for this, with proper justification.
You have data from two unrelated tables. Which Appian objects can easily relate data from these two tables?
a)custom data type
Discussion posts and replies are publicly visible
In the latest version of Appian using Record Types for relationship are the recommended method for connecting different data sources or different tables
This can also be achieved by -
1) Creating a view in DB with the tables required and then making a CDT of the view.
2) (Least Preferred) Having tables joined by foreign key and then creating nested CDT to access data of the linked table via main table
Please flag the question as answered as it can help other people.
amiteshsin said: Creating a view in DB with the tables required and then making a CDT of the view.
Is it possible to have a view with no common field defined in both the tables? How will we create the view on totally non related tables.
for point number 2, how do we connect two unrelated tables?
What exactly is the answer of above question.
Is it CDT or Record Types or expression rules?
There should be at least some relationship, either between the 2 tables direct or both of them having some relation with a 3rd table
© 2023 Appian. All rights reserved.