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!
Discussion posts and replies are publicly visible
Hello Kyle G,
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.
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?
Kyle G, 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.