Thanks Lukas, I'll keep an eye out on that issue. Thank you for the alternative suggestion as well.
On Wed, Sep 26, 2018 at 12:49 AM Lukas Eder <[email protected]> wrote: > 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. > -- 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.
