JDBC Connector, SQL Query and available variables
Use the ecpression builder instead of the simple construct to use complex variables,
Much, much easier...
PS: If this reply answers your question, please mark a resolved.
The expression builder is indeed a good solution for non-community editions. I solved my problem switching to a Groovy script returning the SQL statement which gives me all the flexibility I needed. Thanks for your answer.
I have both community and performance and I did not find the expression builder on the community edition (7.2)
That's what I did. I thought you were talking of the graphical query builder