Mongoose query an array contain one of value in another array

Question

How do I check if an element of an array belongs to another array in Mongoose? For example, I have a document:

const userSchema = new mongoose.Schema({
name: String,
favor:Array
})

user1 = {
name:'John',
favor : ['banana', 'apple', 'eggs'].
}

user 2= {
name:'Ethan',
favor : ['apple', 'eggs'].
}

and I have an Array

const array = ['eggs', 'banana']

I want to get user1. How can I do with mongoose?

Aman · Accepted Answer · 2020-05-08 10:40:53Z

5

You should use $all operator for this scenario

db.collection.find({
  favor: {
    $all: [
      "eggs",
      "banana"
    ]
  }
})

https://docs.mongodb.com/manual/reference/operator/query/all/

answered May 8, 2020 at 10:40

Aman

8581 gold badge10 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Mongoose query an array contain one of value in another array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related