How to get the changes for multiple entity types ? Those types are all audited by Javers, and have one-to-many relationships. Furthermore, the search needs to be paginated (because of the big amount of data).

Let's consider the first type Hotel with a one-to-many relationship to Room. Hotel has a second one-to-many relationship to Recommendation.

Currently, the search looks like the following. This implementation is not efficient since it fetches all data before reducing the result set to display a page.

// search by instance
def searchForChanges(instance) {
    JqlQuery query = QueryBuilder.byInstance(instance)
            .withNewObjectChanges()
            .withChildValueObjects()
            .build();
    return javers.findChanges(query);    
}


Hotel hotel = new Hotel(uuid, "My Hotel");


List<Changes> changes = new ArrayList()

// search the changes for the hotel
changes.addAll(searchForChanges(hotel))

// repeat the search for each room
for (room in hotel.getRooms()) {
    changes.addAll(searchForChanges(room))
}

// repeat the search for each recommendation
for (recommendation in hotel.getRecommendation()) {
    changes.addAll(searchForChanges(recommendation))
}

// then sort, and build a page
changes.sort(comparator)
        .stream()
        .limit(...)
        .skip(...)

Example of the entities:

@Entity
@Table(name = "hotel")
public class Hotel {

    @Id
    private UUID id;
    private String name;

    @DiffIgnore
    @OneToMany(orphanRemoval = true, cascade = CascadeType.ALL)
    @JoinColumn(name = "hotelId")
    private List<Room> rooms = new LinkedList<>();

    @DiffIgnore
    @OneToMany(orphanRemoval = true, cascade = CascadeType.ALL)
    @JoinColumn(name = "hotelId")
    private List<Recommendation> recommendations = new LinkedList<>();
}

@Entity
@Table(name = "Room")
public class Room {

    @Id
    private UUID id;
    private UUID hotelId;
    private int number;
}

@Entity
@Table(name = "Recommendation")
public class Recommendation {

    @Id
    private UUID id;
    private UUID hotelId;
    private int stars;
    private String comment;
}

Expected results: a list of changes ordered by date made of different types :

change #10: Hotel changed its name
change #9: Room changed its number
change #8: Recommendation was added to the hotel
change #7: A room was added to the hotel
change #6: Hotel was created
        (The following changes are available on page 2)

Side-note:
I'm aware of the methods limit and skip on the class QueryBuilder, but since I need to execute the search by instance, it won't paginate the results of multiple instance types.