Get specific fields with MongoDb query

Question

I have a schema like this

{
    _id:ObjectId(),
    ...,
    translations:[{
        value: "English",
        code:"en"
    },{
        value: "German",
        code:"de"
    }]
}

All object have a translation with code 'en' and 'de', How can I get all objects(value,id) with code 'en'? A The result should look like similar to this:

[{
    _id:ObjectId(),
    value:"English"
},....
...]

Possible duplicate of Retrieve only the queried element in an object array in MongoDB collection — Sede
– Sede, Commented Jan 8, 2016 at 8:15

Sede · Accepted Answer · 2015-03-21 20:20:56Z

2

You can do this using aggregation pipeline

$unwind the translations array
Use $match to select the documents with code 'en'
Use $project to include or reset fields in your result.

    db.collection.aggregate(
        [
            { "$unwind": "$translations"}, 
            { "$match": { "translations.code": "en" }}, 
            { "$project": { "value": "$translations.value", "_id": 1 }}
       ]
    )

edited Mar 21, 2015 at 20:20

answered Mar 21, 2015 at 19:14

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

Collectives™ on Stack Overflow

Get specific fields with MongoDb query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related