I want to pass a custom value to the SQL input query during runtime

annamalaimoorthy

I have a workflow which has an input SQL query as below

SELECT * From TABLE
Where TABLE.COLUMN1 = '2020-12-31'

I want the user to be able to input the date when the workflow is triggered to run on the server. 

Is there a way we can do this ? 

I tried creating User constants in the workflow tab, and looks like i cannot reuse them inside a query, those constants are accessible only in formula tool. 

yogi01061

please find below steps,

1) inorder to use indatabase tools, you need to create a connection first (refer to Indatabase and manageindb screenshot)

2) once the connection is created take the connection name and replace the same in text input tool 

similarly place the correct table name in the Field1 sql query  (refer to text input screenshot)

once you have done above, you should be able to execute the workflow as a app by clicking on the magic wand.    (refer to executescreenshot)

hope this helps

indatabase.png

manageIndb.png

text Input.PNG

execute.PNG