Skip to main content
Y
yanivb0001
February 9, 2022
Solved

NEW TO APPIAN TRYING TO UPDATE A Multiple Coloumns in the Database Table

  • February 9, 2022
  • 21 replies
  • 0 views

Hi everyone 

i have a Table ( the name of the table is creditrequest)

and im trying to understand how can i  update coloumns values in a specific row  (with a specific id of creditrequest )  after that i inserted a row of creditrequest in the db for exemple.

i use also an interface where i saved those values, in the purpose of update the table.

 

Best answer by mikes0011
but in the process history i cant see it

The process history tab will show every state of the PV variable, so if it has the PKid at one point and then doesn't have it at another point, it will show you where - make sure you click through if there are multiple pages.

21 replies

mikes0011
mikes0011
Brainy
February 9, 2022

You don't show the value of the CDT in your process instance following the form where these fields are being updated, so I can't be sure here - basically as long as the CDT has the Primary Key ID populated, then re-writing it using the WTDS node will cause that row to be updated with the current value of the CDT (including the updated fields).

The Expression Guru
Y
yanivb0001Author
February 9, 2022

do you talking about this  the value of the CDT in my process instance ?

this is what i have after completing the form

mikes0011
mikes0011
Brainy
February 9, 2022

If your hope is to update a row that already exists in the DB, then you'll need to query the value of that row (and/or multiple rows you want) into the PV prior to arriving at the form.  Then on the form you can save new values into the desired specific parameters, and in the subsequent process flow you can write the new state to the DB. 

In your screenshot here, it does not appear as if the Primary Key IDs are populated in your instance's PV, meaning when it writes the PV to the database next, it will write to new rows (with new PK IDs).

The Expression Guru
Terms & ConditionsAccessibility statement