Retrieve array of field's values from MongoDB collection

Question

I have an abccollection collection whose documents look like:

{
    id:123
    focusPoint:89652.33
}

I want to retrieve all focusPoint values so that output looks like:

[89652.33, 89999.223, 99666.45, ...]

Danziger · Accepted Answer · 2017-05-04 08:58:32Z

1

If you want to get a list without duplicates:

db.abccollection.distinct("focusPoint")

Otherwise, keeping duplicates:

db.abccollection.find({}, { _id: 0, focusPoint: 1 }).map((doc) => doc.focusPoint)

With that you will retrieve all the documents in the abccollection collection and project just the focusPoint field. The raw output of that query (before the map) will be an array of documents with a single field:

[{ focusPoint: 89652.33 }, { focusPoint: 89999.223 }, ...]

If you don't want MongoDB to do the .map in MongoDB, you can also do it in your application.

edited May 4, 2017 at 8:58

answered May 4, 2017 at 5:51

Danziger

21.4k6 gold badges59 silver badges90 bronze badges

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

Collectives™ on Stack Overflow

Retrieve array of field's values from MongoDB collection

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