Pulling SQL Query From ODBC Input

[Da_Norman]

Hi Everyone,

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.

[apathetichell]

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.

[TimN]

Hi,

Take a look at the Field Info Tool found in the Developer folder.  It gives metadata including source sql.

[danilang]

Hi @Da_Norman 

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.

Dan