Query an object array to check if it contains an array of strings in mongoose

Question

say i have the following inside my db:

knights
  {
    name: 'Knightley',
    skills: [
      { name: 'sword', level: 2 },
      { name: 'shield', level: 1 }
    ]
  },
  {
    name: 'Cowardly',
    skills: [
      { name: 'sword', level: 1 },
      { name: 'shield', level: 5 }
    ]
  }

and i want to return all knights with skills of sword and shield. something like this (pseudo):

Knight.find({ skills.name: which contains ['sword', 'shield'] })

how do i do this kind of query? thanks!

the above pseudo code would return both knights, as it contains both skills with sword and shield — nrion
– nrion, Commented Jun 21, 2018 at 12:45

Ashh · Accepted Answer · 2018-06-21 12:55:09Z

3

You need to use $elemMatch to find inside the array with $in operator

db.collection.find({
  skills: {
    $elemMatch: {
      name: { $in: ["sword", "shield"] }
    }
  }
})

Output

[
  {
    "name": "Knightley",
    "skills": [
      {
        "level": 2,
        "name": "sword"
      },
      {
        "level": 1,
        "name": "shield"
      }
    ]
  },
  {
    "name": "Cowardly",
    "skills": [
      {
        "level": 1,
        "name": "sword"
      },
      {
        "level": 5,
        "name": "shield"
      }
    ]
  }
]

Check it here

edited Jun 21, 2018 at 12:55

answered Jun 21, 2018 at 12:49

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

Query an object array to check if it contains an array of strings in mongoose

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