Question

how to create a column in the back end with a name contains underscore?

Forum|Forum|4 years ago
November 3, 2021
8 replies
0 views

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?

stefanhelzle0001

Brainy

This will require some XSD manipulation. Find details here

docs.appian.com/.../Custom_Data_Types.html

L

luzhew0001Author

Then how to do it?

stefanhelzle0001

Brainy

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

csteward

And then, you will end up with an <element> definition in your XSD such as:


  
    
      @Column(name="BACKUP_ON", columnDefinition="datetime NULL")

peter.lewis

Employee

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.