Currently, within the JDBC node, there is no configurable option to do a pass through of input fields in the same way as you can with an HTTP node. We have an existing enhancement request to have this feature introduced; LAE-21982- Support PassThroughFields on JDBC Query node.
As a workaround, if you have output fields from the SQL Query then you could do a simple join of the SQL output to the associated input record entry.
Alternatively, you could use this code:
select ? as "OutputFieldName", <rest of query> from table
and put the field you want to pass through in your field bindings parameter.
Comments
0 comments
Please sign in to leave a comment.