• State Not Answered
  • Replies 12 replies
  • Subscribers 10 subscribers
  • Views 4360 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Column definition mapping 'uniqueidentifier '

ajinkyab277
Certified Lead Developer
Is there any by which I can map Sql server database row with data type 'uniqueidentifier ' with appian column.

OriginalPostID-245193

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 2
    Hello Ajinkya, If you are fetching the data from SQL Server DB, then can use string as shown in below format: <xsd:element name="ProjectId" nillable="true" type="xsd:string">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">
                                  @Column(name = "ProjectId" columnDefinition="uniqueidentifier")
                        </xsd:appinfo>
    </xsd:annotation>
    </xsd:element>

    Regards,
    Vinit.
Reply
  • 0
    A Score Level 2
    Hello Ajinkya, If you are fetching the data from SQL Server DB, then can use string as shown in below format: <xsd:element name="ProjectId" nillable="true" type="xsd:string">
    <xsd:annotation>
    <xsd:appinfo source="appian.jpa">
                                  @Column(name = "ProjectId" columnDefinition="uniqueidentifier")
                        </xsd:appinfo>
    </xsd:annotation>
    </xsd:element>

    Regards,
    Vinit.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.