How do I perform an id array query in Mongoose?

Question

Let's say I have a model called User. I have an array with object Ids.

I want to get all User records that "intersect" with the array of Ids that I have.

User.find({ records with IDS IN [3225, 623423, 6645345] }, function....

score 85 · Answer 1 · edited Jul 23 '14 at 15:08

85

Here is a mongoosey way to use the $in operator.

User.find()
  .where('fb.id')
  .in([3225, 623423, 6645345])
  .exec(function (err, records) {
    //make magic happen
  });

I find the dot notation quite handy for querying into sub documents.

edited Jul 23 '14 at 15:08

answered Nov 13 '12 at 02:56

kberg

I guess this should be the expected answer because it provides the answer with more clear syntax – Piyush Beli Apr 19 '18 at 09:20
Didn't know we could chain commands in mongoose ! Thanks a lot – Aditya Mar 23 '19 at 12:39

score 46 · Accepted Answer · edited Jul 10 '18 at 14:33

46

You need to use the $in operator >

For example:

Users.find( { "fb" : { id: { $in : arrayOfIds } } }, callback );

edited Jul 10 '18 at 14:33

Tomke

answered Apr 28 '11 at 17:02

neebz

4

But what's the syntax in mongoose? – TIMEX Apr 28 '11 at 19:51
2

it's the same syntax. `.find()` is a mongodb function. – neebz Apr 28 '11 at 20:01
Thanksk. What if my "id" is actually nested. The object is: { fb: { name:blah, id:blah } } . How would I query it by that id? Can you write it out for me? tanks. – TIMEX Apr 28 '11 at 20:09
6

`Users.find( { "fb" : { id: { $in : arrayOfIds } } } );` I haven't tested it but it should work – neebz Apr 28 '11 at 20:15
this is ridiculous, what if you're progressively building a query based on HTTP parameters and you have to check to see if they exist before you build the query?? like this `var query = Users.find(); if (x) { query.in(x) //?! }` ? will that work? – Jul 23 '14 at 15:07
2

What's up with the "fb"? This didn't work for me, but this did: `Users.find({_id: {$in:arrayOfIds} })` – ki9 Mar 15 '18 at 01:09

score 8 · Answer 3 · answered Jan 11 '14 at 09:51

8

User.where({ records: { $in: [3225, 623423, 6645345] } }, function ...

answered Jan 11 '14 at 09:51

Sagiv Ofek

Alex Montoya · Answer 4 · 2018-05-20T01:14:38.930

0

For me, work this way

IDs=["5b00c4b56c7fb80918293dd9","5b00c4b56c7fb80918293dd7",...]
const users= await User.find({records:IDs})

edited May 20 '18 at 01:14

answered May 20 '18 at 01:08

Alex Montoya

snnsnn · Answer 5 · 2019-08-25T12:44:44.603

0

Ids is the array of object ids:

const ids =  [
    '4ed3ede8844f0f351100000c',
    '4ed3f117a844e0471100000d', 
    '4ed3f18132f50c491100000e',
];

With callback:

User.find().where('_id').in(ids).exec(callback);

With async function:

records = await User.find().where('_id').in(ids).exec();

edited Aug 25 '19 at 12:44

answered Aug 24 '19 at 10:22

snnsnn

5 Answers5