How can I change my query dinamically?

Question

Good Morning.

This is my workflow project.

In input tool I do a query where:

SELECT * FROM TABLE

WHERE DATE='20220930'

Date value is a DEFAULT.

I use Dynamic Input to change a string of my query (specifically 20220930) and the text box Interface to allow to user to insert a Date. In my idea the Interface value must change the date (so I don't operate on workflow) but the output has always the 20220930 data.

Can anyone help me?

Thanks!

davidskaife · Accepted Answer

Hi @sebenciven

Is there a particular reason you're using the Dynamic Input tool? You should be able to discard it and connect the action tool directly to the input tool, and update the date within that SQL statement, i've attached a screenshot of a similar example I've done using a control parameter: