[{"_id":1,"user":"CHEWBACCA","paymentTypes":[{"type":"PILOT","limits":[{"type":"FLIGHT_HOURS","amount":10},{"type":"COMBAT_HOURS","amount":80000},{"type":"TRAINING_HOURS","amount":80000}]},{"type":"WARRIOR","limits":[{"type":"FLIGHT_HOURS","amount":22},{"type":"COMBAT_HOURS","amount":123},{"type":"TRAINING_HOURS","amount":456}]}],"createdDate":"2021-11-11"}]

db.collection.aggregate([{"$set":{"paymentTypes":{"$map":{"input":"$paymentTypes","in":{"$cond":[{"$eq":["$$ptype.type","PILOT"]},{"$mergeObjects":["$$ptype",{"limits":{"$filter":{"input":"$$ptype.limits","cond":{"$eq":["$$this.type","COMBAT_HOURS"]}}}}]},null]},"as":"ptype"}}}},{"$set":{"paymentTypes":{"$filter":{"input":"$paymentTypes","cond":{"$ne":["$$this",null]}}}}}])