Database
db={"details":[{"quantity":2000,"quotes_id":["SQ-CPQ10037"],"status":"processed","logs":[""],"product_id":"5ff5cf3dc1ceb9144901da81"}],"quotes":[{"_id":"SQ-CPQ10037","product_id":"5ff5cf3dc1ceb9144901da81"}]}
Query
db.quotes.aggregate([{$lookup:{from:"details","let":{"product_id":"$product_id","quotes_id":"$_id"},pipeline:[{$match:{$expr:{$and:[{$in:["$$quotes_id","$quotes_id"]},{$eq:["$product_id","$$product_id"]},]}}}],as:"product.productquotes",}}])