CDT with extra column

Question

Hi everyone, 
 CDT with 6 columns and database with 5 columns, Can we map that CDT to database table without adding 6th column in database? 
 Thank you all in advance! 
 Regards, 
 Kiran Sajjan

Parag Ranjan · Answer

Hi Kiran , You can follow the below example to add transient columns to CDT without having them added to the database. @Transient Note: While you fetch data from database using query entity, it will throw error. The workaround is to use selection parameter of a!query. Below link explains how to retrieve data if a transient column is present. https://community.appian.com/support/w/kb/659/kb-1404-queryentity-fails-when-an-xsd-has-a-field-marked-as-transient

Harshit Bumb (Appyzie) · Answer

Yes. It is possible . If you add the @Transient annotation, you'll be able to achieve it. See the sample below. 
 
 Find more of such annotations here - docs.appian.com/.../Supported_XSD_Elements_and_JPA_Annotations.html

CDT with extra column

Top Replies