JPA: How to merge two jpa results to one pagable

Question

I have two Queries:

Query1(pagable) first datasource

Query2(pagable) second datasource

I would like to do something like this

Page results = merge(query1, query2)

How i can do this in JPA ?

Mo_- · Answer

Are both queries on the same entity? If so you can collect the content from both in a list (List content) and build a new page object. Something as follows:

Page mergedResult = new PageImpl(List content);

https://docs.spring.io/spring-data/commons/docs/current/api/org/springframework/data/domain/PageImpl.html

JPA: How to merge two jpa results to one pagable

1 Answers