SQL filter by a Temporary combined column

Hi @AndrewDeacon , you are already on the right lines. The attached workflow gives one possible example of how a SQL query in a DB Query Reader can utilise the values from flow variables to “pre-limit” the returned data from an H2 sql database. You will have similar constructs in your database, and should hopefully be able to apply something similar.

db_pre_select.knwf (26.1 KB)