Forum Discussion

Bobby's avatar
Bobby
New Contributor
5 years ago

Expression output

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

  • Supratim's avatar
    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 = )🙂