# Flow script

**URL:** <https://forum.novacura.com/t/flow-script/1129>\
**Category:** Flow Classic\
**Tags:** studio-or-server, portal\
**Created:** [April 30, 2026, 2:51pm UTC](https://forum.novacura.com/t/flow-script/1129 "2026-04-30T14:51:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bhaski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/bhaski/32/460_2.png) [@Bhaski](https://forum.novacura.com/u/Bhaski)\
**Post date:** [April 30, 2026, 2:51pm UTC](https://forum.novacura.com/t/flow-script/1129/1 "2026-04-30T14:51:30Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![OlaCarlander](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/olacarlander/32/205_2.png) [@OlaCarlander](https://forum.novacura.com/u/OlaCarlander)\
**Post date:** [May 1, 2026, 3:55pm UTC](https://forum.novacura.com/t/flow-script/1129/2 "2026-05-01T15:55:17Z")

</div>

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.