I'm trying to create a complex WHERE condition using the jOOQ DSL and it's not working as expected. I'm using version 3.7.2. Here is the SQL I'm trying to output:
WHERE ((field1 = ? AND field2 = ?) OR (field3 = ? AND field4 = ?)) I'm trying to use the jOOQ DSL like the following: .where(DSL.or(FIELD1.eq().and(FIELD2.eq()), FIELD3.eq().and(FIELD4.eq()))) This outputs an `AND` between the two conditions. Is this a correct use of `DSL.or`? Is there another means of accomplishing what I would like to do? Thanks, James Lorenzen -- 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.
