Hi, I would like to match all “schools” that contain some student “Peter” with “excelent” level.
I tried:
{
"students.name": "Peter",
"students.level": "excelent"
}
but it returns also documents where “Peter” and “excelent” are not related to the same person.
My data:
{
"schoolName": "London school"
"students": [{
"name": "Peter",
"level": "middle"
}, {
"name": "Jane",
"level": "excelent"
}]
}
Is it possible somehow? I’m new in MongoDB…