Hi Everyone, I have to update some columns for multiple IDs in database. Ca

anilkumark over 8 years ago

Hi Everyone,
I have to update some columns for multiple IDs in database. Can any one suggest me how to update and which node is better to use "Write to Data Store Entity" or "Query Database" or "Stored Procedure" node?
Thanks in advance.

Discussion posts and replies are publicly visible

Parents

0 Sathya Srinivasan
Appian Employee
over 8 years ago

In order to update multiple values of a CDT, the easiest way is, in a script task, set the multiple value to be saved into the CDT[].element.
for e.g. you can save {John, James} --> Save Into cdtArray.name
Repeat the same for others as well. As long as the size of the cdt array and the array size you are saving are same, the corresponding index will be updated with the values you are attempting to save.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sathya Srinivasan
Appian Employee
over 8 years ago

In order to update multiple values of a CDT, the easiest way is, in a script task, set the multiple value to be saved into the CDT[].element.
for e.g. you can save {John, James} --> Save Into cdtArray.name
Repeat the same for others as well. As long as the size of the cdt array and the array size you are saving are same, the corresponding index will be updated with the values you are attempting to save.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data