[{"_id":ObjectId("5bfdb66f0f77e33b90f53fad"),"email":"amit@gmail.com","appointments":[{"year":"2018","months":"12","day":"31","hour":"10","minute":"30","doctorsName":"Doc 1","hospitalName":"Place 1","sortOrder":"201812311030"},{"year":"2018","months":"09","day":"31","hour":"10","minute":"30","doctorsName":"Doc 1","hospitalName":"Place 1","sortOrder":"201809311030"},{"year":"2018","months":"11","day":"30","hour":"05","minute":"30","doctorsName":"Doc 1","hospitalName":"Place 1","sortOrder":"201811300530"}],"medicalData":[{"year":"2018","months":"09","day":"31","symptomsList":["headache","nausea","cough"],"weight":"70","bloodPressureSystolic":"120","bloodPressureDiastolic":"80","medications":["med 1","med 2"],"sortOrder":"20180931"},{"year":"2018","months":"10","day":"31","symptomsList":["headache","cough","Vomiting","Body Pain"],"weight":"70","bloodPressureSystolic":"120","bloodPressureDiastolic":"80","medications":["med 1","med 2","med 3"],"sortOrder":"20181031"}]}]

db.collection.aggregate([{"$project":{"email":1,"appointments":{"$filter":{"input":"$appointments","as":"apnmt","cond":{"$gt":["$$apnmt.sortOrder","201811300530"]}}},"medicalData":{"$filter":{"input":"$medicalData","as":"med","cond":{"$eq":["$$med.sortOrder","20180931"]}}}}},{"$addFields":{"medicalData":{"$arrayElemAt":["$medicalData",0]}}},{"$project":{"email":1,"appointments":1,"year":"$medicalData.year","months":"$medicalData.months","day":"$medicalData.day","symptomsList":"$medicalData.symptomsList","weight":"$medicalData.weight","bloodPressureSystolic":"$medicalData.bloodPressureSystolic","bloodPressureDiastolic":"$medicalData.bloodPressureDiastolic","medications":"$medicalData.medications","sortOrder":"$medicalData.sortOrder"}}])