Retrieve field value from array of sub document

Question

I have some documents like this:

{
  "hash": "14a076f9f6cecfc58339330eeb492e267f63062f6d5f669c7cdbfecf9eb4de32",
  "started_services": [],
  "deleted_files": [],
  "software": { 
      "adobe" : {
          "licenses" : [
                  { "key": "2384723",
                    "date": "26-10-2012"
                  },
                  { "key": "23888823",
                    "date": "09-11-2012"
                  }
          ]
      }
   }
}

How do I retrieve just the hash value and the list of "key" values?

I did the following, but, as you see, the result has the entire path which I do not want.

> db.repository.find({"$and": [{"datetime_int": {"$gte": 1451952000}},{"software.adobe.licenses.key" : { $exists : true}}]}, {hash:1, "software.adobe.licenses.key":1, _id:0}).limit(10)

{ "hash" : "a1532e0609aaf6acfa9e505e93af0bee0856a9a67398aeaa72aa6eb2fffd134e", "software" : { "adobe" : { "licenses" : [ { "key" : "2008350" }, { "key" : "2018350" }, { "key" : "2028350" }, { "key" : "2038350" }, { "key" : "2048350" }, { "key" : "2058350" }, { "key" : "2068350" }, { "key" : "2078350" }...]}}}

The result I want should look like this:

{"hash": "a1532e0609aaf6acfa9e505e93af0bee0856a9a67398aeaa72aa6eb2fffd134e",
 "key": ["2008350", "2018350", "2028350", "2038350", "2048350", "2058350", "2068350", "2078350"]
}

How do I do that?

no. All are static fields. The values have been changed to make things look small and simple. — user1717931
– user1717931, Commented Nov 30, 2016 at 19:41

Sede · Accepted Answer · 2016-11-30 19:54:09Z

1

You can do this with the aggregation framework.

db.repository.aggregate([ 
    { "$match": { 
        "datetime_int": { "$gte": 1451952000 }, 
        "software.adobe.licenses.key" : { "$exists" : true } 
    }}, 
    { "$project": { 
        "hash": 1, 
        "key": { 
            "$map": { 
                "input": "$software.adobe.licenses", 
                "as": "soft", 
                "in": "$$soft.key"
            }
        }
    }}
])

Starting From MongoDB 3.2 you can directly project the sub-document array field.

{ "$project": { "hash": 1, "key": "$software.adobe.licenses.key"}}

edited Nov 30, 2016 at 19:54

answered Nov 30, 2016 at 19:45

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

1 Comment

user1717931 Over a year ago

since I am using version = 3.2.x, I used your other suggestion and it works nicely. Thanks!

satish chennupati · Accepted Answer · 2016-11-30 19:54:17Z

1

db.key.aggregate((
{ "$match": { 
        "datetime_int": { "$gte": 1451952000 }
        }},
{"$unwind":"$software.adobe.licenses"},
{"$project":{"key":"$software.adobe.licenses.key", "hash":1, "_id":0}}
))

outputs the following :

{ "hash" : "14a076f9f6cecfc58339330eeb492e267f63062f6d5f669c7cdbfecf9eb4de32", "key" : [ "2384723", "23888823" ] }

answered Nov 30, 2016 at 19:54

satish chennupati

2,6601 gold badge21 silver badges27 bronze badges

Collectives™ on Stack Overflow

Retrieve field value from array of sub document

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related