Match all elements in document array with input array

Question

The db has documents as follows.

{
    id: 1,
    items: ["a", "b", "c"]
},
{
    id: 2,
    items: ["a", "b"]
},
{
    id: 3,
    items: ["a", "b", "c", "d"]
}

I need to get records that have all items should include in the input query.

If input ["a", "b", "c"] #1 and #2, should come. Because all items includes in the input. But not #3, because input has not "d".

If i use {query: {$in: ["a", "b", "c"]}} = all records is coming.

If i use {query: {$all: ["a", "b", "c"]}} = #1, #2 records is coming.

What is the query for this?

The two queries are exactly the same, I doubt they give different results. — Wernfried Domscheit
– Wernfried Domscheit, Commented Apr 2, 2020 at 6:01

Wernfried Domscheit · Accepted Answer · 2020-04-02 06:56:14Z

2

You can use this one:

db.collection.aggregate([
   {
      $match: {
         $expr: {
            $eq: [
               "$items",
               { $setIntersection: ["$items", ["a", "b", "c"]] }
            ]
         }
      }
   }
])

answered Apr 2, 2020 at 6:56

Wernfried Domscheit

60.5k10 gold badges93 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

Match all elements in document array with input array

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