Filtering embedded documents in MongoDB

by

There’s currently no way to filter on embedded docs in the way you’re describing. Using the dot notation allows you to match on an embedded doc, but the entire document, parent and all, will still be returned. It’s also possible to select which fields will be returned, but that doesn’t really help your case, either.

We have a “virtual collections” case, which would implement the desired functionality; feel free to vote on it:

http://jira.mongodb.org/browse/SERVER-142

In the meantime, you should probably treat comments as their own collection. In general, if you need to work with a given data set on its own, make it a collection. If it’s better conceived of as part of some other set, it’s better to embed.

More Related Contents:

  1. Update field in exact element array in MongoDB
  2. MongoDB: How to update multiple documents with a single command?
  3. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  4. Add new field to every document in a MongoDB collection
  5. Querying internal array size in MongoDB
  6. How can I run MongoDB as a Windows service?
  7. Where does mongodb stand in the CAP theorem?
  8. How to enforce foreign keys in NoSql databases (MongoDB)?
  9. NoSQL (MongoDB) vs Lucene (or Solr) as your database [closed]
  10. How do you query for “is not null” in Mongo?
  11. MongoDB lookup when foreign field is an array of objects
  12. How to stop insertion of Duplicate documents in a mongodb collection
  13. MongoDB nested array query
  14. MongoDB/NoSQL: Keeping Document Change History
  15. Is mongodb running?
  16. Does MongoDB support floating point types?
  17. MongoDB normalization, foreign key and joining
  18. Unique IDs with mongodb
  19. Get a document in MongoDB without specifying collection
  20. MongoDB wildcard in the key of a query
  21. How to create a DB for MongoDB container on start up?
  22. MongoDB field order and document position change after update
  23. MongoDB Full and Partial Text Search
  24. How to enable authentication on MongoDB through Docker?
  25. Mongodb Join on _id field from String to ObjectId
  26. Mongo, find through list of ids
  27. Difference between “id” and “_id” fields in MongoDB
  28. Push to two separate arrays in one update call in mongodb
  29. How to toggle a boolean field in one document with atomic operation?
  30. MongoDB count() versus countDocuments()

Leave a Comment