Dynamic Values

JDong

Hi All @Jonathan-Sherman, @atcodedog05  @Qiu  

I have a SQL query and extracting data for my flow using the input tool.

Now I have defined a where clause that says City = 'SF'

SlNo	Value	City
1	100	SF
2	200	Manila
3	300	London
4	400	Beijing
5	500	Perth

How can I actually replace the SF and parameterize this on runtime. So at runtime user can select the City and pull only that data from the query.

Can you please advise ? Thanks

Jonathan-Sherman

Hi @JDong,

You'll want to use a dynamic input tool to solve this.

The dynamic input tool works in a similar way to the standard input tool, start off by adding your query and connection string in the "Input Data Source Template" (by clicking edit). The main difference between this tool and a standard input, the dynamic input takes an incoming connection (in this case would be the city value you want to pass into the query), we can then modify the SQL query through the configuration pane of the tool.

Select "Modify SQL Query" -> "Add" -> "SQL: Update WHERE Clause"

This will pass the new City value into the query and dynamically edit the WHERE clause you selected. If you have any questions just let us know!

Kind regards,

Jonathan