Hi, I’m starting with mongoDB now. And trying to make a GraphQL query with Insomnia for my DB to search records, where n:200 and a_gte:5 in one Object, but query give me records, where I have n:200 and a_gte:5 in any other Object in shops array. How can I specify to look for a_gte:5 only where n:200 are placed?
Structure is:
{"_id":{"$oid":"mongoid"},
"id":"myid",
"shops":[{"number":200,"d":0,"a":0,"p":0},{"number":15,"d":0,"a":0,"p":0},{"number":16,"d":0,"a":0,"p":0},{"number":17,"d":0,"a":0,"p":0},{"number":18,"d":0,"a":0,"p":0}]}