How to display data in record type from two tables?

Question

I want to display data in single record type from multiple tables

sindhum950 · Accepted Answer

Hi Muhammad, 
 
Please create a view in the database, which will get data from both the tables. 
Then create a CDT for that view. 
Then create the data store entity and use that for creating the record (Entity backed record) 
 
This way, the record will have the data from both the tables. Please let me know if this works. 
 
Thanks, 
Sindhu

aloks0189 · Answer

Hi Shoaib 
 Can you please download the xsd of your CDT and check whether @entity annotation refers to the same view which you have created in DB or not. 
 Also if this doesn't work, try downloading the DDL script from Data store entity design object and check the view name it's going to create and check whether this name and your view name matches or not. 
 Also make sure, you have created the view under the same schema which is linked to your data store entity design object. 
 Still if you are unable to resolve this issue, I recommend, please upload your CDT here as well as your View name ( AVAILABLE in DB) so that practitioner can help you to resolve this issue. 
 Also make sure, you have defined any one of the field of your CDT field as Primary key (but not Auto Increment) otherwise, while publishing the data store it will create a column named as Id (Primary key) 
 Hope this helps.

sharayut · Answer

Hi Muhammad, 
As everyone in the above comments have suggested you need a to create a view with all the columns you require from the both the tables. With the help of view you can get data and display it on you record.

namratak356 · Answer

Hi Muhammad, 
 
 As suggested, you can create view in database and its corresponding cdt in Appian, Record type will point to View Datastore Entity, 
View definition will contain data from both tables, you can make use of Analytical function in SQL if table has one to many relationship. 
 
Thanks 
Namrata

abishekk109 · Answer

Create a relational view considering both the tables and use the view to create a record. 
 
Thanks, 
Abishek

aratim · Answer

Hi Muhammad, 
 
I agree with the comment of other practitioners. Create a view with all the columns you need from 2 tables. 
And using CDT, display the data in grid. 
Thanks.

saurabhp0002 · Answer

As suggested by many, View is the only option to achieve it where as we should be logical while doing so. we should always make use of relevant join to reduce the count and data. As if it has lot many user filters and #of rows in view is high, it might result in slow performance as compared to Table. 
it is always advisable to create the record type from table and record summary can have relevant data from various tables which may result in # of transactions but better performance.

Preji P · Answer

Hi there, 
As suggested by others, you can create the View of the tables(one or more) you want to pull data from, but would like to add one more important point here. 
 
This view should have at least one primary key column, other wise when you try to publish the data store entity it will error out and you would not able to proceed,.