How can I change an array of documents to an array of values in MongoDB shell?

Question

So, basically, I have this array of IDs:

> arrayDeptID
[
    {
        "departamento_id" : 0
    },
    {
        "departamento_id" : 2
    },
    {
        "departamento_id" : 5
    },
    {
        "departamento_id" : 6
    }
]

And I want to transform it to an array that contains only the values on the document field departamento_id, something like this:

[0, 2, 5, 6]

Is there any way to do it in MongoDB shell?

Blakes Seven · Accepted Answer · 2015-08-31 14:47:49Z

1

Use JavaScipt .map():

arrayDeptID.map(function(el) { return el.departamento_id })

Then MongoDB shell is a JavaScript REPL. So just about all ECMAScript built-in functions exist. It is built on V8, so whatever is in there is generally in here too.

edited Aug 31, 2015 at 14:47

answered Aug 31, 2015 at 14:42

Blakes Seven

50.5k14 gold badges132 silver badges136 bronze badges

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

Collectives™ on Stack Overflow

How can I change an array of documents to an array of values in MongoDB shell?

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