Question
Vodafone UK Ltd
GB
Last activity: 26 Apr 2020 12:41 EDT
Need to convert sting to a array
Hi Guys,
I have a situation where I need to pass in a list of values to an Connect SQL rule so that I can delete multiple values in a table depending on the ID. I have got the values that I want to delete however these values are integers in the table so when I try to pass in a comma separated parameter the Connect SQL fails. Does anybody know how I can pass a list of values in. Below is my SQL that I'm trying to pass in as well as the values.
DELETE FROM TableName WHERE LATE_REPAIR_ID IN ({Value})
Value = 61,81,61
Thanks
***Edited by Moderator Marissa to update Pega Academy to General***
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
Instead of using ({Value}), we can directly use (Value) to delete multiple records.
Vodafone UK Ltd
GB
Hey. Thanks for you answer but Value here is a property from the clipboard that I'm using. I have only put value as I shouldn't disclose the property name :)
Vodafone UK Ltd
GB
Hi,
Update, I have tried to do what you suggested however it is still not updating any records in the DB. If i manually put the values in they are removed from the DB but if i try to use the clipboard property nothing gets deleted
Synechron
US
What do you see in Tracer ? you should be able to see the SQL and input values. most likely the issues could be with your input values in these case, such as trailing , at the end of values passed. But unless you see tracer it is difficult to understand the problem.
p.s you need to enable SQL query in tracer settings.