MongoDB: count the number of items in an array

by

In MongoDB 2.6, the Aggregation Framework has a new array $size operator you can use:

> db.mycollection.insert({'foo':[1,2,3,4]})
> db.mycollection.insert({'foo':[5,6,7]})

> db.mycollection.aggregate([{$project: { count: { $size:"$foo" }}}])
{ "_id" : ObjectId("5314b5c360477752b449eedf"), "count" : 4 }
{ "_id" : ObjectId("5314b5c860477752b449eee0"), "count" : 3 }

More Related Contents:

  1. Batch insert/update using Mongoid?
  2. Difference between “id” and “_id” fields in MongoDB
  3. How to deal with the timezone issue when storing dates in utc using mongod?
  4. MongoDB first time user setup [closed]
  5. Ways to implement data versioning in MongoDB
  6. How to replace substring in mongodb document
  7. How do you use Mongoose without defining a schema?
  8. MongoDB nested lookup with 3 levels
  9. MongoDB : Aggregation framework : Get last dated document per grouping ID
  10. MongoDB: Unique index on array element’s property
  11. MongoDB vs. Cassandra [closed]
  12. Select Max() with “group by” in mongodb
  13. Rounding to 2 decimal places using MongoDB aggregation framework
  14. How to print out more than 20 items (documents) in MongoDB’s shell?
  15. Why does direction of index matter in MongoDB?
  16. mongodb get distinct records
  17. Matching an array field which contains any combination of the provided array in MongoDB
  18. MongoDB lookup when foreign field is an array of objects
  19. Get the latest record from mongodb collection
  20. Collision probability of ObjectId vs UUID in a large distributed system
  21. $skip and $limit in aggregation framework
  22. Read-only file system when attempting mkdir /data/db on Mac [closed]
  23. Mongodb Aggregation Framework | Group over multiple values?
  24. How does MongoDB order their docs in one collection? [duplicate]
  25. How to check if an array field contains a unique value or another array in MongoDB?
  26. MongoDB.service failed with result exit-code
  27. How can I sort a Meteor collection by time of insertion?
  28. MongoDB index/RAM relationship
  29. Export mongodb aggregation framework result to a new collection
  30. MongoDB {aggregation $match} vs {find} speed

Leave a Comment