Is there a way to document a sql query utilized to pull a table from from a odbc connection in an input tool? Please see the attached image of where the select statement I am trying to add to my final report is located.
Perform the query IN-DB. use dynamic output In-DB to capture the query.
or...
put input tool in a batch macro. send query in out workflow to control parameter. action tool 1) updates input data tool. action tool 2) - updates formula tool to create new column of query data.
You can build the query in a formula tool or just put it in a Text input tool if it's static and pass it to a Dynamic input tool set to Replace a Specific string. If you also use Pass a Field to the output, you can append the query to the results from the database.
