Skip to main content
J
jesseb0003
April 7, 2022
Solved

How to SYNCH CDT after adding field to database

  • April 7, 2022
  • 4 replies
  • 0 views

Added a field to a database table.  The CDT based on the table does not have the new field after running SYNCH.

Not sure of the correct way to accomplish. 

If need to  Download XSD, make change manually, and then Upload XSD, what is the process to upload XSD and apply it.

    Best answer by balaganeshb0004

    Hi [mention:adf3b9728fc64773bcd59d1be70ce20f:e9ed411860ed4f2ba0265705b8793d05], please go through this course "Design Advanced CDTs For RDBMS Schema Management". In that, the topic "JPA Annotation" will give you adequate knowledge on editing CDTs and XSDs.

    4 replies

    gopalk2865
    gopalk2865
    Participating Frequently
    April 8, 2022

    Hi Jesse, the new field will not be updated automatically in your cdt. You would need to update the xsd and re-upload with new field added. You can click on cdt and once it opens,  

    To download the XSD file for a data type, click Download XSD in the settings menu of the data type designer.it would be on top right hand side with gear symbol.

      sunilnaikb0002
      sunilnaikb0002
      April 8, 2022

      Nice [mention:8b930cc189ea4ddf8fcb9c275d619049:e9ed411860ed4f2ba0265705b8793d05] [emoticon:c4563cd7d5574777a71c318021cbbcc8]

      [mention:adf3b9728fc64773bcd59d1be70ce20f:e9ed411860ed4f2ba0265705b8793d05],
      FYI, To update the XSD after downloading, Please check the code in the document and add another column that you wanted with all the desired attributes and save it.

      To upload a newer version, please click on settings gear icon on the CDT and click click on "Create new version from XSD" to upload the document you edited before.

      Later verify the CDT with your data store and this is done. [emoticon:c4563cd7d5574777a71c318021cbbcc8]

      balaganeshb0004
      balaganeshb0004Answer
      April 8, 2022

      Hi [mention:adf3b9728fc64773bcd59d1be70ce20f:e9ed411860ed4f2ba0265705b8793d05], please go through this course "Design Advanced CDTs For RDBMS Schema Management". In that, the topic "JPA Annotation" will give you adequate knowledge on editing CDTs and XSDs.

        peter.lewis
        peter.lewis
        Employee
        April 8, 2022

        The other posters are correct that you download the XSD and modify it, but personally I almost never do that. Instead, I typically either:

        1. Make the change in the Appian CDT first, then publish the data store again. This will automatically add the new column to your table in the database
        2. Make the change in the database and make the same change in the Data Type Designer. Unless you're doing something complex, most of the time you can just add the field directly in the UI and it will map correctly.
          Terms & ConditionsAccessibility statement