Database
db={"collection":[{"_id":ObjectId("6099619baa04f15c3fb67a83")}],"s_list":[{"_id":ObjectId("6099619baa04f15c3fb67a83"),"systemDelete_DT":null,"list":[{"_id":ObjectId("609e6ee1955f7b4fbd73fcb5"),"systemDelete_DT":"2021-05-14T18:13:18+01:00","data":[{"_id":ObjectId("609e6ee1955f7b4fbd73fcb6"),"systemDelete_DT":"2021-05-14T18:13:18+01:00","field_id":ObjectId("609bbeb0f1033c156f8e4d86"),},{"_id":ObjectId("609e6ee1955f7b4fbd73fcb9"),"systemDelete_DT":null,"field_id":ObjectId("609c00d6de4c601e4fa358d8"),},{"_id":ObjectId("609e936024c6a45adc030a4c"),"systemDelete_DT":null,"field_id":ObjectId("609e936024c6a45adc030a4b"),}]},{"_id":ObjectId("609e70be503c58506ca77d3d"),"systemDelete_DT":null,"data":[{"_id":ObjectId("609e70be503c58506ca77d3e"),"systemDelete_DT":"2021-05-14T18:13:18+01:00","field_id":ObjectId("609bbeb0f1033c156f8e4d86"),},{"_id":ObjectId("609e70be503c58506ca77d41"),"systemDelete_DT":null,"field_id":ObjectId("609c00d6de4c601e4fa358d8"),},{"_id":ObjectId("609e936024c6a45adc030a4c"),"systemDelete_DT":null,"field_id":ObjectId("609e936024c6a45adc030a4b"),}]}]}]}
Query
db.collection.aggregate([{$lookup:{from:"s_list",localField:"_id",foreignField:"_id",as:"s_lists"}},{$project:{list:{$filter:{input:{$arrayElemAt:["$s_lists.list",0]},as:"s_lists",cond:{$eq:["$$s_lists.systemDelete_DT",null],}}}}}])