Hi Massimo, Interesting, unfortunately, this isn't possible currently with jOOQ the way you tried it. You could, however, implement a CustomCondition as is explained here: https://www.jooq.org/doc/latest/manual/sql-building/queryparts/custom-queryparts
This would allow you to implement your own custom org.jooq.Condition implementation instead of the standard IN predicate, which could implement any custom behaviour you'd like. Hope this helps, Lukas 2017-02-28 11:05 GMT+01:00 <[email protected]>: > Hi all, > > I would like to define a param() to be lately set with a collection of > integers to be used in an in() condition, something like > > query.where( > DATA_INSTRUMENT.CLASS.in(param("instrumentTypes")) > ) > > > and later > > > List<Integer> instrumentTypes = ... > > query.bind("instrumentTypes", instrumentTypes) > > > This does not work since Param is a Field, and JOOQ thinks I'm binding just > one field value of type List<Integer> and fails on trying to convert it. > > I couldn't find the right way to do this. > > > Any help is appreciated, thank you. > > > Massimo > > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
