Matching an array field which contains any combination of the provided array in MongoDB

by

You can do this by combining multiple operators:

db.test.find({tags: {$not: {$elemMatch: {$nin: ['Rad', 'Cool']}}}})

The $elemMatch with the $nin is finding the docs where a single tags element is neither ‘Rad’ nor ‘Cool’, and then the parent $not inverts the match to return all the docs where that didn’t match any elements.

However, this will also return docs where tags is either missing or has no elements. To exclude those you need to add a qualifier that ensures tags has at least one element:

db.test.find({
    tags: {$not: {$elemMatch: {$nin: ['Rad', 'Cool']}}},
    'tags.0': {$exists: true}
})

More Related Contents:

  1. MongoDB first time user setup [closed]
  2. How do I perform the SQL Join equivalent in MongoDB?
  3. MongoDB: How to update multiple documents with a single command?
  4. Can you specify a key for $addToSet in Mongo?
  5. How to execute mongo commands through shell scripts?
  6. pushing object into array schema in Mongoose
  7. Performing regex queries with PyMongo
  8. How to remove an element from a doubly-nested array in a MongoDB document.
  9. Check if every element in array matches condition
  10. Updating nested arrays in mongoDB via mongo shell [duplicate]
  11. How can I get a random record from MongoDB?
  12. How do I convert a property in MongoDB from text to date type?
  13. Merging two collections in MongoDB
  14. MongoDB can’t find data directory after upgrading to Mac OS 10.15 (Catalina)
  15. Matching ObjectId to String for $graphLookup
  16. MongoDB-CR Authentication failed
  17. Mongodb aggregation lookup with conditions
  18. Create an ISODate with pyMongo
  19. MongoDB lookup when foreign field is an array of objects
  20. Get the latest record from mongodb collection
  21. Collision probability of ObjectId vs UUID in a large distributed system
  22. How can I sort into that nulls are last ordered in mongodb?
  23. What does it mean to fit “working set” into RAM for MongoDB?
  24. $skip and $limit in aggregation framework
  25. Mongodb Aggregation Framework | Group over multiple values?
  26. How does MongoDB order their docs in one collection? [duplicate]
  27. Group by sum mongodb [duplicate]
  28. MongoDB on Ubuntu won’t start as a service, nothing in the log
  29. Mongodb concat int and string
  30. Aggregation with update in mongoDB

Leave a Comment