Match by 2 fields in one subobject

Working with Data
2

Hi @Daniel_Reznicek,

Sure. You need to use $elemMatch in your queries:

 db.schools.find(
    {"students": {"$elemMatch": {"name": "peter", "level": "excellent"}}});

Of course you can index those fields or the main array field to better search this syntax.

Best
Pavel