Flow script

Flow Classic
,
1

Hi Gurus,

I have a query.

In a assignment step i did a join which is giving data Convar = PR1,PR2

Now I used that joined variable in a sql quey whère data select

…

Where pr in (convar)

which is nit giving me data

But how I can do this because i need to pass multiple values to a sql query to get the result.

BR,

Bhaskar

2

Example (MSSQL):
WHERE Id IN (@listVariable)
is rewritten internally to:
WHERE Id IN (@p1, @p2, @p3, …)
with each value bound as a parameter.

@listVariable can only be a list of values, not a complex structure.