db={"TempProducts":[{"_id":{"$oid":"66fc0b82ba7d99036d104e74"},"name":"Miniature Storage","sku":"MS-MUM","files":[{"file":{"$oid":"66b2200aef77b9fedbaa617b"},"requiredCount":0},{"file":{"$oid":"66b2200aef77b9fedbaa617c"},"requiredCount":0},{"file":{"$oid":"66b2200aef77b9fedbaa617d"},"requiredCount":0},{"file":{"$oid":"66b2200aef77b9fedbaa617e"},"requiredCount":0},{"file":{"$oid":"66b2200aef77b9fedbaa617e"},"requiredCount":0},{"file":{"$oid":"66b2200aef77b9fedbaa617e"},"requiredCount":0},{"file":{"$oid":"66b2200aef77b9fedbaa6180"},"requiredCount":0}],"materialType":"Wood","machineType":"standard","parentSKU":"MS-MU"}],"TempFiles":[{"_id":{"$oid":"663e1ea8c603a49583d69bd4"},"filename":"ARK-M2E.rd","label":"","outputCount":0,"process":"Cut","material":{"$oid":"66134bb1a03364ae7305dcf7"}},{"_id":{"$oid":"66b2200aef77b9fedbaa617b"},"filename":"MS-MU1.RD","label":"Sheet 1","outputCount":0,"process":"Cut","material":{"$oid":"66134bb1a03364ae7305dcf7"}},{"_id":{"$oid":"66b2200aef77b9fedbaa617c"},"filename":"MS-MU2.RD","label":"Sheet 2","outputCount":0,"process":"Cut","material":{"$oid":"66134bb1a03364ae7305dcf7"}},{"_id":{"$oid":"66b2200aef77b9fedbaa617d"},"filename":"MS-MU3.RD","label":"Sheet 3","outputCount":0,"process":"Cut","material":{"$oid":"66134bb1a03364ae7305dcf7"}},{"_id":{"$oid":"66b2200aef77b9fedbaa617e"},"filename":"MS-MUT1.RD","label":"Tray 1","outputCount":0,"process":"Cut","material":{"$oid":"66134bb1a03364ae7305dcf7"}},{"_id":{"$oid":"66b2200aef77b9fedbaa617f"},"filename":"MS-MUT2.RD","label":"Tray 2","outputCount":0,"process":"Cut","material":{"$oid":"66134bb1a03364ae7305dcf7"}},{"_id":{"$oid":"66b2200aef77b9fedbaa6180"},"filename":"MS-MUT3.RD","label":"Tray 3","outputCount":0,"process":"Cut","material":{"$oid":"66134bb1a03364ae7305dcf7"}},{"_id":{"$oid":"66c3483760ea0061a28906a6"},"filename":"SWU-H1.RD","label":"Sheet 1","outputCount":0,"process":"Cut","material":{"$oid":"66134bb1a03364ae7305dcf7"}},{"_id":{"$oid":"66c3483760ea0061a28906a7"},"filename":"SWU-H2.RD","label":"Sheet 2","outputCount":0,"process":"Cut","material":{"$oid":"66134bb1a03364ae7305dcf7"}},{"_id":{"$oid":"66c3483760ea0061a28906a8"},"filename":"SWU-H3.RD","label":"Sheet 3","outputCount":0,"process":"Cut","material":{"$oid":"66134bb1a03364ae7305dcf7"}}]}

db.TempProducts.aggregate([{"$lookup":{"from":"TempFiles","let":{"file":"$files.file"},"pipeline":[{"$match":{"$expr":{"$in":["$_id","$$file"]}}},{"$lookup":{"from":"Materials","localField":"material","foreignField":"_id","as":"material"}}],"as":"files"}}])