is it possible to take a count from a nested query...
# prisma-whats-newr
rein
09/30/2017, 6:30 PMis it possible to take a count from a nested query with 2 filters?
a
agartha
09/30/2017, 6:33 PMYes, it should. Can you share the query?
r
rein
09/30/2017, 6:36 PMjust a sec
rein
09/30/2017, 6:37 PM Copy code
query {
User(id: "cj87egci6m7140120ajyq2bje") {
firstName
lastName
profilePicture
updates(last: 10) {
id
text
challenge {
id
}
}
completed: updates(filter: {
status: Completed}){
challenge {
difficulty
}
}
}
}rein
09/30/2017, 6:37 PMI would like in the completed section to filter the challenges on status
rein
09/30/2017, 6:37 PMso count the updates that have status completed
rein
09/30/2017, 6:38 PMand from those, take the count of those who have a linked challenge of difficulty 'easy' for example
rein
09/30/2017, 6:38 PMif that makes sense 🙂
a
agartha
09/30/2017, 6:39 PMNot really, I'm sorry
r
rein
09/30/2017, 6:39 PMso I have a user who has different updates
a
agartha
09/30/2017, 6:39 PMCould you post this on https://graph.cool/forum along with your schema?
r
rein
09/30/2017, 6:41 PMIll try to explain it here before I post it tho,
I have a user who has many updates. These updates all have a status (enum) and all have a challenge entity linked to them. This challenge also has an enum called difficulty. For one user, I would like to see how many updates have the status of 'Completed' and have a challenge with status 'Easy' for example.
rein
09/30/2017, 6:41 PMSo it's nested in 2 levels I guess
rein
09/30/2017, 6:44 PMdoes that make more sense? 🙂