MongoDB - Find document in which array contains any items in query array

Question

I have Schema

person = {
 skill = [{
        type: String
    }]
 name = { type : String}
}

I have a skill array

skill = ['python', 'css']

I want all the people that match at least one skill from the skill array.

$all and $in retrieve only people that match all the skills in the skill array but I want the people that match at least one skill from the skill array.

Yong Shun · Accepted Answer · 2022-02-26 10:23:39Z

3

You can use $setIntersection.

$setIntersection - Intersect the input skill array with skill field and returns a array with common (intersect) value(s).
$ne - Filter the document with result from (1) is not empty array.

db.collection.find({
  $expr: {
    $ne: [
      {
        $setIntersection: [
          [
            "python",
            "css"
          ],
          "$skill"
        ]
      },
      []
    ]
  }
})

Sample Mongo Playground

edited Feb 26, 2022 at 10:23

answered Feb 26, 2022 at 10:15

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

Comments

rickhg12hs · Accepted Answer · 2022-02-26 13:34:31Z

1

You can use "$in" for your purpose. Perhaps you had some other issue when you tried it before.

db.collection.find({
  "skill": {
    "$in": [ "python", "css" ]
  }
})

Try it on mongoplayground.net.

Just for fun, here's another mongoplayground.net example that uses a mgodatagen configuration to generate the collection. The query is the same.

edited Feb 26, 2022 at 13:34

answered Feb 26, 2022 at 11:27

rickhg12hs

12k6 gold badges31 silver badges50 bronze badges

Collectives™ on Stack Overflow

MongoDB - Find document in which array contains any items in query array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related