Hi, Here is my problem:
We have Authors (parents) and books (children). Authors can be regularly updated (let's say the number of their fans can vary with the time). Books are immutable, and each book has a rating. I want to be able to get the parents that have the highest cumulated rating score for a particular period of time. For example I have: John, who had 100 fans in January and 200 fans in July, wrote: - "book 1" with a rating of 12 in January - "book 3" with a rating of 19 in March - "book 6" with a rating of 9 in June Jane, who had 50 fans in January and 600 in July, wrote: - "book 2" with a rating of 13 in February - "book 4" with a rating of 11 in April - "book 5" with a rating of 10 in May In July, I would like to get back, for the time period February - May, the following results (ordered by cumulated rated): Jane, 600 fans - 34 cumulated rating John, 200 fans - 19 cumulated rating At the same time, I also want to be able to filter based on the content of the books and also based on characteristics of the authors. I tried to use a parent/child model, and use a query with has_child and function_score, but couldn't find a way to do I am looking for. Any idea? Thanks! -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/7fde7cdb-efc4-4474-b6a1-fe8490f8854b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
