find data with arrays of ids in mongodb?

Question

I have a array list from another example but this don’t work for me, maybe is because i need use ObjectId()’ but i don’t know how i will can parse this array, too i don’t know if is possibly get only once param (username) and not the full array?

the code is this:

var list =      ["5883d387971bb840b7399130","5883d389971bb840b7399131","5883d38a971bb840b7399132"]
.find({ _id: {$in : list}},{username:1})

can you help and say me how i need create the query ? 🙏🏻 thanks.

Helping hand · Accepted Answer · 2018-08-13 15:01:57Z

1

You query is correct except you need to wrap your ids inside ObjectId using map.

var ObjectId = require('mongodb').ObjectID

var list = ["5883d387971bb840b7399130","5883d389971bb840b7399131","5883d38a971bb840b7399132"]

db.collectionName('newCollection').find({ _id: {$in : list.map( (id) =>  ObjectId(id))}}, {userName:1, _id:0})

edited Aug 13, 2018 at 15:01

answered Aug 13, 2018 at 14:40

Helping hand

2,9602 gold badges21 silver badges33 bronze badges

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

2 Comments

Hernan Humaña Over a year ago

i have this error from node : “ObjectId is not defined” but i import from mongo and work !

clevertension Over a year ago

var ObjectId = require('mongodb').ObjectID;

Collectives™ on Stack Overflow

find data with arrays of ids in mongodb?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related