Query for documents where array size is greater than 1

by

There’s a more efficient way to do this in MongoDB 2.2+ now that you can use numeric array indexes (0 based) in query object keys.

// Find all docs that have at least two name array elements.
db.accommodations.find({'name.1': {$exists: true}})

You can support this query with an index that uses a partial filter expression (requires 3.2+):

// index for at least two name array elements
db.accommodations.createIndex(
    {'name.1': 1},
    {partialFilterExpression: {'name.1': {$exists: true}}}
);

More Related Contents:

  1. Find objects between two dates MongoDB
  2. Get names of all keys in the collection
  3. How to filter array in subdocument with MongoDB [duplicate]
  4. Find in Double Nested Array MongoDB
  5. MongoDB: upsert sub-document
  6. Conditional $sum in MongoDB
  7. arrayFilters in mongodb
  8. Get a count of total documents with MongoDB when using limit
  9. mongodb count num of distinct values per field/key
  10. MongoDB: How to query for records where field is null or not set?
  11. exclude fields in $lookup aggregation
  12. MongoDB aggregation comparison: group(), $group and MapReduce
  13. Add some kind of row number to a mongodb aggregate command / pipeline
  14. MongoDB group by array inner-elements
  15. Multiple Counts with single query in mongodb
  16. MongoDB ‘unable to find index for $geoNear query’
  17. MongoDB sort documents by array elements
  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 print distance between two points
  21. Mongodb aggregation $group, restrict length of array
  22. Get n-th element of an array in MongoDB
  23. Geospatial $near within current document field value
  24. How do I rename fields when performing search/projection in MongoDB?
  25. Mongodb aggregation pipeline how to limit a group push
  26. How to get back the new value after an update in a embedded array?
  27. How can I sort a Meteor collection by time of insertion?
  28. Mongodb concat int and string
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment