Find MongoDB records where array field is not empty

by

If you also have documents that don’t have the key, you can use:

ME.find({ pictures: { $exists: true, $not: {$size: 0} } })

MongoDB doesn’t use indexes if $size is involved, so here is a better solution:

ME.find({ pictures: { $exists: true, $ne: [] } })

If your property can have invalid values (like null boolean or others) , then you an add an additional check using $types as proposed in this answer:

With mongo >= 3.2:

ME.find({ pictures: { $exists: true, $type: 'array', $ne: [] } })

With mongo < 3.2:

ME.find({ pictures: { $exists: true, $type: 4, $ne: [] } })

Since the MongoDB 2.6 release, you can compare with the operator $gt, but this could lead to unexpected results (you can find a detailed explanation in this answer):

ME.find({ pictures: { $gt: [] } })

More Related Contents:

  1. MEAN app vs. Mongo service local in Angular2
  2. Moongoose aggregate $match does not match id’s
  3. What’s Mongoose error Cast to ObjectId failed for value XXX at path “_id”?
  4. How to paginate with Mongoose in Node.js?
  5. Cascade style delete in Mongoose
  6. mongoDB/mongoose: unique if not null
  7. pushing object into array schema in Mongoose
  8. Mongoose Unique index not working!
  9. How to push an array of objects into an array in mongoose with one call?
  10. arrayFilters in mongodb
  11. How do you use Mongoose without defining a schema?
  12. How do I query for distinct values in Mongoose?
  13. Creating Multifield Indexes in Mongoose / MongoDB
  14. MongoDB password with “@” in it
  15. Exception: can’t convert from BSON type EOO to Date
  16. How can I update multiple documents in mongoose?
  17. How to return just the nested documents of an array from all documents
  18. Mongoose’s find method with $or condition does not work properly
  19. Does Mongoose support the Mongodb `findAndModify` method?
  20. Image returned from REST API always displays broken
  21. Mongoose limit/offset and count query
  22. Can’t find documents searching by ObjectId using Mongoose
  23. Mongodb aggregation $group, restrict length of array
  24. Mongoose: deep population (populate a populated field)
  25. getting schema attributes from Mongoose Model
  26. querying a collection without passing schema in mongoose
  27. Find documents whose array field contains at least n elements of a given array
  28. MongoDB via Mongoose JS – What is findByID?
  29. MongoDB count() versus countDocuments()
  30. Mongodb, aggregate query with $lookup

Leave a Comment