How to get only specific object of an array of object in Mongodb

Question

{
  "data": {
    "category": "mobile",
    "products": [
      {
        "title": "Redmi Note 10 Pro"
      },
      {
        "title": "Redmi Note 100 Profile"
      }
    ]
  },
  "user": {
    "name": "username"
  }
}

How to get only specific object. Mongodb

I just want object who have the category as "mobile" and title as "Redmi Note 100 Profile"

Result expected:

{
  "data": {
    "category": "mobile",
    "products":{
        "title": "Redmi Note 100 Profile"
      }
  },
  "user": {
    "name": "username"
  }
}

I just don't want this object

{
 "title": "Redmi Note 10 Pro"
}

I'm using this to get

db.collection("products").aggregate([{
              "$unwind": "$data"
            },
              {
                "$match": {
                  "data.category": "mobile",
                  "data.products.title": "Redmi Note 100 Profile",
                }
              }])
            .toArray();

But, it's give me 2 object ?

{
  "data": {
    "category": "mobile",
    "products": [
      {
        "title": "Redmi Note 10 Pro"
      },
      {
        "title": "Redmi Note 100 Profile"
      }
    ]
  },
  "user": {
    "name": "username"
  }
}

How to do ?

Rajdeep D · Accepted Answer · 2021-07-24 10:09:45Z

1

You can use aggregate framework with $unwind to unwind the products array and $match to filter out

Working playground

db.collection.aggregate([
  {
    "$unwind": "$data.products"
  },
  {
    "$match": {
      "data.products.title": "Smartphone 1000 Pro Max Ultra Mega"
    }
  }
])

answered Jul 24, 2021 at 10:09

Rajdeep D

3,9201 gold badge12 silver badges18 bronze badges

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

7 Comments

Monirul Over a year ago

i have update my code as you answer. But it's work for some field, but sometimes it's not work. So i have edited my question with my new problem, please check yourself and solve my problem.

Rajdeep D Over a year ago

You cannot "$unwind": "$data" as data is not an array. You need to do this "$unwind": "$data.products"

Monirul Over a year ago

It's worked but, it's not giving the "user" & "data" object as i mentioned.

Rajdeep D Over a year ago

ok, yoou want like this "products": [? I mean products in array, that's the only difference?

Monirul Over a year ago

Yeah, it's worked.. that's my fault, i was created some function that is why...

|

Collectives™ on Stack Overflow

How to get only specific object of an array of object in Mongodb

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related