• State Suggested Answer
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 12 subscribers
  • Views 7494 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Database column names mismatch with CDT field names

Sudipta Biswas

I have a CDT with field names having underscore in it (Eg. "first_name"). But when I am trying to create a table, the underscores are not coming in column names of database table. I need exactly the same names(with underscore). Is there any possible way to get it?

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    Hi Sudipta,
    Download the XSD of that CDT and edit that as below for specific element.

    <xsd:element name="first_name" nillable="true" type="xsd:string">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">@Column(name="first_name", length=100)</xsd:appinfo>
    </xsd:annotation>
    </xsd:element>

    Reason why we use XSD upload for CDT creation, we can modify constraints and properties as we need. Thanks
Reply
  • 0
    Certified Lead Developer
    Hi Sudipta,
    Download the XSD of that CDT and edit that as below for specific element.

    <xsd:element name="first_name" nillable="true" type="xsd:string">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">@Column(name="first_name", length=100)</xsd:appinfo>
    </xsd:annotation>
    </xsd:element>

    Reason why we use XSD upload for CDT creation, we can modify constraints and properties as we need. Thanks
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.