• State Not Answered
  • Replies 12 replies
  • Subscribers 10 subscribers
  • Views 4358 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, Below is the code snippet, I was able to insert value from Appian to Unique Identifier of MS SQL:

    executequery(cons!DATABASE, "INSERT INTO Employoee (
    AttachmentId,
    RequestId,
    CustomerId,
    )
    VALUES (
    NEWID(),
    CONVERT(uniqueidentifier,'"&ri!RequestId&"'),
    CONVERT(uniqueidentifier,'"&ri!CustomerId&"')
    )")
    Where both rule inputs are of type text, passed from a process model to this rule.
Reply
  • 0
    A Score Level 2
    Hello Ajinkya, Below is the code snippet, I was able to insert value from Appian to Unique Identifier of MS SQL:

    executequery(cons!DATABASE, "INSERT INTO Employoee (
    AttachmentId,
    RequestId,
    CustomerId,
    )
    VALUES (
    NEWID(),
    CONVERT(uniqueidentifier,'"&ri!RequestId&"'),
    CONVERT(uniqueidentifier,'"&ri!CustomerId&"')
    )")
    Where both rule inputs are of type text, passed from a process model to this rule.
Children
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.