How to get multiple document using array of MongoDb id?

Question

I have an array of ids and I want to get all document of them at once. For that I am writing but it return 0 records.

How can I search using multiple Ids ?

db.getCollection('feed').find({"_id" : { "$in" : [  
"55880c251df42d0466919268","55bf528e69b70ae79be35006" ]}})

I am able to get records by passing single id like

db.getCollection('feed').find({"_id":ObjectId("55880c251df42d0466919268")})

You probably need to wrap the ids in ObjectId() like you do in the second example. — trvrfrd
– trvrfrd, Commented Aug 28, 2015 at 6:01
db.getCollection('feed').find({"_id" : { "$in" : [ ObjectId("55880c251df42d0466919268"),ObjectId("55bf528e69b70ae79be35006") ]}}) maybe works. — Kane Blueriver
– Kane Blueriver, Commented Aug 28, 2015 at 6:02
Pankaj, maybe you did not notice but on top of his comment, @kxxoling posted an answer. It is always good to mark the answer as "accepted" because it helps people having the same problem. They will see the green tick and be more confident it is a working solution. Also it gives a few points to kxxoling ;-) — Mig
– Mig, Commented Jul 20, 2020 at 8:39

Kane Blueriver · Accepted Answer · 2015-08-28 06:28:50Z

88

MongoDB is type sensitive, which means 1 is different with '1', so are "55880c251df42d0466919268" and ObjectId("55880c251df42d0466919268"). The later one is in ObjectID type but not str, and also is the default _id type of MongoDB document.

You can find more information about ObjectID here.

Just try:

db.getCollection('feed').find({"_id" : {"$in" : [ObjectId("55880c251df42d0466919268"), ObjectId("55bf528e69b70ae79be35006")]}});

answered Aug 28, 2015 at 6:28

Kane Blueriver

4,2984 gold badges35 silver badges50 bronze badges

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

Comments

Vimalraj Selvam · Accepted Answer · 2015-08-28 06:22:08Z

39

I believe you are missing the ObjectId. Try this:

db.feed.find({ 
    _id: {
        $in: [ObjectId("55880c251df42d0466919268"), ObjectId("55bf528e69b70ae79be35006")]
    }
});

answered Aug 28, 2015 at 6:22

Vimalraj Selvam

2,2853 gold badges29 silver badges53 bronze badges

1 Comment

Pascal de Kloe Over a year ago

… or without ObjectID: you can still use $oid like: {"_id": {"$in": [{"$oid": "55880c251df42d0466919268"}, {"$oid": "55bf528e69b70ae79be35006"}]}}

VIKAS KOHLI · Accepted Answer · 2018-05-01 06:56:58Z

12

For finding records of multiple documents you have to use "$in" operator Although your query is fine, you just need to add ObjectId while finding data for Ids

db.feed.find({
  "_id" : {
    "$in" : 
      [ObjectId("55880c251df42d0466919268"), 
       ObjectId("55bf528e69b70ae79be35006")
      ]
   }
});

answered May 1, 2018 at 6:56

VIKAS KOHLI

8,4904 gold badges52 silver badges67 bronze badges

2 Comments

Vince Bowdren Over a year ago

Hi Vikas - your answer appears to be much the same as the two existing answers from kxxoling and Vimalraj Selvam, which both already emphasise that the ObjectId part is essential. Is there something extra that you want to contribute?

Borna Over a year ago

@VinceBowdren He provided more readable solution :)

RaphaelDDL · Accepted Answer · 2019-10-03 14:22:41Z

1

Just I have use it, and is working fine:

module.exports.obtenerIncidencias386RangoDias = function (empresas, callback) {
    let arraySuc_Ids = empresas.map((empresa)=>empresa.sucursal_id)
            incidenciasModel.find({'sucursal_id':{$in:arraySuc_Ids}
            }).sort({created_at: 'desc'}).then(
                (resp)=>    {
                    callback(resp)}
            )
};

where:

empresas = ["5ccc642f9e789820146e9cb0","5ccc642f9e789820146e9bb9"]

edited Oct 3, 2019 at 14:22

RaphaelDDL

4,4902 gold badges34 silver badges57 bronze badges

answered May 24, 2019 at 20:29

ifredy3

293 bronze badges

Comments

klimqx · Accepted Answer · 2022-03-16 14:41:49Z

1

The Id's need to be in this format : ObjectId("id").
you can use this to transform your string ID's :

const ObjectId = require('mongodb').ObjectId;

answered Mar 16, 2022 at 14:41

klimqx

1471 silver badge2 bronze badges

Comments

shashigura · Accepted Answer · 2021-11-11 14:44:21Z

0

store array list in var and pass that array list to find function var list=db.collection_name.find() db.collection_name.find({_id:{$in:list}})

answered Nov 11, 2021 at 14:44

shashigura

1531 gold badge2 silver badges9 bronze badges

Comments

Majid Hajibaba · Accepted Answer · 2021-06-03 06:23:06Z

-4

db.getCollection({your_collection_name}).find({
    "_id" : {
    "$in" : 
      [({value1}), 
       ({value2})
      ]
   } 
    })

edited Jun 3, 2021 at 6:23

Majid Hajibaba

3,2806 gold badges29 silver badges59 bronze badges

answered Jun 2, 2021 at 7:22

ishantraj

151 silver badge5 bronze badges

Collectives™ on Stack Overflow

How to get multiple document using array of MongoDb id?

7 Answers 7

Comments

1 Comment

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

1 Comment

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related