Skip to main content
K
kyleg0003
December 29, 2021
Question

How to access Database Generated UUID in Process Model

  • December 29, 2021
  • 3 replies
  • 0 views

Hello, 

The basis of this question is in the subject. What is happening is that we have a trigger function in our database that creates a 32 varchar UUID for each record when they enter our database. My issue is that since the UUID is not generated by Appian in the Data Type it doesn't pull it into the process. Since everything is a process variable I would need to pull information into the process model. Where I am coming into an issue with is how I would do this. 

More information no other column in the database is Unique so querying from the database would be difficult as things may repeat. Any information is helpful thank you in advance!

3 replies

vinayp0002
vinayp0002
December 30, 2021

Hello [mention:5fd098c31f0c48d8bf4c5aa8c239dff4:e9ed411860ed4f2ba0265705b8793d05],

There would be some time lapse between getting data back into Appian process model and insertion of trigger data into the database.

You can re query the data from the database in order to see the generated UUID by trigger. 

K
kyleg0003Author
December 30, 2021

How would I get the Generated UUID back? The only reason I ask this is because I am not sure how to query the record that it currently is processing. Do you have any insight on this?

vinayp0002
vinayp0002
December 31, 2021

[mention:5fd098c31f0c48d8bf4c5aa8c239dff4:e9ed411860ed4f2ba0265705b8793d05], you need to query the record that is already processed in a different node. 

I would suggest you to use a composite key(createdBy , createdOn etc...) which can be unique in order to query the processed record.

Terms & ConditionsAccessibility statement