Database
[{"_id":ObjectId("6099614e503dd75c29c9715d"),"systemDelete_DT":null,"group":ObjectId("6099614e503dd75c29c9715b"),"headers":[{"_id":ObjectId("609e875203041759d7b0428a"),"systemDelete_DT":"2021-05-14T15:21:06+01:00","fieldName":"Field1-X"},{"_id":ObjectId("609fe89e5d4ac02438abdc31"),"systemDelete_DT":null,"fieldName":"Field1"},{"_id":ObjectId("60a00c14543d582c151e34f6"),"systemDelete_DT":null,"fieldName":"Field2"}],"list":[{"_id":ObjectId("609966bccce7575f2408fddc"),"systemDelete_DT":null,"text":"abc1","customData":[{"_id":ObjectId("609e875203041759d7b0428b"),"systemDelete_DT":"2021-05-15T19:39:20+01:00","field_id":ObjectId("609e875203041759d7b0428a"),"fieldText":"Example-X"},{"_id":ObjectId("609fe89e5d4ac02438abdc32"),"systemDelete_DT":null,"field_id":ObjectId("609fe89e5d4ac02438abdc31"),"fieldText":"Example1"},{"_id":ObjectId("60a00c14543d582c151e34f7"),"systemDelete_DT":null,"field_id":ObjectId("60a00c14543d582c151e34f6"),"fieldText":"Example2"}]},{"_id":ObjectId("609966becce7575f2408fdde"),"systemDelete_DT":null,"text":"abc2","customData":[{"_id":ObjectId("609e875203041759d7b0428b"),"systemDelete_DT":"2021-05-15T19:39:20+01:00","field_id":ObjectId("609e875203041759d7b0428a"),"fieldText":"Example-X"},{"_id":ObjectId("609fe89e5d4ac02438abdc32"),"systemDelete_DT":null,"field_id":ObjectId("609fe89e5d4ac02438abdc31"),"fieldText":"Example3"},{"_id":ObjectId("60a00c14543d582c151e34f7"),"systemDelete_DT":null,"field_id":ObjectId("60a00c14543d582c151e34f6"),"fieldText":"Example4"}]},{"_id":ObjectId("609966d2474ad05f369c891a"),"systemDelete_DT":"2021-05-14T15:21:06+01:00","text":"abc32","customData":[{"_id":ObjectId("609e875203041759d7b0428b"),"systemDelete_DT":"2021-05-15T19:39:20+01:00","field_id":ObjectId("609e875203041759d7b0428a"),"fieldText":""},{"_id":ObjectId("609fe89e5d4ac02438abdc32"),"systemDelete_DT":null,"field_id":ObjectId("609fe89e5d4ac02438abdc31"),"fieldText":"Example5"},{"_id":ObjectId("60a00c14543d582c151e34f7"),"systemDelete_DT":null,"field_id":ObjectId("60a00c14543d582c151e34f6"),"fieldText":"Example6"}]},]}]
Query
db.collection.aggregate([{$unwind:"$list"},{$match:{$and:[{group:ObjectId("6099614e503dd75c29c9715b")},{systemDelete_DT:null},{"list.systemDelete_DT":null}]}},{$project:{_id:0,text:"$list.text"}}])