MongoDB Query Help – query on values of any key in a sub-object

by

If you don’t know what the keys will be and you need it to be interactive, then you’ll need to use the (notoriously performance challenged) $where operator like so (in the shell):

db.test.find({$where: function() { 
    for (var field in this.settings) { 
        if (this.settings[field] == "red") return true;
    }
    return false;
}})

If you have a large collection, this may be too slow for your purposes, but it’s your only option if your set of keys is unknown.

MongoDB 3.6 Update

You can now do this without $where by using the $objectToArray aggregation operator:

db.test.aggregate([
  // Project things as a key/value array, along with the original doc
  {$project: {
    array: {$objectToArray: '$things'},
    doc: '$$ROOT'
  }},

  // Match the docs with a field value of 'red'
  {$match: {'array.v': 'red'}},

  // Re-project the original doc
  {$replaceRoot: {newRoot: '$doc'}}
])

More Related Contents:

  1. MEAN app vs. Mongo service local in Angular2
  2. MongoDB: Combine data from multiple collections into one..how?
  3. MongoDB: Is it possible to make a case-insensitive query?
  4. MongoDB: count the number of items in an array
  5. How to remove a field completely from a MongoDB document?
  6. mongoDB/mongoose: unique if not null
  7. Get distinct records values
  8. arrayFilters in mongodb
  9. How do I search for an object by its ObjectId in the mongo console?
  10. MongoDB password with “@” in it
  11. exclude fields in $lookup aggregation
  12. Mongo how to $lookup with DBRef
  13. Add some kind of row number to a mongodb aggregate command / pipeline
  14. How to enforce foreign keys in NoSql databases (MongoDB)?
  15. MongoDB select count(distinct x) on an indexed column – count unique results for large data sets
  16. MongoDB 3.2 authentication failed
  17. MongoDB sort documents by array elements
  18. MongoDB won’t start after server crash
  19. Does Mongoose support the Mongodb `findAndModify` method?
  20. MongoDB Text Search AND multiple search words
  21. How does sorting with an index work in MongoDB?
  22. How to use dot in field name?
  23. Docker: change folder where to store docker volumes
  24. What is the maximum number of parameters passed to $in query in MongoDB?
  25. How to organise a many to many relationship in MongoDB
  26. Mongodb aggregation pipeline how to limit a group push
  27. MongoDB : aggregation framework : $match between fields
  28. MongoDB on Ubuntu won’t start as a service, nothing in the log
  29. MongoDB: how to count number of keys in a document?
  30. Query for a field in an object in array with Mongo?

Leave a Comment