db={products:[{"_id":90888,"manufacturer":"CCComps","factoryLocation":"China","category":56514,"categoryName":"Electronics","price":550,"model":"CC-1000","quantity":10},{"_id":922229,"manufacturer":"CCComps","factoryLocation":"China","category":56514,"categoryName":"Electrical","price":700,"model":"CM-1500","quantity":10}],"product-categories":[{"_id":22322,"product-categories":[{"productName":"Camera","categoryName":"Electronics","categoryId":56514},{"productName":"Samsung Smart TV","categoryName":"Electricals","categoryId":56514}]}]}

db.products.aggregate([{$match:{/** search terms here*/category:56514,categoryName:"Electronics",manufacturer:"CCComps",factoryLocation:"China"}},{$lookup:{from:"product-categories",as:"prodCatInfo",let:{catName:"$categoryName",catId:"$category"},pipeline:[{/** reduce number of records before unwind*/$match:{$expr:{$in:["$$catId","$product-categories.categoryId"]}}},{$unwind:"$product-categories"},{$match:{$expr:{$eq:["$product-categories.categoryName","$$catName"]}}}]}},{$set:{productName:{$first:"$prodCatInfo.product-categories.productName"},productCategoryId:"$category"}},{$unset:["factoryLocation","manufacturer","prodCatInfo"]}])