I can use simple variables in my SQL queries inside JDBC connectors using ${ varname }.
Are complex variables available? Like objects from the BDM or java.util.List?
Is the SQL Query a velocity template or a groovy GString interpolation?
Submitted by g.lapierre on Thu, 03/17/2016 - 09:58
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.
Comments
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.
It also works extremely well for Community editions... :)
regards
Seán
I have both community and performance and I did not find the expression builder on the community edition (7.2)
Yep, it's still there...
In 7.2.1 add SQL connector then when you get to enter query click the Switch Editor link...it changes the editor allowing the groovy editor...
regards
That's what I did. I thought you were talking of the graphical query builder