Get specific field in array mongodb and return as array

Question

I have the following document:

{
    array: [
        {
            type: 'error',
            data: 1
        },
        {
            type: 'error',
            data: 2
        }
    ]
}

Is there anyway for my to get only the data field in each array element and return it as an array? Like the following:

[1, 2] // <--- array containing only the data fields

The mongodb projection documentation doesn't seem to cover this?

Sede · Accepted Answer · 2015-09-30 20:15:31Z

7

You can use aggregation and the $map operator.

db.collection.aggregate([
    { 
        "$project": { "_id": 0, "data": { 
            "$map": { "input": "$array", "as": "ar", "in": "$$ar.data" } } }
    }
])

Which yields:

{ "data" : [ 1, 2 ] }

edited Sep 30, 2015 at 20:15

answered Sep 30, 2015 at 18:37

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 field in array mongodb and return as 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