Database

[{"_id":ObjectId("5ec8492c27ecdc17362b86cb"),"clientName":"data","users":[{"roles":[],"operations":[],"_id":ObjectId("5ecac60ab527bd0ba4a615cf"),"isAdmin":false,"username":"Adduser"},{"roles":[],"operations":[],"_id":ObjectId("5ecac60ab527bd0ba4a616cf"),"isAdmin":false,"username":"new"}],"kpiObj":[{"kpiName":"epsilon","resultObj":{"result":[{"mark":4,"plz":"01069"},{"mark":5,"plz":"01067"}],}},{"kpiName":"epsilon2","resultObj":{"result":[{"mark":3,"plz":"01069"},{"mark":1,"plz":"01067"}],}}]},{"clientName":"data2","users":[{"roles":[],"operations":[],"_id":ObjectId("5ecac60ab527bd0ba4a615cf"),"isAdmin":false,"username":"Adduser"},{"roles":[],"operations":[],"_id":ObjectId("5ecac60ab527bd0ba4a616cf"),"isAdmin":false,"username":"new"}],"kpiObj":[{"kpiName":"epsilon","resultObj":{"result":[{"mark":411,"plz":"01069"},{"mark":5,"plz":"01067"}],}},{"kpiName":"epsilon2","resultObj":{"result":[{"mark":3,"plz":"01069"},{"mark":1,"plz":"01067"}],}}]},{"clientName":"data3","users":[{"roles":[],"operations":[],"_id":ObjectId("5ecac60ab527bd0ba4a615cf"),"isAdmin":false,"username":"Adduser"},{"roles":[],"operations":[],"_id":ObjectId("5ecac60ab527bd0ba4a616cf"),"isAdmin":false,"username":"new"}],"kpiObj":[{"kpiName":"epsilonNOOO","resultObj":{"result":[{"mark":4,"plz":"01069"},{"mark":5,"plz":"01067"}],}},{"kpiName":"epsilon2","resultObj":{"result":[{"mark":3,"plz":"01069"},{"mark":1,"plz":"01067"}],}}]},{"clientName":"data4","users":[{"roles":[],"operations":[],"_id":ObjectId("5ecac60ab527bd0ba4a615cf"),"isAdmin":false,"username":"Adduser22"},{"roles":[],"operations":[],"_id":ObjectId("5ecac60ab527bd0ba4a616cf"),"isAdmin":false,"username":"new"}],"kpiObj":[{"kpiName":"epsilonNOOO","resultObj":{"result":[{"mark":4,"plz":"01069"},{"mark":5,"plz":"01067"}],}},{"kpiName":"epsilon2","resultObj":{"result":[{"mark":3,"plz":"01069"},{"mark":1,"plz":"01067"}],}}]},{"clientName":"data5","users":[{"roles":[],"operations":[],"_id":ObjectId("5ecac60ab527bd0ba4a615cf"),"isAdmin":false,"username":"Adduser"},{"roles":[],"operations":[],"_id":ObjectId("5ecac60ab527bd0ba4a616cf"),"isAdmin":false,"username":"new"}],"kpiObj":[{"kpiName":"epsilon","resultObj":{"result":[{"mark":1,"plz":"01069"},{"mark":5,"plz":"01067"}],}},{"kpiName":"epsilon2","resultObj":{"result":[{"mark":4,"plz":"01069"},{"mark":1,"plz":"01067"}],}}]}]

Query

db.collection.aggregate([{$match:{"users.username":"Adduser","kpiObj.kpiName":"epsilon","kpiObj.resultObj.result.mark":4}},{$addFields:{users:{$filter:{input:"$users",cond:{$eq:["$$this.username","Adduser"]}}}}},{$addFields:{kpiObj:{$filter:{input:"$kpiObj",cond:{$eq:["$$this.kpiName","epsilon"]}}}}},{$unwind:"$kpiObj"},{$addFields:{"kpiObj.resultObj.result":{$filter:{input:"$kpiObj.resultObj.result",cond:{$eq:["$$this.mark",4]}}}}},{$match:{"kpiObj.resultObj.result":{$ne:[]}}},{$addFields:{kpiObj:["$kpiObj"]}}])

Result