Database
[{"_id":"id","field1":"value1","field2":"value2","field3":"value3","field4":"value4","field5":"value5","field6":[{"field7":"value_a7_level1","field8":"value_a8_level1","field9":"value_a9_level1","field10":[{"field11":"value_a11_level1","field12":"value_a12_level1","field13":"value_a13_level1","field14":"value_a14_level1"},{"field11":"value_b11_level1","field12":"value_b12_level1","field13":"value_b13_level1","field14":"value_b14_level1"}],"field15":[{"field16":"zzz","field17":"xxx","field18":"value_a18_level1","field19":"value_a19_level1"},{"field16":"xxx","field17":"yyy","field18":"value_b18_level1","field19":"value_b19_level1"},{"field16":"xxx","field17":"yyy","field18":"value_c18_level1","field19":"value_c19_level1"}]},{"field7":"value_a7_level2","field8":"value_a8_level2","field9":"value_a9_level2","field10":[{"field11":"value_a11_level2","field12":"value_a12_level2","field13":"value_a13_level2","field14":"value_a14_level2"},{"field11":"value_b11_level2","field12":"value_b12_level2","field13":"value_b13_level2","field14":"value_b14_level2"}],"field15":[{"field16":"value_a16_level2","field17":"value_a17_level2","field18":"value_a18_level2","field19":"value_a19_level2"},{"field16":"value_b16_level2","field17":"value_b17_level2","field18":"value_b18_level2","field19":"value_b19_level2"},{"field16":"value_c16_level2","field17":"value_c17_level2","field18":"value_c18_level2","field19":"value_c19_level2"}]},{"field7":"value_a7_level3","field8":"value_a8_level3","field9":"value_a9_level3","field10":[{"field11":"value_a11_level3","field12":"value_a12_level3","field13":"value_a13_level3","field14":"value_a14_level3"},{"field11":"value_b11_level3","field12":"value_b12_level3","field13":"value_b13_level3","field14":"value_b14_level3"}],"field15":[{"field16":"xxx","field17":"yyy","field18":"value_a18_level3","field19":"value_a19_level3"},{"field16":"value_b16_level3","field17":"value_b17_level3","field18":"value_b18_level3","field19":"value_b19_level3"},{"field16":"value_c16_level3","field17":"value_c17_level3","field18":"value_c18_level3","field19":"value_c19_level3"}]}],"field20":[{"field21":"value21_level1","field22":"value22_level1","field23":"value23_level1"},{"field21":"value21_level2","field22":"value22_level2","field23":"value23_level2"}]}]
Query
db.collection.aggregate([{"$addFields":{"field6":{"$filter":{"input":{"$map":{"input":"$field6","as":"f6","in":{"$cond":[true,{"field7":"$$f6.field7","field8":"$$f6.field8","field9":"$$f6.field9","field10":"$$f6.field10","field15":{"$filter":{"input":"$$f6.field15","as":"f15","cond":{$and:[{$eq:["$$f15.field16","xxx"]},{$eq:["$$f15.field17","yyy"]}]}}}},false]}}},"as":"cls","cond":{$ne:["$$cls.field15",[]]}}}}}])