db={"units":[{_id:"Unit123",name:"Test Unit","sections":[{"name":"TestSection 1","contents":[{_id:"1","type":"TEXT_PAGE","pageTitle":"O cérebro e as incertezas: bases biológicas da ansiedade.","pageContent":"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam condimentum sit amet nisl in aliquam. Vivamus accumsan tortor sed egestas tempus. Nulla at vulputate urna. Phasellus urna dolor, vestibulum hendrerit eros eu, tincidunt laoreet nisi. Phasellus blandit orci in libero elementum, id pulvinar elit vehicula. Ut ullamcorper lacus ut viverra semper. Donec vehicula metus urna, rhoncus imperdiet velit mollis ultricies. Nunc malesuada tellus ut felis suscipit pellentesque."},{_id:"2","type":"TEXT_PAGE","pageTitle":"O cérebro e as incertezas: bases biológicas da ansiedade.","pageContent":"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam condimentum sit amet nisl in aliquam. Vivamus accumsan tortor sed egestas tempus. Nulla at vulputate urna. Phasellus urna dolor, vestibulum hendrerit eros eu, tincidunt laoreet nisi. Phasellus blandit orci in libero elementum, id pulvinar elit vehicula. Ut ullamcorper lacus ut viverra semper. Donec vehicula metus urna, rhoncus imperdiet velit mollis ultricies. Nunc malesuada tellus ut felis suscipit pellentesque."}],"_id":{"$oid":"63925553eeb147dc9bd894e1"}},{"name":"TestSection 2","contents":[{_id:"3","type":"TEXT_PAGE","pageTitle":"O cérebro e as incertezas: bases biológicas da ansiedade.","pageContent":"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam condimentum sit amet nisl in aliquam. Vivamus accumsan tortor sed egestas tempus. Nulla at vulputate urna. Phasellus urna dolor, vestibulum hendrerit eros eu, tincidunt laoreet nisi. Phasellus blandit orci in libero elementum, id pulvinar elit vehicula. Ut ullamcorper lacus ut viverra semper. Donec vehicula metus urna, rhoncus imperdiet velit mollis ultricies. Nunc malesuada tellus ut felis suscipit pellentesque."},{_id:"4","type":"TEXT_PAGE","pageTitle":"O cérebro e as incertezas: bases biológicas da ansiedade.","pageContent":"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam condimentum sit amet nisl in aliquam. Vivamus accumsan tortor sed egestas tempus. Nulla at vulputate urna. Phasellus urna dolor, vestibulum hendrerit eros eu, tincidunt laoreet nisi. Phasellus blandit orci in libero elementum, id pulvinar elit vehicula. Ut ullamcorper lacus ut viverra semper. Donec vehicula metus urna, rhoncus imperdiet velit mollis ultricies. Nunc malesuada tellus ut felis suscipit pellentesque."}],"_id":{"$oid":"63925553eeb147dc9bd894e2"}}],},],"users":[{id:3,name:"Abelardo Janeiro"},],"unitProgressions":[{_id:"123",unit:"Unit123",user:3,lastContent:"2",progressions:[{_id:"1",isCompleted:true,},{_id:"2",isCompleted:true,},]},]}

db.units.aggregate([{"$unwind":"$sections"},{"$unwind":"$sections.contents"},{"$lookup":{"from":"unitProgressions",let:{contentsId:"$sections.contents._id"},pipeline:[{"$unwind":"$progressions"},{$match:{$expr:{$eq:["$$contentsId","$progressions._id"]}}},],"as":"sections.contents.unitProgression"}},{"$unwind":{path:"$sections.contents.unitProgression","preserveNullAndEmptyArrays":true}},])