[{"_id":"abc","field":"value","misc":{"height":1.1,},"sales":[{"label":1,"codes":[{"code":123456,"active":true},{"code":234567,"active":false},{"code":345678,"active":false},],"prices":[{"price":2.99,"valid_from":1},{"price":3.99,"valid_from":4},{"price":4.99,"valid_from":5},{"price":5.99,"valid_from":6},]},{"label":2,"codes":[{"code":987654,"active":true},{"code":876543,"active":false},{"code":765432,"active":false},],"prices":[{"price":2.99,"valid_from":3},{"price":3.99,"valid_from":4},{"price":4.99,"valid_from":5},{"price":6.99,"valid_from":6},]},]}]

db.collection.aggregate([{"$match":{"_id":"abc"}},{"$addFields":{"sales":{"$filter":{"input":{"$map":{"input":"$sales","as":"s2","in":{"$mergeObjects":["$$s2",{codes:{"$filter":{"input":"$$s2.codes","as":"c","cond":{"$eq":["$$c.active",true]}}},prices:{"$filter":{"input":"$$s2.prices","as":"p","cond":{"$gt":["$$p.valid_from",1]}}}}]}}},"as":"s1","cond":{"$eq":["$$s1.label",1]}}}}}])