I'm using a Dynamic Input tool inside a standard Macro. Intention of this is to allow users to input connection string to server to then run some sql.
macro user input takes connection string, db schema, table name.
those inputs are put together and passed as a field going into the dynamic input tool, at which the tool is configured to 'Change Entire Path' with the incoming field that has been updated with the connection|||query.
This was working in prior version (2021) and now failing on 2023.2.
The problem is that the dynamic tool is inserting a 'select * from' by default before the actual query. so then the query fails because it doesn't end up being a real query when executed.
its getting added *here connection|||*query