Database
db={"tbl_schedule":[{"createTime":{"$date":{"$numberLong":"1670937460502"}},"creatorId":{"$oid":"63872e92d17e8cc76bf7dd73"},"isDelete":false,"companyId":{"$oid":"6363205224e4273ca5a9362f"},"isActive":true,"classId":{"$oid":"635d2f6e6804b95ce6a9e5d0"},"year":"2022","day":"SUNDAY","identifier":"string","lessons":[{"id":{"$oid":"63980c73f34e7d85739a7d6a"},"lessonId":{"$oid":"638d5cd2375358461f816934"},"startTime":"08:20:00","endTime":"09:20:00"},{"id":{"$oid":"63980e8e9ab90c0ee2f3342c"},"lessonId":{"$oid":"638d5e66d616b07dc67644fa"},"teacherId":{"$oid":"6388c6a832247c76d1aa5fd3"},"roomId":{"$oid":"63884fc3e2ab1ed286b3c581"},"startTime":"09:20:00","endTime":"10:20:00"},{"id":{"$oid":"6398162204f53963bdafc872"},"lessonId":{"$oid":"638d5e65d616b07dc67644f3"},"teacherId":{"$oid":"63980e8e9ab90c0ee2f3342c"},"roomId":{"$oid":"63884fc3e2ab1ed286b3c581"},"startTime":"11:15:00","endTime":"12:20:00"},{"id":{"$oid":"6398160404f53963bdafc870"},"lessonId":{"$oid":"638d5e66d616b07dc67644f9"},"teacherId":{"$oid":"6388c6a832247c76d1aa5fd3"},"roomId":{"$oid":"63884fc3e2ab1ed286b3c581"},"startTime":"11:20:00","endTime":"12:20:00"},{"id":{"$oid":"63981693436fa59f03870922"},"lessonId":{"$oid":"638d5e65d616b07dc67644f6"},"teacherId":{"$oid":"63980e8e9ab90c0ee2f3342c"},"roomId":{"$oid":"63884fc3e2ab1ed286b3c581"},"startTime":"12:20:00","endTime":"13:20:00"},{"id":{"$oid":"6398172d436fa59f03870923"},"lessonId":{"$oid":"638d5e65d616b07dc67644f6"},"teacherId":{"$oid":"63980e8e9ab90c0ee2f3342c"},"roomId":{"$oid":"63884fc3e2ab1ed286b3c581"},"startTime":"12:21:00","endTime":"13:20:00"},{"id":{"$oid":"6398185ac7d6aabe35d1a8aa"},"lessonId":{"$oid":"638d5e66d616b07dc67644f7"},"teacherId":{"$oid":"63980e8e9ab90c0ee2f3342c"},"roomId":{"$oid":"63884fc3e2ab1ed286b3c581"},"startTime":"12:22:00","endTime":"13:20:00"},{"id":{"$oid":"63981904c7d6aabe35d1a8ad"},"lessonId":{"$oid":"638d5e66d616b07dc67644f8"},"teacherId":{"$oid":"63980e8e9ab90c0ee2f3341c"},"roomId":{"$oid":"63884fc3e2ab1ed286b3c581"},"startTime":"12:23:00","endTime":"13:20:00"}]}],"tbl_lessons":[{"_id":{"$oid":"62f0aea79edc3e87b04a7f9b"},"isDelete":false,"isActive":true,"name":"MATEMATIKA","code":"MTK"},{"_id":{"$oid":"62f0af2ccb716c443625c3cf"},"isDelete":false,"isActive":true,"name":"BAHASA INDONESIA","code":"BIN"},{"_id":{"$oid":"62f0af32cb716c443625c3d0"},"isDelete":false,"isActive":true,"name":"CHINA","code":"CHN"},{"_id":{"$oid":"637e31a8dc2c902fb8c96e4b"},"isDelete":false,"isActive":true,"name":"BAHASA INGGRIS","code":"BING"},{"_id":{"$oid":"637e31a8dc2c902fb8c96e4c"},"isDelete":false,"isActive":true,"name":"SENI RUPA","code":"SRP"},{"_id":{"$oid":"637e31a8dc2c902fb8c96e4d"},"isDelete":false,"isActive":true,"name":"SEJARAH MELAYU","code":"SMY"},{"_id":{"$oid":"637e31a8dc2c902fb8c96e4e"},"isDelete":false,"isActive":true,"name":"MATEMATIKA","code":"MTK"},{"_id":{"$oid":"637e31a8dc2c902fb8c96e4f"},"isDelete":true,"isActive":false,"name":"ILMU PENGETAHUAN ALAM","code":"IPA"},{"_id":{"$oid":"637e31a8dc2c902fb8c96e50"},"isDelete":false,"companyId":{"$oid":"6363205224e4273ca5a9362f"},"isActive":true,"name":"ILMU PENGETAHUAN SOSIAL","code":"IPS"},{"_id":{"$oid":"637e31a8dc2c902fb8c96e51"},"isDelete":false,"isActive":true,"name":"GEOGRAFI","code":"GEO"},{"_id":{"$oid":"637e31a8dc2c902fb8c96e52"},"isDelete":false,"isActive":true,"name":"SOSIOLOGI","code":"SOS"},{"_id":{"$oid":"637e31a9dc2c902fb8c96e53"},"isDelete":false,"isActive":true,"name":"SENI BUDAYA","code":"SSB"},{"_id":{"$oid":"637ed644a0880a9d424010b2"},"isDelete":false,"isActive":false,"name":"PENDIDIKAN AGAMA DAN BUDI PEKERTI","code":"PAI"},{"_id":{"$oid":"637ed703fd7c3fd183aa7466"},"isDelete":false,"isActive":false,"name":"PENDIDIKAN KEWAGANEGAAN","code":"PKN"}],"tbl_classes":[{"_id":{"$oid":"635d2e398e7b6138e9a65111"},"isDelete":false,"companyId":{"$oid":"635c70892e8cfaf4a7d49a3f"},"isActive":true,"mainClass":"VII","classes":[{"classId":{"$oid":"635d2f6e6804b95ce6a9e5d0"},"className":"A","classCode":"VII A","tags":[]},{"classId":{"$oid":"635d2f796804b95ce6a9e5d1"},"className":"B","classCode":"VII B","tags":[]},{"classId":{"$oid":"635d2f836804b95ce6a9e5d2"},"className":"C","classCode":"VII C","tags":[]},{"classId":{"$oid":"635d2f8e6804b95ce6a9e5d3"},"className":"D","classCode":"VII D","tags":[]},{"classId":{"$oid":"635d2f966804b95ce6a9e5d4"},"className":"E","classCode":"VII E","tags":[]}]}]}
Query
db.tbl_schedule.aggregate([{"$match":{"companyId":ObjectId("6363205224e4273ca5a9362f")}},{"$lookup":{"from":"tbl_classes","localField":"classId","foreignField":"classes.classId","as":"kelas"}},{"$lookup":{"from":"tbl_lesson","localField":"lessons.lessonId","foreignField":"_id","as":"pelajaran"}},{"$unwind":{"path":"$kelas"}},{"$unwind":{"path":"$lessons"}},{"$project":{"classId":1,"year":1,"day":1,"identifier":1,"lessons":1,/**"kelas": 1,*/"pelajaran":1,"filteredClasses":{"$filter":{"input":"$kelas.classes","as":"classes","cond":{"$eq":["$classId","$$classes.classId"]}}},"filteredLesson":{"$filter":{"input":"$pelajaran._id","as":"lesson","cond":{"$eq":["$lessons.lessonId","$$lesson._id"]}}}}},{}])