Creating query with Mongoose library (find objects in array)

Question

This is my Mongoose model of conversation object:

const conversationSchema = mongoose.Schema({
  participants: [
    {
      id_profile: { type: mongoose.Schema.Types.ObjectId, ref: 'User', required: true }
    }
  ]
});

How I can find a conversation object that contains two objects in the array "participants" that have ID = 123456 and ID = 654321? The order of objects in array "participants" can be different.

conversation = {
  participants: [
    { id_profile: '123456' },
    { id_profile: '654321' }
  ]
}

conversation = {
  participants: [
    { id_profile: '654321' },
    { id_profile: '123456' }
  ]
}

How to create a query using Mongoose?

JohnnyHK · Accepted Answer · 2019-12-19 16:12:48Z

2

You can use $all for this query, which finds docs where a field matches all of a set of values:

Conversation.find({'participants.id_profile': {$all: ['123456', '654321']}})

answered Dec 19, 2019 at 16:12

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

Collectives™ on Stack Overflow

Creating query with Mongoose library (find objects in 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