mongodb using $in for matching array with array inside aggregate

Question

I am trying to perform an aggregate query in MongoDB. My target is to check if any values within an array exists in another array and conditionally introduce a third variable accordingly.

For example, I have an array A => ["a", "b"] and another array B => ["a", "c", "d"] So in this case as "a" exists in both A & B, they should match.

aggregate.push({
                "$addFields": {
                    "canClaim": {
                        $cond: [{
                            $in: [["a", "b"], ["a", "c", "d"]]
                        }, 1, 0]
                    }
                }
            })

Actually, my real document is different. I just posted a similar simple example. If the above example is acheived, I can change accordingly — Ahsan Aasim
– Ahsan Aasim, Commented Apr 10, 2022 at 19:04

Tobias S. · Accepted Answer · 2022-04-10 19:15:41Z

1

Does this help you?

db.collection.aggregate({
  "$addFields": {
    "c": {
      "$setIntersection": [
        "$a",
        "$b"
      ]
    }
  }
},
{
  "$match": {
    "c.1": {
      "$exists": true
    }
  }
})

Mongo Playground

answered Apr 10, 2022 at 19:15

Tobias S.

24.3k7 gold badges37 silver badges64 bronze badges

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

1 Comment

Ahsan Aasim Over a year ago

Great. $setIntersection is the solution for me. Thanks man

Collectives™ on Stack Overflow

mongodb using $in for matching array with array inside aggregate

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related