[{"_id":ObjectId("5c05984246a0201286d4b57a"),f:"x","_a":[{"_onlineStore":{}},{"_p":{"s":{"a":{"t":[{id:1,v:2,"dateP":"20200-09-20",did:"x",dst:"y",den:"z"},{id:2,"dateP":"Inconsisten object 1",v:3},{id:3,"dateP":"Inconsisten object 2",v:3},{id:4,"dateP":"Inconsisten object 3",v:3},{id:5,"dateP":"Inconsisten object 4",v:3}]}}}},{"_p":{"s":{"c":{"t":[{id:6,v:2,"dateP":"20200-09-20",did:"x",dst:"y",den:"z"},{id:2,"dateP":"Inconsisten object 1",v:3},{id:3,"dateP":"Inconsisten object 2",v:3},{id:4,"dateP":"Inconsisten object 3",v:3},{id:5,"dateP":"Inconsisten object 4",v:3}]}}}}]}]/** as you can see d.t and c.t do not exist in the example* document , but they may exist in other documents*/

db.collection.update({},[{$set:{"_a":{$map:{input:"$_a",as:"external",in:{$cond:[{$gt:["$$external._p",0]},{_p:{s:{a:{t:{$filter:{input:"$$external._p.s.a.t",as:"item",cond:{$and:[{$gt:["$$item.did",0]},{$gt:["$$item.dst",0]},{$gt:["$$item.den",0]}]}}}},c:{t:{$filter:{input:"$$external._p.s.c.t",as:"item",cond:{$and:[{$gt:["$$item.did",0]},{$gt:["$$item.dst",0]},{$gt:["$$item.den",0]}]}}}},d:{t:{$filter:{input:"$$external._p.s.d.t",as:"item",cond:{$and:[{$gt:["$$item.did",0]},{$gt:["$$item.dst",0]},{$gt:["$$item.den",0]}]}}}}}}},"$$external"]}}}}}])