Return document where array element includes all values of input array | MongoDB

Question

I have a collection of exercises:

[
    {
        "name": "Push Ups",
        "muscleGroups": ["Chest", "Shoulders", "Abs", "Biceps"]
    },
    {
        "name": "Sit Ups",
        "muscleGroups": ["Abs"]
    },
    {
        "name": "Pull Ups",
        "muscleGroups": ["Abs", "Biceps", "Back"]
    }
]

and an input array of inputMuscleGroups. I am trying to filter the exercises to where the muscleGroups array of the document has every element of the inputMuscleGroups.

For inputMuscleGroups = ["Abs"], every document would return.

For inputMuscleGroups = ["Abs", "Biceps"], output would be:

[
    {
        "name": "Push Ups",
        "muscleGroups": ["Chest", "Shoulders", "Abs", "Biceps"]
    },
    {
        "name": "Pull Ups",
        "muscleGroups": ["Abs", "Biceps", "Back"]
    }
]

For inputMuscleGroups = ["Abs", "Shoulders", "Chest"], output would be:

[
    {
        "name": "Push Ups",
        "muscleGroups": ["Chest", "Shoulders", "Abs", "Biceps"]
    }
]

I have played around with $in but it appears these only return true if any of the input arrays match any of the document array.

Ideally I would want to do this within a .find() method as opposed to a .aggregate() method.

varman · Accepted Answer · 2021-07-26 03:51:08Z

3

You can simply use $all

db.collection.find({
  muscleGroups: {
    $all: [
      "Abs",
      "Biceps"
    ]
  }
})

Working Mongo playground

answered Jul 26, 2021 at 3:51

varman

8,9326 gold badges25 silver badges56 bronze badges

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

2 Comments

bourkison Over a year ago

Thanks for this! Perfect. How about if it's nested within an object? I can't seem to get it working: Mongo Playground

varman Over a year ago

In that case, you need to go with aggregations

Collectives™ on Stack Overflow

Return document where array element includes all values of input array | MongoDB

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