Database

[{_id:1,field:{subfield1:{subsubfield1:["value","test"]},subfield2:{subsubfield2:["value"]}},paths:["field.subfield1.subsubfield1","field.subfield2.subsubfield2"]},{_id:2,field:{subfield1:{subsubfield1:["value"]},subfield2:{subsubfield2:["value","test"]}},paths:["field.subfield2.subsubfield2"]},{_id:3,field:{subfield1:{subsubfield1:["value"]},subfield2:{subsubfield2:["value"]}},paths:["field.subfield1.subsubfield1"]},{_id:4,field:{subfield1:{subsubfield1:["value"]},subfield2:{subsubfield2:["value"]}},paths:["field.subfield1.subsubfield1","field.subfield2.subsubfield2"]}]

Query

db.collection.aggregate([{$set:{"subsubfield1":{$filter:{input:"$field.subfield1.subsubfield1",cond:{$in:[{$literal:"field.subfield1.subsubfield1"},"$paths"]}}},"subsubfield2":{$filter:{input:"$field.subfield2.subsubfield2",cond:{$in:[{$literal:"field.subfield2.subsubfield2"},"$paths"]}}}}},{$match:{$or:[{subsubfield1:"test"},{subsubfield2:"test"}]}},{$project:{_id:1}}])

Result