Mongoose: How to find by multiple fields from an array of objects

Question

Say I have a Model that looks like this:

{ name: String, category: String }

And I got an Array with objects like this:

var array = [{
    { name: "a", category: "A" }
  , { name: "b, category: "A" }
  , { name: "b", category: "B" }
}]

Now I want to find all objects that matches the value pairs in the array. If it was an array of Strings only, the code would be something like Model.find({ name: {$in: array } }), but I need something like

Model.find({ name,category: {$in: array} })

Is this possible?

JohnnyHK · Accepted Answer · 2015-09-24 00:50:37Z

5

You could directly use that array in an $or query to look for docs that match any of those pairs:

var array = [
    { name: "a", category: "A" }
  , { name: "b", category: "A" }
  , { name: "b", category: "B" }
];

Model.find({$or: array}, function(err, docs) { ... });

answered Sep 24, 2015 at 0:50

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

2 Comments

Matt Over a year ago

or using mongoose's .or helper - Model.find().or(array)

Gob Over a year ago

How did I not think of that? Thank you so much!

Collectives™ on Stack Overflow

Mongoose: How to find by multiple fields from an array of objects

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