How to count objects in an array in mongodb?

Question

I want to count objects whose quantity is 3 in an array in the document whose _id is 1.

{
   _id: 0,
   items: [
     { item_id: 43, quantity: 2, price: 10 },
     { item_id: 2, quantity: 1, price: 240 }
   ]
}
{
   _id: 1,
   items: [
     { item_id: 23, quantity: 3, price: 110 },
     { item_id: 103, quantity: 3, price: 5 },
     { item_id: 38, quantity: 2, price: 300 }
   ]
}
{
    _id: 2,
    items: [
       { item_id: 4, quantity: 1, price: 23 }
    ]
}

What should I do?

Ashh · Accepted Answer · 2019-05-14 08:02:06Z

2

You just need to use $size along with the $filter aggregation operator

db.collection.aggregate([
  { '$match': { '_id': 1 }},
  { '$project': {
    'counts': {
      '$size': {
        '$filter': {
          'input': '$items',
          'cond': { '$eq': ['$$this.quantity', 3] }
        }
      }
    }
  }}
])

MongoPlayground

edited May 14, 2019 at 8:02

answered May 14, 2019 at 7:55

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Comments

Rohit Sawant · Accepted Answer · 2019-05-14 07:57:22Z

0

You can use $size aggregation function of mongodb and get the required result

answered May 14, 2019 at 7:57

Rohit Sawant

366 bronze badges

Collectives™ on Stack Overflow

How to count objects in an array in mongodb?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related