GitHub user dmainou added a comment to the discussion: Oracle Table Input with
variables (${LAST_RUN_TS}, ${LAST_RUN_ID}) failing in Apache Hop
At the risk of pointing the obvious.... why in the world are you using the JS
step to do that?
Just place your query on the table input and substitute the variables directly
in there.
If they are not landing exactly as expected then land the variables as rows
with a **get variables**, bash them into the correct format with a **calc**
step, filter with a **select** to keep what you need in the exact order you
need it and feed it into the table input as **?** substitutions.
Also it's likely working intermittently because, to enable the streaming of
data, in pipelines everything happens at the same time. You need to be aware of
that and design for it.
GitHub link:
https://github.com/apache/hop/discussions/6250#discussioncomment-15330604
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
