Hi Samir, Thanks for your message. That feature request is on the roadmap: https://github.com/jOOQ/jOOQ/issues/1725
The workaround is to use plain SQL as you did. Or you can use the almost identical Field.likeRegex() (whose POSIX regex syntax is a bit different from the "similar to" regex syntax): https://www.jooq.org/javadoc/latest/org/jooq/Field.html#likeRegex-java.lang.String- Thanks, Lukas On Tue, Sep 25, 2018 at 8:59 PM Samir Faci <[email protected]> wrote: > I have a use case where I need to use something along these lines. > > > lower(USERS.USER_NAME) NOT SIMILAR TO '%(pattern1|pattern2|pattern3)%' > > the only way I have figured on how to do this right now is. > > > dsl.select(....).and("lower(UI.PRINCIPAL.USER_NAME) NOT SIMILAR TO > '%(pattern1|pattern2|pattern3)%'"); > > > I was wondering if there was a native supported Jooq API I should be > invoking instead? > > > -- > Thank you > Samir Faci > https://keybase.io/csgeek > > -- > 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.
