Breaking News: Grepper is joining You.com. Read the official announcement!

$lookup mongodb

Liubomyr Siusar answered on October 5, 2022 Popularity 10/10 Helpfulness 4/10

answer $lookup mongodb

$lookup mongodb

Comment

db.orders.insertMany( [
   { "_id" : 1, "item" : "almonds", "price" : 12, "quantity" : 2 },
   { "_id" : 2, "item" : "pecans", "price" : 20, "quantity" : 1 },
   { "_id" : 3  }
] )


db.inventory.insertMany( [
   { "_id" : 1, "sku" : "almonds", "description": "product 1", "instock" : 120 },
   { "_id" : 2, "sku" : "bread", "description": "product 2", "instock" : 80 },
   { "_id" : 3, "sku" : "cashews", "description": "product 3", "instock" : 60 },
   { "_id" : 4, "sku" : "pecans", "description": "product 4", "instock" : 70 },
   { "_id" : 5, "sku": null, "description": "Incomplete" },
   { "_id" : 6 }
] )

/* 
Next aggregate:
  1) iterates over all docums from "orders"
  2) get from collection "inventory" field "sku", check value
  3) get from collection "orders" field "item", check value
  4) if values are equal - get full docum from "inventory" and add 
    to "inventory_docs" list of docums
  5) result of aggregate will be 
  [
    {
      ...[element from "orders" collection],
      inventory_docs: [
        [list of docums from "inventory"]
      ]
    },{
      ...
    }
  ]
*/

db.orders.aggregate([
   {
     $lookup:
       {
         from: "inventory",
         localField: "item",
         foreignField: "sku",
         as: "inventory_docs"
       }
  }
])



[{
   "_id" : 1,
   "item" : "almonds",
   "price" : 12,
   "quantity" : 2,
   "inventory_docs" : [
      { "_id" : 1, "sku" : "almonds", "description" : "product 1", "instock" : 120 }
   ]
}
{
   "_id" : 2,
   "item" : "pecans",
   "price" : 20,
   "quantity" : 1,
   "inventory_docs" : [
      { "_id" : 4, "sku" : "pecans", "description" : "product 4", "instock" : 70 }
   ]
}
{
   "_id" : 3,
   "inventory_docs" : [
      { "_id" : 5, "sku" : null, "description" : "Incomplete" },
      { "_id" : 6 }
   ]
}]

Popularity 10/10 Helpfulness 4/10 Language javascript

Source: Grepper

Tags: javascript mongodb

Link to this answer
Share Copy Link

Contributed on Oct 05 2022

Liubomyr Siusar

0 Answers Avg Quality 2/10

$lookup mongodb

Contents

More Related Answers

$lookup mongodb

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.