MongoDB querying on array of documents

Question

I have the following data in the db

  { item: "journal", instock: [ { warehouse: "A", qty: 5 }, { warehouse: "C", qty: 15 } ] },
  { item: "notebook", instock: [ { warehouse: "C", qty: 5 } ] },
  { item: "paper", instock: [ { warehouse: "A", qty: 60 }, { warehouse: "B", qty: 15 } ] },
  { item: "planner", instock: [ { warehouse: "A", qty: 40 }, { warehouse: "B", qty: 5 } ] },
  { item: "postcard", instock: [ { warehouse: "B", qty: 15 }, { warehouse: "C", qty: 35 } ] }

I need to find out the warehouse which has

15 qty of paper
35 qty of postcard

Wernfried Domscheit · Accepted Answer · 2020-02-24 12:29:51Z

1

Try using this find query.

db.warehouse.find(
   {
      $or: [
         {
            item: "paper",
            instock: { $elemMatch: { qty: 15 } }
         },
         {
            item: "postcard",
            instock: { $elemMatch: { qty: 35 } }
         }
      ]
   }
)

edited Feb 24, 2020 at 12:29

Wernfried Domscheit

60.4k10 gold badges93 silver badges132 bronze badges

answered Feb 24, 2020 at 12:26

bunny9969

213 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mayur Vaghasiya · Accepted Answer · 2020-02-24 11:47:58Z

0

try this code may help you

db.getCollection('warehouses').aggregate([
  {
    $unwind: "$instock"
  },
  {
    $match: {
      $or: [
        {
          $and: [{ 'item': 'paper' }, { 'instock.qty': { $eq: 15 } }]
        },
        {
          $and: [{ 'item': 'postcard' }, { 'instock.qty': { $eq: 35 } }]
        }
      ]
    }
  }
])

answered Feb 24, 2020 at 11:47

Mayur Vaghasiya

1,4812 gold badges18 silver badges27 bronze badges

Collectives™ on Stack Overflow

MongoDB querying on array of documents

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related