Get n-th element of an array in MongoDB

by

Use $slice. 

db.foo.find({ bar : "xyz" } , { my_array : { $slice : [n , 1] } } )

will retrieve the nth element of the array “my_array” of all documents in the foo collection where bar = “xyz”.

Some other examples from the MongoDB documentation:

db.posts.find({}, {comments:{$slice: 5}}) // first 5 comments
db.posts.find({}, {comments:{$slice: -5}}) // last 5 comments
db.posts.find({}, {comments:{$slice: [20, 10]}}) // skip 20, limit 10
db.posts.find({}, {comments:{$slice: [-20, 10]}}) // 20 from end, limit 10

Which you can read here: http://www.mongodb.org/display/DOCS/Retrieving+a+Subset+of+Fields

More Related Contents:

  1. Group result by 15 minutes time interval in MongoDb
  2. Does MongoDB’s $in clause guarantee order
  3. $lookup on ObjectId’s in an array
  4. Moongoose aggregate $match does not match id’s
  5. Find in Double Nested Array MongoDB
  6. Return only matched sub-document elements within a nested array
  7. Check if every element in array matches condition
  8. MongoDB nested lookup with 3 levels
  9. Get a count of total documents with MongoDB when using limit
  10. Include all existing fields and add new fields to document
  11. Matching ObjectId to String for $graphLookup
  12. mongodb count num of distinct values per field/key
  13. MongoDB aggregation comparison: group(), $group and MapReduce
  14. Mongodb aggregation lookup with conditions
  15. How to get back the Original document back after aggregation
  16. MongoDB group by array inner-elements
  17. Multiple Counts with single query in mongodb
  18. How to return array of string with mongodb aggregation
  19. How to return just the nested documents of an array from all documents
  20. MongoDB lookup when foreign field is an array of objects
  21. Search on multiple collections in MongoDB
  22. Mongodb aggregation $group, restrict length of array
  23. How to access overall document count during arithmetic aggregation expression
  24. How do I rename fields when performing search/projection in MongoDB?
  25. mongodb aggregation framework match by nested documents
  26. count array occurrences across all documents with mongo
  27. Mongodb concat int and string
  28. Return actual type of a field in MongoDB
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment