Skip to main content
New Participant
January 8, 2021
Question

Process Model with three "Write to Data Store Entity" Adding the Same data multiple times in the data store entity: How to Pass record ID among all "Write to Data Store Entity"

  • January 8, 2021
  • 1 reply
  • 0 views

Case 2: Process Model with three "Write to Data Store Entity" Adding the Same data multiple times in the data store entity:

Step 1: I have a Process model which takes input from the User through an interface and add record to the data store entity (X). 

Step 2: Using the user input field, the process model assigns the task to the approver for updating certain fields. Now, Approver updates the required field for the same record (Using second Write to Data Store entity to store the data here to save Approver's updates).

Issue: The second Write To Data store Entity is adding a new row in the data store entity instead of updating the same record.

So, how to pass the ID variable among different "Write to Data Store Entities" in the same process model? 

1 reply

pedro.simoes
Participating Frequently
January 8, 2021

Hi [mention:cb641242762d45d9b02e6c6bb323c684:e9ed411860ed4f2ba0265705b8793d05],

You'll need to use the Stored Values output field of the first Write to Data Store Entity so that your CDT is updated with database generated PK.

docs.appian.com/.../Write_to_Data_Store_Entity_Smart_Service.html