08-03-2020 08:25 AM
Is there a way to log ( or to see) the output of an expression after the expression is completely evaluated for parameters.
Example : I am using a Generic JDBC execute to retrieve data from a table. This table is a parameter that is being passed from parent pipeline.
so my SQL-Statement expression looks like this. "select * from “+ _tableName + " where joindate=”+ Date.now()
My requirement is, I should be able to see the final prepared query that reads like "select * from employee where joindate = ‘7-31-2020’ "
08-14-2020 12:51 AM
@Bobby - for such cases use mapper before JDBC execute snap then you can find the query you wrote.Then use the target variable from mapper into JDBC snap (don’t forgot to enable the expression = )🙂