We have a CDT (Response_Details), and one of the fields in the CDT (answerId) is an integer array. When we published this CDT to DS, it created a table internally. Is there a way to customize the table name and column name generated by Appian for this? Can we use any annotation to achieve this? I know we can create a new CDT and create an one-many relation in the Response_Details CDT to map the data, but if there is any way we can customize the table / field names for the table auto-generated by Appian for publishing the integer array field, that'll be helpful. Thanks in advance.
Discussion posts and replies are publicly visible
Take a look here. Essentially Appian will honor any JPA annotations you add to the CDT's XSD file when creating the corresponding table.
Have you specified the table name using an @Table annotation within your XSD?
Please refer the below link looks like
https://forum.appian.com/suite/help/16.3/Custom_Data_Types_from_XSD.html
after the end tag of "complexType" of IA_Response_Details, we need to start one more complex type of "IA_Map_Response_Answer" in this way it will create a relationship table.