cancel
Showing results for 
Search instead for 
Did you mean: 

Expression output

Bobby
New Contributor

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’ "

1 REPLY 1

Supratim
Contributor III

@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 = )🙂