Querydsl and/or examples

gistfile1.txt

#1 
e1.or(e2).and(e3)) 

creates at first an 'or' operation based on e1 and e2 and uses this 'or' operation 
in a top level 'and' operation with e3 as the second operand.

Since 'and' has higher precedence than 'or' it is serialized as

(e1 or e2) and e3


#2 
e1.or(e2).and(e3.or(e4)))

'and' is the top level operation and e1.or(e2) and e3.or(e4) are the lower level operations

It is serialized as

(e1 or e2) and (e3 or e4)


#3
e1.and(e2).or(e3.and(a4))

`or`is the top level operation and e1.and(e2) and e3.and(e4) are the lower level operations

It is serialized as

e1 and e2 or e3 and e4

@b0c1 like it is said in the example #3, you need to do : e1.and(e2).or(e3.and(e4)).or(e5.and(e6))
It will be serialized : e1 and e2 or e3 and e4 or e5 and e6
and because in SQL, and have precedence over or, it will be evaluated as (e1 and e2) or (e3 and e4) or (e5 and e6)

@iheb719
Thank you for teaching me operator priority

How can I create？
((e1 or e2) and e3) or (e4 and e5 and e6)

sql examples:
and (
(
(t3.id is null or t3.is_deleted = 1)
and t2.settle_cycle_id is NULL
and t1.settle_date BETWEEN '2022-04-01' and '2022-04-22'
)
or
(
t3.id is not null
and t3.is_deleted = 0
and t1.settle_date BETWEEN '2022-04-01' and '2022-04-22'
)
)

As I understand, if I want to get e1 and e2 and ((e3 and e4) or e5), it will be e1.and(e2).and(e3.and(e4).or(e5)).

But actually, I got e1 and e2 and (e3 and e4 or e5).

What is the matter? Please help me...

@SeongEon-Jo That's OK. AND has higher priority than OR, so "e1 and e2 and (e3 and e4 or e5)" means that "e3 and e4" will be evaluated first, then "... or e5" and then it's all AND-ed. Just the redundant parentheses are removed. It will work the same.

@virgo47 Oh, I got it. Thanks!