Database

[{field0:"value0",field1:"value1",field2:{field3:"value3",field4:[{sfield1:"svalue110",sfield2:"svalue210"},{sfield1:"svalue111",sfield2:"svalue211"},]}},{field0:"value0",field1:"value1",field2:{field3:"value3",field4:[{sfield1:"svalue120",sfield2:"svalue220"},{sfield1:"svalue111",sfield2:"svalue211"},{sfield1:"svalue122",sfield2:"svalue222"},]}},{field0:"value0",field1:"value1",field2:{field3:"value3",field4:[{sfield1:"svalue130",sfield2:"svalue230"},{sfield1:"svalue131",sfield2:"svalue231"},{sfield1:"svalue132",sfield2:"svalue232"},{sfield1:"svalue133",sfield2:"svalue233"},]}}]

Query

db.collection.aggregate([{$project:{"field0":1,"field1":1,"field2.field3":1,"_id":0,"field2.field4":{$filter:{input:"$field2.field4",as:"d",cond:{$and:[{$eq:["$$d.sfield1","svalue111"]},{$eq:["$$d.sfield2","svalue211"]}]}}}}},{"$match":{"field2.field4.0":{"$exists":true}}}])

Result