Does anybody know how to add the following attribute to a CDT definition: dynami

What is it that you're trying to achieve?

If you are working on live process instances then you can go with "IFM Manager" and "Process Upgrade". If you just wants to update the CDT structure then edit the structure in design mode or you can edit the XSD file, upload it again. Check the dependents, precedents on this CDT to check whether it is correctly updated or not.

My database is Microsoft SQL server and I want a column to have a default value of zero. I have read that Hibernate will pass NULL to columns that do not have a value in the INSERT or UPDATE queries. So I would like to specify in the XSD the attribute "dynamicInsert = true" so that Hibernate does not do that and thus my column will have zero as its default value. If it was a Java annotation, I would know how to do it. But in the XSD that Appian expects, I do not have a clue.

@Orlando, this is the list of accepted JPA annotations:

https://forum.appian.com/suite/help/16.2/Custom_Data_Types_from_XSD.html#Using_JPA_to_Map_to_an_RDBMS

Something that might work is using the @Column definition like so, using 0 as the default.

@Column(name="Price", columnDefinition="Decimal(10,2) default '0'")

Let me know if this helps.