Replace database query parameters with array

Olaide

I am trying to make an sql query as shown in the screenshot but I am having issues replacing the parameters as some of them are arrays, how can I prevent the error on the right and have the array render properly in the query without the square brackets

Max

did you try to extract that values from arrays by applying something like "first" filter to them or something? if theres always a single value in array, i think its safe to just reference first item from array and extract it as a final value. at least i would try that 1st

Olaide

thanks for your response @Max. The array will contain more than one value