Database
[{_id:"64011d1c2839dd1845354dfb",name:"Plan",builds:[{_id:"64011d302839dd1845354dfe",number:20,type:"Test Object 1",artifacts:[{link:"helloworld.com",minioPath:"test.zip",_id:"64011d302839dd1845354dff",},{link:"helloworld.com",minioPath:"test15.zip",_id:"64011d302839dd1845354e00",},],},{_id:"64011j746399dd1845357894",number:21,type:"Test Object 2",artifacts:[{link:"mongo.com",minioPath:"test20.zip",_id:"64011d302839dd1845354e01",},{link:"mongo.com",minioPath:"test25.zip",_id:"64011d302839dd1845354e02",},],},],},]
Query
db.collection.aggregate([{"$match":{_id:"64011d1c2839dd1845354dfb"}},{$project:{"builds":{"$filter":{"input":{"$map":{"input":"$builds","as":"build","in":{"_id":"$$build._id","artifacts":{"$filter":{"input":"$$build.artifacts","as":"artifact","cond":{$eq:["$$artifact._id","64011d302839dd1845354e00",]}}}}}},"as":"build","cond":{"$ne":["$$build.artifacts",[]]}}},},},])