Say I have a Venue and Event entity.
On the search page, I want to show paginated list of Venues and corresponding Events at that venue in 7 days (One to Many).
One simple approach is to do a global search for Events happening in 7 days.. and then do groupby in the backend. However, this makes pagination difficult because I don't want to paginate on the Events but rather their Venue property (because I want to show 20 venues per page)
Ideally, I want to paginate on Event.venueId or Event.venue.id. Is this possible ?
I have looked into some techniques like aggregation partition, parent/child, but they all seem overly compex or not ideal.
I'm working with Elasticsearch v 6.4.3.