Yes, thank you hekark. For the record, I've also answered your Stack Overflow question here: http://stackoverflow.com/questions/11247797/jooq-nested-condition/11262608
I hope this sheds some light on this matter. Cheers Lukas 2012/6/29 <[email protected]>: > Hmmm... > > I don't have my work machine handy, but have you tried something like: > > select().from(TABLE) > .where(a1.equal(b1).or(a2.equal(b2)).or(a3.equal(b3))) > .and(c1.equal(d1).or(c2.equal(d2).or(c3.equal(d3)))) > > > If you add the logical operator directly after the comparison, it'll nest > it. > > The last example should help > http://www.jooq.org/manual/DSL/CONDITION/ > > Hope that fixes your issue :) > > > On Thursday, June 28, 2012 6:45:24 PM UTC-4, [email protected] wrote: >> >> Hi i am trying to figure out how to write something like this in jooq >> >> Code: >> >> select * from table where ( ( a = query or b = query or a = query ) and ( >> e = query or g = query or z = query) ) >> >> I cant figure out how to do nested condition in jooq. Please help
