Simple (E1 AND E2) OR (E3 AND E4) expression in QueryDSL

querydsl
csviri picture csviri · May 11, 2012 · Viewed 7k times · Source

How do I express in QueryDSL where clause in form: 

 WHERE (E1 AND E2) OR (E3 AND E4)

E1..E4 are arbitrary boolean expressions. The point is to have a query started within parenthesis, thus (E1 AND E2).

Answer

ponzao picture ponzao · May 11, 2012 
where(e1.and(e2).or(e3.and(e4)))

Related questions

Dynamic spring data jpa repository query with arbitrary AND clauses

I'm using Spring data jpa repositories, Got a requirement to give search feature with different fields. Entering fields before search is optional.I have 5 fields say EmployeeNumber, Name, Married,Profession and DateOfBirth. Here i need to query only with the …

Read More
Eclipse issue with Maven build and JDK when generating Qclasses in Querydsl

When I add this code below in my pom.xml to support Querydsl <plugin> <groupId>com.mysema.maven</groupId> <artifactId>apt-maven-plugin</artifactId> <version>1.0.6</version> <executions&…

Read More
Spring Data JPA and Querydsl to fetch subset of columns using bean/constructor projection

I have an entity class as below: @Entity public class UserDemo implements Serializable { @Id private Long id; private String username; private String createdBy; @Version private int version; /*** * * Getters and setters */ } Using Spring Data JPA and Querydsl how do I fetch …

Read More