How to correctly pass a flow variable into DB Query Reader's "?" placeholder? (Error: No value specified for parameter 1)

[takbb]

Glad to hear this helped @zzkary .

For your question of building an IN ( ) list, there are a few options that you can find discussed in the following post from 2022.

DB row Filter with String Widget

Hi All, I have a table which has over 10 million rows. I want to filter on a column which is categorical and i want the user to select multiple categories right at the start of the query. I don’t want the DB Reader node first since that takes in a lot of time. How do i add a list of my choices as a flow variable to my condition in the DB row filter? For example:- My DB Table selector has a custom query select a,b,c,d from xyz; then DB row filter has a condition of b = ‘1234’ set i am conn…

I suggest reading that whole thread through ( as back then I was still learning about this stuff too and my understanding evolved during that thread thanks to @ipazin ), and also try the workflows that are attached within the posts. I think it should give ideas that cover your question. If anything is unclear, feel free to ask further…