Get nested fields with MongoDB shell

Question

I've "users" collection with a "watchlists" field, which have many inner fields too, one of that is "arrangeable_values" (the second field within "watchlists"). I need to find for each user in "users" collection, each "arrangeable_values" within "watchlists". How can I do that with mongodb shell ? Here is an example of data model : ``` > db.users.findOne({'nickname': 'superj'}) { "_id" : ObjectId("4f6c42f6018a590001000001"), "nickname" : "superj", "provider" : "github", "user_hash" : null, "watchlists" : [ { "_id" : ObjectId("4f6c42f7018a590001000002"), "arrangeable_values" : { "description" : "My introduction presentation to node.js along with sample code at various stages of building a simple RESTful web service with journey, cradle, winston, optimist, and http-console.", "tag" : "", "html_url" : "https://github.com/indexzero/nodejs-intro" }, "avatar_url" : "https://secure.gravatar.com/avatar/d43e8ea63b61e7669ded5b9d3c2e980f?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fg…

Accepted Answer

For the document above, the following find() query would extract both the "nickname" of the document, and its associated "arrangeable_values" (where the document is in the users collection):

```
db.users.find({}, { "nickname" : 1,  "watchlists.arrangeable_values" : 1 })
```

The result you get for your single document example would be:

```
{ "_id" : ObjectId("4f6c42f6018a590001000001"), "nickname" : "superj", 
"watchlists" : [    
     {  "arrangeable_values" : {    "description" : "My introduction presentation to node.js along with sample code at various stages of building a simple RESTful web service with journey, cradle, winston, optimist, and http-console.",     "tag" : "",     "html_url" : "https://github.com/indexzero/nodejs-intro" } },   
     {  "arrangeable_values" : {    "description" : "A Backbone alternative idea",  "tag" : "",     "html_url" : "https://github.com/maccman/spine.todos" } } 
] }
```

Get nested fields with MongoDB shell

Solution

Problem