Skip to main content
August 15, 2024
Solved

Hi, I am planning to take certification for ACD101 and i have couple of questions. Could anyone help me to clear my doubts.

  • August 15, 2024
  • 10 replies
  • 0 views

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. 

    Best answer by stefanhelzle0001

    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.

    10 replies

    stefanhelzle0001
    August 15, 2024

    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.

    August 15, 2024

    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??

    stefanhelzle0001
    August 15, 2024

    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.

    December 12, 2024

    Though strangely worded. The answer to your question is 1.