I need to change the name of a field of an existing CDT to match database field. The CDT is backed by database entity whose data store has the automatically update database schema option disabled. The old column name is EMPLOYEEID and the new column isEMPLOYEE_ID.how to proceed further.
1. Download the CDT as XSD, make the appropriate changes, and re-upload the XSD, verify and publish the data store.
2. Rename the field in the record type in appian to automatically update the CDT field.
3. Rename the field in the CDT in appian. Verify and publish the data store.
Discussion posts and replies are publicly visible
Where is this question coming from?
IMHO no answer is correct as all rely on the disabled automatic schema management. And answer 2 mentions records, but the question is only about CDTs and data stores.
Thanks for your response, I need to know what is the correct scenario when automatic update database schema is disabled should i first download the CDT as XSD and rename the employeeid field and publish or i should directly make changes to CDT and publish the data store??
The point here is, that you need to manually make changes to the CDT and the database. In case you want to modify the mapping between the field in the CDT and the database, you need to edit the XSD and the database.
Thanks Stefan Helzle for your response. If I need to modify the column I will first make changes in CDT and then in my database, in that case my option 1 is correct right.
No, this option misses the changes in the database table.
We do not need to make changes in the database we need to rematch the renamed database field.