What’s the $unwind operator in MongoDB?

by

First off, welcome to MongoDB!

The thing to remember is that MongoDB employs an “NoSQL” approach to data storage, so perish the thoughts of selects, joins, etc. from your mind. The way that it stores your data is in the form of documents and collections, which allows for a dynamic means of adding and obtaining the data from your storage locations.

That being said, in order to understand the concept behind the $unwind parameter, you first must understand what the use case that you are trying to quote is saying. The example document from mongodb.org is as follows:

{
 title : "this is my title" ,
 author : "bob" ,
 posted : new Date () ,
 pageViews : 5 ,
 tags : [ "fun" , "good" , "fun" ] ,
 comments : [
             { author :"joe" , text : "this is cool" } ,
             { author :"sam" , text : "this is bad" }
 ],
 other : { foo : 5 }
}

Notice how tags is actually an array of 3 items, in this case being “fun”, “good” and “fun”.

What $unwind does is allow you to peel off a document for each element and returns that resulting document.
To think of this in a classical approach, it would be the equivilent of “for each item in the tags array, return a document with only that item”.

Thus, the result of running the following:

db.article.aggregate(
    { $project : {
        author : 1 ,
        title : 1 ,
        tags : 1
    }},
    { $unwind : "$tags" }
);

would return the following documents:

{
     "result" : [
             {
                     "_id" : ObjectId("4e6e4ef557b77501a49233f6"),
                     "title" : "this is my title",
                     "author" : "bob",
                     "tags" : "fun"
             },
             {
                     "_id" : ObjectId("4e6e4ef557b77501a49233f6"),
                     "title" : "this is my title",
                     "author" : "bob",
                     "tags" : "good"
             },
             {
                     "_id" : ObjectId("4e6e4ef557b77501a49233f6"),
                     "title" : "this is my title",
                     "author" : "bob",
                     "tags" : "fun"
             }
     ],
     "OK" : 1
}

Notice that the only thing changing in the result array is what is being returned in the tags value. If you need an additional reference on how this works, I’ve included a link here. Hopefully this helps, and good luck with your foray into one of the best NoSQL systems that I have come across thus far.

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. Does MongoDB’s $in clause guarantee order
  4. MongoDB: Combine data from multiple collections into one..how?
  5. MongoDB SELECT COUNT GROUP BY
  6. Mongodb sort inner array
  7. Multiple join conditions using the $lookup operator
  8. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  9. Return only matched sub-document elements within a nested array
  10. Converting string to date in mongodb
  11. Average Aggregation Queries in Meteor
  12. MongoDB Full and Partial Text Search
  13. Mongodb Join on _id field from String to ObjectId
  14. Find duplicate records in MongoDB
  15. $unwind empty array
  16. How to sum every fields in a sub document of MongoDB?
  17. Mongo sort on a calculated condition
  18. Find all duplicate documents in a MongoDB collection by a key field
  19. MongoDB: Calculate dwell time between every status value change
  20. MongoDB: how to parse date in 3.6 mongoDb version?
  21. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  22. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  23. How to flatten a subdocument into root level in MongoDB?
  24. convert iso date to timestamp in mongo query
  25. Remove Duplicates from MongoDB
  26. Using $slice operator to get last element of array
  27. How to access overall document count during arithmetic aggregation expression
  28. How to deal with the timezone issue when storing dates in utc using mongod?
  29. Sum in nested document MongoDB
  30. Mongodb concat int and string

Leave a Comment