If I wish to add another column name called "BACKUP_ON", which must contain a underscore as requirement, how should I do?
I tried add another row called "backupOn" at datatype, but it turns to be "backupon" at back end structure, if i changed it to "BACKUP_ON",
then it create another "backupOn" at back end database table. But the backupOn at cdt datatype write into column "BACKUP_ON" of previous,
so this might be two bugs, one is "BACKUP_ON" generate to be "backupOn" if create datatype of existing table, but if create backupOn from original of scratch then it will changed to be "backupon" at back end, if changed to be "BACKUP_ON" then it will generate another "backupon" columns at table.
Second, the backupOn should write into "backupon" of second later created by responding relationship, but it write into the first "BACKUP_ON". So i doubt this might be two bugs.
Any one help me create a "BACKUP_ON" with underscore at database?
Discussion posts and replies are publicly visible
This will require some XSD manipulation. Find details here
docs.appian.com/.../Custom_Data_Types.html
Then how to do it?
Did you read the documentation? It is described on that page.
https://docs.appian.com/suite/help/21.3/Custom_Data_Types.html#create-new-version-from-xsd
On top is the link to this page
Supported XSD Elements and JPA Annotations
And then, you will end up with an <element> definition in your XSD such as:
<xsd:element name="BACKUP_ON" nillable="true" type="xsd:dateTime" > <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(name="BACKUP_ON", columnDefinition="datetime NULL")</xsd:appinfo> </xsd:annotation> </xsd:element>
The other posters are correct, but one other way you can approach this is by creating the table in the database first. If you set up the table and define the column as "BACKUP_ON", then you can use the wizard to create a CDT from an existing database table.
what if i want to add a separate column individually at later time?
Unknown said:Did you read the documentation? It is described on that page. https://docs.appian.com/suite/help/21.3/Custom_Data_Types.html#create-new-version-from-xsd On top is the link to this page Supported XSD Elements and JPA Annotations
Simply put, it's really just a 2-step process to add a new column:
1) add the column in your DB, either manually or via a SQL script (the former is a little easier to do on-demand, the latter is a little easier to deploy to other environments). I suggest you practice both of these methods as it's usually pretty likely that a mixture of both will be required within an actively-developed project.
2) edit the XSD of your Data Type to add the new column where it's desired, specifying the name it will be given in the CDT and specifying the name of the DB table column it's located at, which is fairly easy because you can just reference how the other columns are set up at editing time. Then in the data config screen, use the "update from XSD" option with your edited/saved XSD file.