Database
[{"_id":"47f6ad68-d431-4b69-9899-f33d828f8f9c","type":"FPF","status":"REGISTERED","fpfInfo":{"fpfInfoList":[{"ssai":{"st":1},"infoList":[{"dn":"sim"}]}]}},{"_id":"347c8ed2-d9d1-4f1a-9672-7e8a232d2bf8","type":"FPF","status":"REGISTERED","fpfInfo":{"fpfInfoList":[{"ssai":{"st":1,"ds":"000004"},"infoList":[{"dn":"sim"}]}]}}]
Query
db.collection.aggregate([{"$unwind":"$fpfInfo.fpfInfoList"},{"$match":{"fpfInfo.fpfInfoList.ssai.ds":{"$exists":false},"fpfInfo.fpfInfoList.infoList.dn":"sim","fpfInfo.fpfInfoList.ssai.st":1}}])