Editing multiple Database Reader nodes at once

Hello all,

I've been using Knime now for about 3 months and I have to say I am really satisfied with the product!

One question I can't find a solution for: I have a workflow with multiple Database Reader Nodes with a date in the SQL-scripts that I have to run every day. How could I change this date without having to click trough all the nodes separetely?

Thanks for any help in advance!


You could create the SQL string once and make it a flow variable. Then set the SQL for the database reader  to this flow variable. (I assume this would work)

Thanks for the reply! Could you please explain which nodes should I use to make this happen? 

I've put up an example but I don't have an available databse to be able to check if a real example would work.