i'm pretty new to using ES and wonder how one would solve my current problem, regarding how to index this best and how to query it.
As an example lets say i have two entities in my application. Users and Challenges.
What i want to do now is beeing able to list the following:
- list all challenges for a user , either all, only the ones he declined or only the ones he accepted
- list all challenges and how many have accpeted those
How would i index and query the part of accepting/declining challenges?
What i did for now is to index challenges and users, each in their own index. I'm able to query/filter etc challenges and users without problem.
What i fail to is to come up with a good way to query my additional needs.
Thanks for any hints about this!