Hi all, I'm searching for ideas on how to define schema and how to perform queries in this use case: we have to index books, each book is split into chapters and chapters are split into pages (pages represent original page cutting in printed version). We should show the result grouped by books and chapters (for the same book) and pages (for the same chapter). As far as I know, we have 2 options:
1. index pages as SOLR documents. In this way we could theoretically retrieve chapters (and books?) using grouping but a. we will miss matches across two contiguous pages (page cutting is only due to typographical needs so concepts could be split... as in printed books) b. I don't know if it is possible in SOLR to group results on two different levels (books and chapters) 2. index chapters as SOLR documents. In this case we will have the right matches but how to obtain the matching pages? (we need pages because the client can only display pages) we have been struggling on this problem for a lot of time and we're not able to find a suitable solution so I'm looking if someone has ideas or has already solved a similar issue. Thanks