$filter array in mongodb

Question

I need your help to get data from collection with and condition. Suppose I have a collection having below document and I need search on sub document field named brandId having value of 14 and 38.

{
    "_id" : ObjectId("5b3b206c4a25da19d05f41a2"),
    "models" : [ 
        {
            "brandId" : "14",
            "modelId" : "100",
            "brandSlug" : "honda",
            "modelSlug" : "hrv"
        }, 
        {
            "brandId" : "38",
            "modelId" : "894",
            "brandSlug" : "toyota",
            "modelSlug" : "fortuner"
        }, 
        {
            "brandId" : "38",
            "modelId" : "894",
            "brandSlug" : "toyota",
            "modelSlug" : "fortuner"
        }, 
        {
            "brandId" : "37",
            "modelId" : "773",
            "brandSlug" : "suzuki",
            "modelSlug" : "ertiga"
        } 
    ]
}

I want that sub documents which brandId is 14 and 38.

Desired Output =>

{
    "_id" : ObjectId("5b3b206c4a25da19d05f41a2"),
    "models" : [ 
        {
            "brandId" : "14",
            "modelId" : "100",
            "brandSlug" : "honda",
            "modelSlug" : "hrv"
        }, 
        {
            "brandId" : "38",
            "modelId" : "1240",
            "brandSlug" : "toyota",
            "modelSlug" : "kijang-innova"
        }, 
        {
            "brandId" : "38",
            "modelId" : "894",
            "brandSlug" : "toyota",
            "modelSlug" : "fortuner"
        } 
    ]
}

Try docs.mongodb.com/manual/reference/operator/projection/elemMatch/… and show your attempts — Alex Blex
– Alex Blex, Commented Jul 4, 2018 at 13:37
Apparently you do something wrong in the query. You need to find a way to tell us how exactly you are fetching documents. — Alex Blex
– Alex Blex, Commented Jul 4, 2018 at 13:52
hi @AlexBlex $elemMatch will not work here... because there are two matching condition inside the array... — Ashh
– Ashh, Commented Jul 4, 2018 at 13:55

matthPen · Accepted Answer · 2018-07-04 13:58:15Z

1

Why be so complicated? Unwind,match and group will do the job perfectly.

db.test1.aggregate([
            {
                $unwind: {
                    path : "$models"
                }
            },
            {
                $match: {
                $or:[{"models.brandId":"14"},{"models.brandId":"38"}]
                }
            },
            {
                $group: {
                _id:"$_id",
                models:{$push:"$models"}
                }
            },
        ]
    );

answered Jul 4, 2018 at 13:58

matthPen

4,3731 gold badge18 silver badges18 bronze badges

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

1 Comment

xpt Over a year ago

Online demo: mongoplayground.net/p/DMavG4slscP

Ashh · Accepted Answer · 2018-07-04 13:56:28Z

0

You can try $filter aggregation with $or operator

db.collection.aggregate([
  {
    "$addFields": {
      "models": {
        "$filter": {
          "input": "$models",
          "as": "model",
          "cond": {
            "$or": [
              {
                "$eq": [
                  "$$model.brandId",
                  "14"
                ]
              },
              {
                "$eq": [
                  "$$model.brandId",
                  "38"
                ]
              }
            ]
          }
        }
      }
    }
  }
])

edited Jul 4, 2018 at 13:56

answered Jul 4, 2018 at 13:46

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

1 Comment

xpt Over a year ago

Online demo: mongoplayground.net/p/YjAcxa0cyGS

Collectives™ on Stack Overflow

$filter array in mongodb

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related