[{"_id":{"$oid":"6678d3b714c2fef2955395ca"},"referenceNo":"TCK_06-24-2024_0001","subject":{"$oid":"6678d28814c2fef2955395b7"},"description":"ticket 1","priority":"low","status":"open","initiator":{"$oid":"6678d1f814c2fef2955395b0"},"createdBy":{"$oid":"6678d22514c2fef2955395b2"},"assignedTo":null,"attachments":[{"originalName":"bini-mikha.jpg","newName":"binimikhajpg_1719194551362.jpg","encoding":"7bit","extension":"jpg","mimetype":"image/jpeg","size":5861,"_id":{"$oid":"6678d3b714c2fef2955395cb"}},{"originalName":"bini-mikha-fox.jpg","newName":"binimikhafoxjpg_1719194551363.jpg","encoding":"7bit","extension":"jpg","mimetype":"image/jpeg","size":94048,"_id":{"$oid":"6678d3b714c2fef2955395cc"}}],"comments":[{"_id":{"$oid":"6678d56e14c2fef2955395d9"},"userId":{"$oid":"6678d24714c2fef2955395b4"},"content":"ticket 1 comment 1","attachments":[]},{"_id":{"$oid":"6678d63114c2fef2955395f0"},"userId":{"$oid":"6678d24714c2fef2955395b4"},"content":"ticket 1 comment 2 w/ 2 attachment","attachments":[{"originalName":"bini-langgo.txt","newName":"binilanggotxt_1719195185373.txt","encoding":"7bit","extension":"txt","mimetype":"text/plain","_id":{"$oid":"6678d63114c2fef2955395f1"}},{"originalName":"bini-maoy.docx","newName":"binimaoydocx_1719195185373.docx","encoding":"7bit","extension":"docx","mimetype":"application/vnd.openxmlformats-officedocument.wordprocessingml.document","_id":{"$oid":"6678d63114c2fef2955395f2"}}]}]},{"_id":{"$oid":"6678d46914c2fef2955395d2"},"referenceNo":"TCK_06-24-2024_0002","subject":{"$oid":"6678d29014c2fef2955395ba"},"description":"ticket 2","priority":"low","status":"open","initiator":{"$oid":"6678d1f814c2fef2955395b0"},"createdBy":{"$oid":"6678d22514c2fef2955395b2"},"assignedTo":null,"attachments":[{"originalName":"bini-aiah C3.jpg","newName":"biniaiah-C3jpg_1719194729039.jpg","encoding":"7bit","extension":"jpg","mimetype":"image/jpeg","size":237650,"_id":{"$oid":"6678d46914c2fef2955395d3"}},{"originalName":"bini-aiah.png","newName":"biniaiahpng_1719194729042.png","encoding":"7bit","extension":"png","mimetype":"image/png","size":980503,"_id":{"$oid":"6678d46914c2fef2955395d4"}}],"comments":[{"_id":{"$oid":"6678d6b114c2fef2955395fd"},"userId":{"$oid":"6678d24714c2fef2955395b4"},"content":"ticket 2 comment 1 w/ 2 attachment","attachments":[{"originalName":"bini-maoy.docx","newName":"binimaoydocx_1719195313255.docx","encoding":"7bit","extension":"docx","mimetype":"application/vnd.openxmlformats-officedocument.wordprocessingml.document","_id":{"$oid":"6678d6b114c2fef2955395fe"}},{"originalName":"bini-rocha.pdf","newName":"binirochapdf_1719195313255.pdf","encoding":"7bit","extension":"pdf","mimetype":"application/pdf","_id":{"$oid":"6678d6b114c2fef2955395ff"}}]},{"_id":{"$oid":"6678d6ef14c2fef29553960c"},"userId":{"$oid":"6678d24714c2fef2955395b4"},"content":"ticket 2 comment 2","attachments":[]}]}]

db.collection.aggregate([{$match:{_id:ObjectId("6678d3b714c2fef2955395ca"),"comments._id":ObjectId("6678d63114c2fef2955395f0")}},{$set:{comments:{$filter:{input:"$comments",as:"c",cond:{$eq:["$$c._id",ObjectId("6678d63114c2fef2955395f0")]}}}}},{"$unwind":"$comments"},{$set:{"comments.attachments":{$filter:{input:"$comments.attachments",as:"ca",cond:{$eq:["$$ca._id",ObjectId("6678d63114c2fef2955395f1")]}}}}}])