Hi All,
Did anyone tried passing the parameter as in condition for a query database smart service
For example : update tablename set status="test1" where case_id in ac!caseId
How to pass the case ID values of multiple and what is the type of the parameter for this?
Discussion posts and replies are publicly visible
If you are using mysql, then you can use a query like:
UPDATE tablename SET status="test1" WHERE FIND_IN_SET(case_id, ac!caseId)
and the ac!caseId can be set to:
joinarray(pv!caseIds, ",")
where pv!caseIds can be your case id's (I assumed its of type number integer - multiple)
Hi agam we tried like this and it didnt work for multiple values. can you help in any other way
well, It worked for me for multiple values as well.
Here are some screenshots of how I configured.
and I verified the table values were updated as well
Hi agam is it ok if i try tomorrow in the real scenario and let you know so that you can help us if there anything required. i would reply to the same chain
Sure. Whenever you want.
If it doesn't work, can you confirm that you are using mysql and let me know how you are configuring the node with similar screenshots
We are using MariaDB in Cloud version agam
thanks harshav. this should work in mariadb as well.
Hi agam Just as a confirmation this will work for dynamic values (i mean passing the values into the ac from a process variable) and the list of taskIds are huge .. and this shouldnt be a problem.
This would work for dynamic values as well. You could use any pv variable to define the acp.
How many taskIds are you expecting? I would suggest doing some testing on your end on these large set of id's
however, I don't see any major concerns.