Hi All,
Please help me with the below query.
1) created the variables in the start node and updating the data to DB by uing write to data store entity and it successfully creating the lines items in DB
now, we want the update the values through process model which is already present in the DB.
thanks in advance.
Discussion posts and replies are publicly visible
So, you know you can Write INSERT statements to DB. That happens when you either don't provide an ID, or one like -1, or the ID you provide doesn't correspond with an existing row. If the ID DOES map to an existing row, Appian automatically converts to an UPDATE statement.
Whether it's INSERT or UPDATE is determined at runtime on a row-by-row basis. You want this data in that row, you got it!
This does present a challenge for how to force Appian to pick either only Insert or only Update. If you need to UPDATE, you have to be absolutely certain you have the row ID. If you want to make sure you do INSERTs, you have to be absolutely certain you do NOT have the row ID.
Yeah if you want to make new entry always, you can ignore output mapping for stored values. Then it will make new entry always.Suppose you feel like once inserted an entry and needs to update same entry further in process then take store output mapping to process variable. so next time when you write data to DB it will update.So always for update or delete it will expect identifier