Extract queries/formula contents from Dynamic Input tool

[jkv0019]

Hello. My team is working on cutting over to another database system and I was wondering if it's possible to get a list of the databases that queries written inside the Dynamic Input tool referenced. The goal is to get this list of databases and tables and update the connection string to the new database system instead of opening every workflow and making these changes for every dynamic input tool in every workflow. We are running 2021.4.2.

Is is also possible to get what is inside each formula tool as well? Some of our team writes the connection string in a formula tool and uses it to change the entire path when using the Dynamic Input tool rather than write the query inside the editor.

I'm looking for something similar to the Events data that is produced when running a workflow and using that to parse from. As far as I know, the formula tool contents and dynamic input tool contents are not produced.

[cjaneczko]

You could try checking the Workflow Dependencies and copying that data into Excel.

Options > Advanced Options > Workflow Dependencies. Then click on the link at the top that says show Individual tools. That will show every tool in the workflow as well as the source data including file names, Tables and Queries. You can copy the data and paste it into excel to manipulate.