$in Query on Array Field Mongo db

Question

I have a doc like this

{
  "_id" : "oidfi",
   "users": [
        {
            "_id": "q",
            "tags": ["a", "b", "c"],
            "age": 20

        },
        {
            "_id": "q",
            "tags": ["x", "y", "z"],
            "age": 30

        }
    ],
    "type": "repo"
}

I want to filter the users array with several fields ( I'm able to do that with the below query )

    {
        "$match": {
            "$and": [
                {
                    "_id": "a506f8af6f510f616bea14715276d474d2b363f0aef10443cc0f11559b139147"
                }
            ]
        }
    },
    {
        "$project": {
            "users": {
                "$filter": {
                    "input": "$users",
                    "as": "users",
                    "cond": {
                        "$and": [
                            {
                                "$gte": [
                                    "$$user.age",
                                    15
                                ]
                            }
                        ]
                    }
                }
            }
        }
    }
]

is there a way for me to add condition where I give a list of tags items and get the users who are matching at least one item from their tags array

$$user.tags.containsAny(["a", "x"])

Thanks

That is exactly what the $in operator is for.

Joe
– Joe

2021-10-12 08:32:02 +00:00
Commented Oct 12, 2021 at 8:32 — Joe
– Joe, Commented Oct 12, 2021 at 8:32

ray · Accepted Answer · 2021-10-12 08:36:45Z

1

You can do the followings in an aggregation pipeline:

$setIntersection to find out the intersection of the users.tags array and your input array i.e. ["a", "x"] in your example
$size to find the size of array in step 1
$match by the size of step 2 larger than 0

"anyTagsMatched": {
        $gt: [
          {
            $size: {
              "$setIntersection": [
                "$users.tags",
                [
                  "a",
                  "x"
                ]
              ]
            }
          },
          0
        ]
      }

Here is the Mongo playground for your reference.

answered Oct 12, 2021 at 8:36

ray

15.6k12 gold badges97 silver badges104 bronze badges

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

Comments

varman · Accepted Answer · 2021-10-12 08:53:58Z

0

You may have like following

db.collection.aggregate([
  {
    "$project": {
      "users": {
        "$filter": {
          "input": "$users",
          "cond": {
            "$and": [
              { "$gte": [ "$$this.age", 15 ] },
              {
                $gt: [
                  {
                    $size: {
                      "$setIntersection": [
                        "$$this.tags",
                        [ "a", "x" ]
                      ]
                    }
                  },
                  0
                ]
              }
            ]
          }
        }
      }
    }
  }
])

Working Mongo playground

answered Oct 12, 2021 at 8:53

varman

8,9226 gold badges25 silver badges56 bronze badges

Collectives™ on Stack Overflow

$in Query on Array Field Mongo db

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