Hi Readers,
Scenario : I Have 4 database tables and some columns in the tables are as below and all the table are related as below(One to many Relation)
TableA: ID-A, Cluster-ATableB: ID-B, VM-B, ID-ATableC: ID-C, Node-C, ID-BTableD: ID-D, Instance-D, ID-C
I have created a record with TableA and added the relationship with other records.
Now, I want to display all the tables combinedly in an interface (The Interface should be combination of all tables)
Could any one please let me know can we do that, if yes Please give some insights that how can can we do that ??
Discussion posts and replies are publicly visible
Hi, You can create a record type and configure other tables in relationship or you can create a database view with all the tables and create a cdt for this view and then fetch the data into the grid.
May i know how can we create a database view ?
you can create view using SQL command. i would suggest you to use appian record if you are not much aware of SQL and JOIN. You can go through below link to see how can we configure table relationships in record type.
https://docs.appian.com/suite/help/22.1/record-type-relationships.html