Passing the workflow constant to SQL Query "from" statement

[tamluenwai29]

Dear All, 

I have created a workflow constant and named it to "Parameter", and the value of this constant I have defined to "completion".

I am trying to pass this value to SQL query in the from statement, but I got a syntax error.

Can someone give me some advice on it? Thanks a lot!!

I would like to perform something like this, which implies when I update the workflow constant the query result will be changed. 

i.e.,

Workflow constant= "ABC"

select * from dbo.vw_iPM_inform_ABC

Workflow constant = "211"

select * from dbo.vw_iPM_inform_211

 

[Yoshiro_Fujimori]

@tamluenwai29 ,

I understand SQL in Input Data Tool is passed to the database as it is.

To update a specific string in SQL dynamically, I would pass it via Control Parameter Tool.

Sample SQL

select Column1, Column2

from [YourTable]

where Column2 = '%Param%'

And update the string %Param% with the data from Control Parameter Tool with Action Tool.

I hope this helps.

[tamluenwai29]

Hi, 

Thanks for your reply. But I would like to know is there any other methods to perform the same task except using macros? Thanks!

[Matt_D]

Hi @tamluenwai29 

If you want to go down the route of changing workflow constants, and updating the SQL without a macro you could just have your parameter and query in a text table, use a filter tool to filter by the constant and then dynamically update the SQL clause.

If the query is static apart from the end value, you could just use a formula tool to update the query instead

Thanks,

Matt