How to return just the nested documents of an array from all documents

by

You can do this using .aggregate() and predominantly the $unwind pipeline operator:

In modern MongoDB 3.4 and above you can use in tandem with $replaceRoot

Model.aggregate([
  { "$unwind": "$books" },
  { "$replaceRoot": { "newRoot": "$books" } }
],function(err,results) {

})

In earlier versions you specify all fields with $project:

Model.aggregate([
  { "$unwind": "$books" },
  { "$project": {
    "_id": "$books._id",
    "pages": "$books.pages",
    "title": "$books.title"
  }}
],function(err,results) {

})

So $unwind is what you use to deconstruct or “denormalise” the array entries for processing. Effectively this creates a copy of the whole document for each member of the array.

The rest of the task is about returning “only” those fields present in the array.

It’s not a very wise thing to do though. If your intent is to only return content embedded within an array of a document, then you would be better off putting that content into a separate collection instead.

It’s far better for performance, pulling apart a all documents from a collection with the aggregation framework, just to list those documents from the array only.

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. Moongoose aggregate $match does not match id’s
  3. MongoDB: Calculate dwell time between every status value change
  4. MongoDB: how to parse date in 3.6 mongoDb version?
  5. Mongodb aggregation $group, restrict length of array
  6. $project in $lookup mongodb
  7. Mongodb, aggregate query with $lookup
  8. Get names of all keys in the collection
  9. How to filter array in subdocument with MongoDB [duplicate]
  10. MongoDB: Combine data from multiple collections into one..how?
  11. $lookup multiple levels without $unwind?
  12. Multiple join conditions using the $lookup operator
  13. Conditional $sum in MongoDB
  14. arrayFilters in mongodb
  15. Get a count of total documents with MongoDB when using limit
  16. exclude fields in $lookup aggregation
  17. MongoDB aggregation comparison: group(), $group and MapReduce
  18. Add some kind of row number to a mongodb aggregate command / pipeline
  19. MongoDB group by array inner-elements
  20. Multiple Counts with single query in mongodb
  21. MongoDB sort documents by array elements
  22. How to return array of string with mongodb aggregation
  23. MongoDB – get documents with max attribute per group in a collection
  24. Get n-th element of an array in MongoDB
  25. Geospatial $near within current document field value
  26. How do I rename fields when performing search/projection in MongoDB?
  27. Mongodb aggregation pipeline how to limit a group push
  28. mongodb aggregation framework match by nested documents
  29. Find documents whose array field contains at least n elements of a given array
  30. Return the last “true” value for each group

Leave a Comment