Hi All, anyone have experience on update multiple row on data store using Query

heriz over 9 years ago

Hi All, anyone have experience on update multiple row on data store using Query Database smart service?
Below is my SQL Statement :
UPDATE `Appian`.`einregcustomer` SET `flagadd` = '1' WHERE `einregcustomer`.`idcust` in (ac!cust)

ac!cust contain multiple value like 8,9,10 where user selected in paging grid on previous user input task.
With statement above, only the first row success updated. The next rows not updated.
Thanks before for your kindly response.

...

Discussion posts and replies are publicly visible

Parents

0 heriz over 9 years ago

Hi Eduardo, yes its mapped to PV and I had set it to multiple too.
I attach the screenshot below, and the query statement still same :
UPDATE `Appian`.`einregcustomer` SET `flagadd` = '1' WHERE `einregcustomer`.`idcust` in (ac!cust).

On the user input task, I only show paging grid for user to select cust, then I save the selected cust Id to pv!selectedCust.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 heriz over 9 years ago

Hi Eduardo, yes its mapped to PV and I had set it to multiple too.
I attach the screenshot below, and the query statement still same :
UPDATE `Appian`.`einregcustomer` SET `flagadd` = '1' WHERE `einregcustomer`.`idcust` in (ac!cust).

On the user input task, I only show paging grid for user to select cust, then I save the selected cust Id to pv!selectedCust.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data