Mongoose/MongoDB how to query nested documents as a single array

Question

one item in the collection looks as shown below.

{
"_id" : ObjectId("4f7ee46e08403d063ab0b4f9"),
"name" : "MongoDB",
"notes" : [
            {
              "title" : "Hello MongoDB",
              "content" : "Hello MongoDB"
            },
            {
              "title" : "ReplicaSet MongoDB",
              "content" : "ReplicaSet MongoDB"
            }
         ]
}

lets say i want to retrieve all the notes of all documents as a single array, how should i wite my query? give mongoose and or mongoDB example

4J41 · Accepted Answer · 2016-10-15 16:18:16Z

1

You can use aggregation to get the desires result. Use a $unwind stage to flatten the array values into documents. Then, follow by a $group stage to $push all the notes into a single array. Optionally, use a $project stage to output the expected fields.

db.collection.aggregate([
    {"$unwind":"$notes"}, 
    {"$group":{"_id": null, "notes":{"$push":"$notes"}}}, 
    {"$project":{"_id":0, "notes":1}}
]);

answered Oct 15, 2016 at 16:18

4J41

5,1051 gold badge31 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mongoose/MongoDB how to query nested documents as a single array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related