Create a view by joining two CDTs

Hi Eric, If you get the data from DB for those CDTs and you can create a view joining those two tables.
Else if you want to handle these joins in Appian without creating view then please use the CDT manipulation Plugin
community.appian.com/.../cdt-manipulation

You can use the joincdt function mentioned by chandu in below comments, However it is recommended to create a view with join you required in database and created cdt for that view (Note: As Join is the database servers core functionality they execute faster there)

Hi Eric,
Creating view in the appian database and querying the data is recommended

Hi Erics,

As per the Appian best practices, its always recommended to create a view(will all data manipulations) and then create a CDT that holds the view structure, publish it in Data store . Then create a query rule referring to that DS to fetch the data.

Thanks,
Sindhu

Sindu, "Then create a query rule referring to that DS to fetch the data." May be you forget that Query Entity is more faster than Query Rule

its a typo, its Query entity only not query rule

its correct

Hi Sindhu,

While creating CDT for the view in DB what is the annotation which we need to use in CDT XML schema which will differentiate the VIEW from a normal TABLE CDT.

Regards,
Balaji.R

Hi Balaji,
We can use @Table annotation for table or view. for more info on it please go through,
docs.appian.com/.../Mapping_CDTs_to_Pre-defined_Database_Tables.html

Hi Chandu,

Thanks.

Regards,
Balaji.R