It is possible to use parameters passed or created in a job to drive the results of a SQL query. This short recipe shows how.
Open the job
jo_cook_ch07_0020_contextInQuery, which is a copy of the job from the previous recipe.
The steps to be performed are as follows:
HAVING SUM(o.`orderTotal`) > "+context.minOrderValue.
10and click on Ok.
The SQL statement used by
tMysqlInput is held in a string, so can be manipulated just as any other string in Java. Thus, we can ...