Get mongoose object of an array within another object of array

Question

I have this document in my mongodb collection:

        "_id": "62be0271d373b2f2fc1826a2",
        "condition": "new",
        "variants": [
            {
                "color_name": "Green",
                "items": [
                    {
                        "size": "S",
                        "price": 100,
                        "quantity": 1,
                        "_id": "62be0271d373b2f2fc1826a4"
                    },
                    {
                        "size": "M",
                        "price": 100,
                        "quantity": 2,
                        "_id": "62be0271d373b2f2fc1826a5"
                    }
                ],
                "_id": "62be0271d373b2f2fc1826a3"
            },
            {
                "color_name": "Blue",
                "items": [
                    {
                        "size": "S",
                        "price": 100,
                        "quantity": 1,
                        "_id": "62be0271d373b2f2fc1826a7"
                    },
                    {
                        "size": "S",
                        "price": 100,
                        "quantity": 1,
                        "_id": "62be0271d373b2f2fc1826a8"
                    }
                ],
                "_id": "62be0271d373b2f2fc1826a6"
            }
        ],
        "featured": true

I want to get only the first variant with it's _id = "62be0271d373b2f2fc1826a3" and also with it's second items that has this "_id": "62be0271d373b2f2fc1826a5", don't show other fields.

NOTE: there are more objects like this in the collection so loop through and match all and retrieve only fields matched.

nimrod serok · Accepted Answer · 2022-07-03 10:48:37Z

1

One option is using $filter:

db.collection.aggregate([
  {
    $project: {
      variants: {
        $first: {
          $filter: {
            input: "$variants",
            cond: {
              $eq: [
                "$$this._id",
                "62be0271d373b2f2fc1826a3"
              ]
            }
          }
        }
      },
      _id: 0
    }
  },
  {
    $set: {
      "variants.items": {
        $filter: {
          input: "$variants.items",
          cond: {
            $eq: [
              "$$this._id",
              "62be0271d373b2f2fc1826a5"
            ]
          }
        }
      },
      _id: "$$REMOVE"
    }
  }
])

See how it works on the playground example

answered Jul 3, 2022 at 10:48

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

2 Comments

olips Over a year ago

This works fine, but, what about if I want to edit the quantity returned and save it back to the same document without altering any other data in the collection document.

nimrod serok Over a year ago

Then this will be another question, with a new solution with a completely different approach, which is this

Collectives™ on Stack Overflow

Get mongoose object of an array within another object of array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related