Question

6
Replies
69
Views
GautambirSinghS Member since 2019 1 post
Vodafone UK Ltd
Posted: April 22, 2020
Last activity: April 26, 2020

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***

Data Integration Low-Code App Development Technology Services
Share this page LinkedIn