Check if every element in array matches condition

by

The query you want is this:

db.collection.find({"users":{"$not":{"$elemMatch":{"user":{$nin:[1,5,7]}}}}})

This says find me all documents that don’t have elements that are outside of the list 1,5,7.

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. MongoDB aggregation comparison: group(), $group and MapReduce
  3. Remove Duplicates from MongoDB
  4. Retrieve only the queried element in an object array in MongoDB collection
  5. Update MongoDB field using value of another field
  6. Get names of all keys in the collection
  7. How to filter array in subdocument with MongoDB [duplicate]
  8. MongoDB: Combine data from multiple collections into one..how?
  9. Multiple join conditions using the $lookup operator
  10. Return only matched sub-document elements within a nested array
  11. Converting string to date in mongodb
  12. exclude fields in $lookup aggregation
  13. Add some kind of row number to a mongodb aggregate command / pipeline
  14. MongoDB group by array inner-elements
  15. Mongo sort on a calculated condition
  16. Find all duplicate documents in a MongoDB collection by a key field
  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: Calculate dwell time between every status value change
  21. MongoDB: how to parse date in 3.6 mongoDb version?
  22. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  23. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  24. convert iso date to timestamp in mongo query
  25. Using $slice operator to get last element of array
  26. How to access overall document count during arithmetic aggregation expression
  27. Mongodb aggregation pipeline how to limit a group push
  28. Mongodb, aggregate query with $lookup
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. Return the last “true” value for each group

Leave a Comment