Database
db={edcontentmaster:[{"_id":{"$oid":"64ccd53792362c7639d3da5f"},"contentid":"NVOOKADA1690811843420STD-5EnglishThe Monkey from RigerLesson - 1","boardid":"1","boardname":"BSE","scholarshipid":"NVOOKADA1690811843420","scholarshipname":"Adarsh","stageid":"5","subjectid":"1691130406151","stage":"STD-5","subject":"English","subjectimage":"https://notevook.s3.ap-south-1.amazonaws.com/Adarsh/sub+english.png","topicimage":"","contentimage":"","topicid":"1691144002706","topic":"The Monkey from Riger","slcontent":"1","sltopic":"1","contentset":"Lesson - 1","timeDuration":"15","quiz":[],"slsubject":"1"},{"_id":{"$oid":"64ccf5ca92362c7639d3f145"},"contentid":"NVOOKADA1690811843420STD-5EnglishThe Monkey from RigerLesson - 3","boardid":"1","boardname":"BSE","scholarshipid":"NVOOKADA1690811843420","scholarshipname":"Adarsh","stageid":"5","subjectid":"1691130406151","stage":"STD-5","subject":"English","subjectimage":"https://notevook.s3.ap-south-1.amazonaws.com/Adarsh/sub+english.png","topicimage":"","contentimage":"","topicid":"1691144002706","topic":"The Monkey from Riger","slcontent":"3","sltopic":"1","contentset":"Lesson - 3","timeDuration":"5","quiz":[],"isPremium":true,"videos":[],"concepts":[],"slsubject":"2"}],"edchildrevisioncompleteschemas":[{"_id":{"$oid":"659580293aaddf7594689d18"},"childid":"WELL1703316202984","subjectDetails":[{"subjectid":"1691130406151","subject":"English","completestatus":"false","topicDetails":[{"topicid":"1691144002706","topic":"The Monkey from Riger","completestatus":"true"},{"topicid":"1691154462501","topic":"The Little Round Bun (1)","completestatus":"true"}]},{"subjectid":"1691133599736","subject":"ସାମାଜିକ ବିଜ୍ଞାନ","completestatus":"false","topicDetails":[{"topicid":"1691561384319","topic":"ସାମାଜିକ ଶୃଙ୍ଖଳା","completestatus":"true"}]}]},{"_id":{"$oid":"659580293aaddf7594689d19"},"childid":"WELL170331620298978","subjectDetails":[{"subjectid":"1691130406151","subject":"English","completestatus":"false","topicDetails":[{"topicid":"1691144002706","topic":"The Monkey from Riger","completestatus":"true"}]}]}],subject:[{"_id":"64c7baab2b1f56f9af79d0e6","subjectid":"ଗଣି51ADA1690811051095","subject":"ଗଣିତ","subjectImage":"https://wkresources.s3.ap-south-1.amazonaws.com/1691760867048_600009910.png","stageid":"5","stage":"STD-5","boardid":"1","boardname":"BSE","scholarshipid":"NVOOKADA1690811843420","scholarshipname":"Adarsh","__v":0,"updatedon":"2024-03-21T11:03:38.789Z","slsubject":"2"},{"_id":"64cca69156738e9f1507f915","subjectid":"1691133585558","subject":"ବିଜ୍ଞାନ","subjectImage":"https://wkresources.s3.ap-south-1.amazonaws.com/1700718807924_717730005.png","stageid":"5","stage":"STD-5","boardid":"1","boardname":"BSE","scholarshipid":"NVOOKADA1690811843420","scholarshipname":"Adarsh","createon":"2023-08-04T07:19:45.558Z","updatedon":"2023-11-23T05:53:29.545Z","__v":0,"slsubject":"3"},{"_id":"64cc9a2656738e9f1507f521","subjectid":"1691130406151","subject":"English","subjectImage":"https://wkresources.s3.ap-south-1.amazonaws.com/1691761437925_644750345.png","stageid":"5","stage":"STD-5","boardid":"1","boardname":"BSE","scholarshipid":"NVOOKADA1690811843420","scholarshipname":"Adarsh","createon":"2023-08-04T06:26:46.154Z","updatedon":"2023-08-14T13:07:16.256Z","__v":0,"slsubject":"1"},{"_id":"64f82559b31acd1e64e65083","subjectid":"1693984089581","subject":"English Grammar","slsubject":"5","subjectImage":"","stageid":"5","stage":"STD-5","boardid":"1","boardname":"BSE","scholarshipid":"NVOOKADA1690811843420","scholarshipname":"Adarsh","createon":"2023-09-06T07:08:09.582Z","updatedon":"2024-03-23T06:39:39.711Z","__v":0}]}
Query
db.subject.aggregate([{$match:{stageid:"5",boardid:"1",scholarshipid:"NVOOKADA1690811843420"}},{$lookup:{from:"edcontentmaster",let:{stageid:"$stageid",subjectid:"$subjectid",boardid:"$boardid",scholarshipid:"$scholarshipid"},pipeline:[{$match:{$expr:{$and:[{$eq:["$stageid","$$stageid"]},{$eq:["$subjectid","$$subjectid"]},{$eq:["$boardid","$$boardid"]},{$eq:["$scholarshipid","$$scholarshipid"]}]}}},{$addFields:{convertedField:{$cond:{if:{$eq:["$slcontent",""]},then:"$slcontent",else:{$toInt:"$slcontent"}}}}},{$sort:{slcontent:1}},{$group:{_id:"$topic",topicimage:{$first:"$topicimage"},topicid:{$first:"$topicid"},sltopic:{$first:"$sltopic"},studenttopic:{$first:"$studenttopic"},reviewquestionsets:{$push:{id:"$_id",sub:"$sub",topic:"$topic",contentset:"$contentset",stage:"$stage",timeDuration:"$timeDuration",contentid:"$contentid",studentdata:"$studentdata",subjectIamge:"$subjectIamge",topicImage:"$topicImage",contentImage:"$contentImage",isPremium:"$isPremium"}}}},{$lookup:{from:"edchildrevisioncompleteschemas",let:{childid:"WELL1703316202984",/**childid,*/subjectid:"1691130406151",/**subjectid,*/topicid:"$topicid"},pipeline:[{$match:{$expr:{$and:[{$eq:["$childid","$$childid"]},{$in:["$$subjectid","$subjectDetails.subjectid"]},{$in:["$$topicid",{$reduce:{input:"$subjectDetails",initialValue:[],in:{$concatArrays:["$$value","$$this.topicDetails.topicid"]}}}]}]}}},{$project:{_id:1,childid:1}}],as:"studenttopic"}},{$project:{_id:0,topic:"$_id",topicimage:1,topicid:1,sltopic:1,studenttopic:1,contentid:"$contentid",reviewquestionsets:1}}],as:"topicDetails"}},{$set:{topicDetails:{$first:"$topicDetails"}}}])