CODEWITHSUNDEEP
jpaeclipselinkquerydsl
jensengar
jensengar

Reputation: 6167

querydsl union multiple queries in one

Lets say I have a class like this:

    @Entity
    public class Employee{
        private Long Id;
        private String jobTitle;
        private String firstName;

        ... getters and setters
    }

Is it possible to do single query and return multiple sets of data? Say I have a method signature in my repository that looks like this:

public EmployeeQueryResult getEmployeeQuery(Long currentUserId, String jobTitle, List<String> names);

and I want to use this method to get the current employee by id, all employees that have a specific job title, and all employees that have a name:

public class EmployeeQueryResults{
    private Employee currentEmployee;
    private List<Employee> employeesWithJobTitle;
    private List<Employee> employeesWithName;

    ...
}

I'm asking if it is possible to use queryDSL to basically make 3 separate queries and union them together so that I can use paging on the unioned list.

Upvotes: 4

Views: 4102

Answers (1)

Timo Westk&#228;mper
Timo Westk&#228;mper

Reputation: 22200

I'm asking if it is possible to use queryDSL to basically make 3 separate queries and union them together so that I can use paging on the unioned list.

No, that's not possible with Querydsl. You can write the query in such a way that it will return Employee instances that match at least one of the constraints, but the result will be a single Employee list.

Upvotes: 4

Related Questions