Hi everyone
im new with appian and im trying to understrand how can i update for exemple a record in table in my db , in the process model.
i see that we only have a node for write in the datastore , but what is the best practice to update a specific row with the id etc.. like in SQL.
How we doing this with the configuration with that node of write to datastore entity ???
Discussion posts and replies are publicly visible
Hi,
If your intention is only to update a record We do have Query Database smart service, In which you can provide a update query similar to SQL by giving where condition as your primary key. Hope this helps!!
There is no field level update. Load the CDT row from DB, change the fields as required and store the row back to DB.
I highly recommend to NOT use the Query Database smart service. It will not work in conjunction with synchronized records.