How to parameterize the DB Row Filter with flow variables (WHERE-IN clause)
Could someone help me with the following problem?
I want to parameterize the DB Row Filter with flow variables. To get familiar with the flow variable configuration I would like to consider a very simple case. The DB Row Filter shall perform the following task: Search in a column ‘Source ID’ for the entries ‘1000001234’ and ‘1000001235’. So, behind the scenes the knot should do the following:
SELECT * FROM mytablename
WHERE SourceID IN (‘1000001234’, ‘1000001235’).
My flow variable tab looks like this.
DB Row Filter Parameterization with Flow Variables.pdf
How do I have to set up the parameters?
Thanks a lot for your support!
Heiko