I want to be able to define the WHERE clause of a JDBC adapter service (SELECT template) at runtime. Take the following SQL statement:
SELECT * FROM myTable WHERE myField = ?
I want to map a value on the pipeline to “?”. Is this possible? So far, all I can figure out how to do is hardcode a value for “?” when configuring the adapter service.