Update WHERE clause in SQL query in Input Tool based on User's input

Question

Hi, I am trying to create a workflow, to update the WHERE clause in SQL query which is asking the user to input the Period Name in MMM-YY format and update the same in the Input tool. It doesn't seem to be working for me. Please take a look at the screenshot.

Mariamfatimamirza · Answer

Yes, I did use the magic wand. It still didn't work. However, I created a new workflow, and applied the same logic, and it seems to be working fine now. Thank you for looking into this.

dYoast · Answer

@Mariamfatimamirza ,

How are you testing?

If you are just running the workflow, it uses the value you have in the input tool.

To better test, click the wand icon and it will test as an app and allow you to enter a different value.