For a grails application, I need to find a list of objects whose "attr" is one in a dynamic list of strings. The actual HQL query is more complex, but the bit I need help with is this:
def result = MyObject.executeQuery("select o from MyObject as o where o.attr in :list",
[list: aListOfStrings])
This is obviously not the right syntax, Grails throws it back at me as an "unexpected token", being the :list
parameter.
Is this possible in HQL? I don't particularly want to use Criteria in this part of the codebase.
Put :list in parens:
def result = MyObject.executeQuery(
"select o from MyObject as o where o.attr in (:list)",
[list: aListOfStrings])
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With