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"}]}]}]}

db.edcontentmaster.aggregate([/**{* $match: {* stageid: stageid,* subjectid: subjectid,* boardid: boardid,* 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}}])