MongoDB – Query on the last element of an array?

by

In 3.2 this is possible. First project so that myField contains only the last element, and then match on myField.

db.collection.aggregate([
   { $project: { id: 1, myField: { $slice: [ "$myField", -1 ] } } },
   { $match: { myField: "myValue" } }
]);

More Related Contents:

  1. How to Update Multiple Array Elements in mongodb
  2. Update nested subdocuments in MongoDB with arrayFilters
  3. $in requires an array as a second argument, found: missing
  4. MongoDB: find and findOne with nested array filtering
  5. Querying MongoDB to match in the first item in an array
  6. Updating a Nested Array with MongoDB
  7. Does MongoDB’s $in clause guarantee order
  8. MongoDB, remove object from array
  9. Moongoose aggregate $match does not match id’s
  10. $lookup multiple levels without $unwind?
  11. MongoDB: How do I update a single subelement in an array, referenced by the index within the array?
  12. Mongoose find/update subdocument
  13. arrayFilters in mongodb
  14. MongoError: The ‘cursor’ option is required, except for aggregate with the explain argument
  15. MongoDB Full and Partial Text Search
  16. Updating nested arrays in mongodb
  17. mongodb find by multiple array items
  18. Bulk upsert in MongoDB using mongoose
  19. Get particular element from mongoDB array [duplicate]
  20. How to return just the nested documents of an array from all documents
  21. MongoDB: Calculate dwell time between every status value change
  22. MongoDB: how to parse date in 3.6 mongoDb version?
  23. Mongoose add multiple object to array if not exist based
  24. MongoDB – get documents with max attribute per group in a collection
  25. Remove a field from all elements in array in mongodb [duplicate]
  26. MongoDB rename database field within array
  27. Mongodb aggregation $group, restrict length of array
  28. Can you have mongo $push prepend instead of append?
  29. $project in $lookup mongodb
  30. Mongodb, aggregate query with $lookup

Leave a Comment