Ask Your Question

Revision history [back]

This won't work, since the expression is only evaluated once. This evaluation will replace ${runtime:loadResource(...)} with your query, but the expression in the query will not be evaluated.

This won't work, since the expression is only evaluated once. once per record. This evaluation will replace ${runtime:loadResource(...)} with your query, but the expression in the loaded query will not be evaluated.

You may be able to achieve what you're looking for by using a query like:

SELECT id FROM ${runtime:loadResource('table', true)} WHERE id = '${record:value(runtime:loadResource('fieldPath', true))}'

Note - if you specify true as the second argument to runtime:loadResource then you must ensure that the resource file is owner read/write only.

The JDBC Lookup Processor query is reevaluated for each record, so any changes you make in those resource files will be immediately reflected in the pipeline.