How do I create a query from an array with mongoose?

Question

So I have this array with 3 IDs: ["56ba576f66b9add00e4d3082","56b9252266b9add00e4d3080","56b908f166b9add00e4d307f"]

I want to build a query that says something like that:

userModel.find({ $or: 
  [ 
    {_id:"56ba576f66b9add00e4d3082"}, 
    {_id:"56ba576f66b9add00e4d3082"}, 
    {_id:"56ba576f66b9add00e4d3082"} 
  ]}, 
    {email:true});

Is there some sort of a method to use in order to produce such query with the array? Should I be using mapReduce or the $where method or anything else? (I never used those before so I'm not sure if this is the case or not)

Perhaps I'm asking the wrong question? Any recommendations are very much welcome.

Blakes Seven · Accepted Answer · 2016-02-10 00:58:28Z

2

If you just have one element then just use $in:

var array = [
    "56ba576f66b9add00e4d3082",
    "56b9252266b9add00e4d3080",
    "56b908f166b9add00e4d307f"
];

userModel.find({ "_id": { "$in": array } }, { "email": true });

An $in condition is basically an $or applied to the same field.

answered Feb 10, 2016 at 0:58

Blakes Seven

50.5k14 gold badges132 silver badges136 bronze badges

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

Comments

4lejandrito · Accepted Answer · 2016-02-10 00:47:21Z

0

Try using the map function:

array = ["56ba576f66b9add00e4d3082","56b9252266b9add00e4d3080","56b908f166b9add00e4d307f"]

userModel.find({ $or: array.map(function(id) {
    return {_id: id};
})}, {email:true});

answered Feb 10, 2016 at 0:47

4lejandrito

1821 silver badge6 bronze badges

Collectives™ on Stack Overflow

How do I create a query from an array with mongoose?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related