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
Discussion posts and replies are publicly visible
Hi Kiran,
You can follow the below example to add transient columns to CDT without having them added to the database.
<xsd:element name="dummy" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Transient</xsd:appinfo> </xsd:annotation></xsd:element>
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