Mongoose - How to push object in nested array of objects

Question

I have this data structure in my MongoDB database:

"menu": [
        {
            "dishCategory":"61e6089f209b802518e2b4a4",
            "dishMeals": [
                {
                    "dishMealName": "Burger King",
                    "dishMealIngredients": "Burger lepinja, bbq sos, berlin sos, zelena"
                    "dishMealPrice": 5
                }
            ]
        }
    ]

How do I push a new object inside dishMeals in exact dishCategory ( I am providing dishCategoryId, newDish object and _id of restaurant through req.body) I've tried this but nothing is changing:

await Restaurants.updateOne(
        {
            '_id' : _id,
            'menu.dishCategory' : dishCategoryId
        },
        {
            $push : {
                'menu.$.dishMeals' : newDish
            }
        }
    );

Yong Shun · Accepted Answer · 2022-01-20 01:20:34Z

4

Use arrayFilters to filter the nested document(s) in the array field, then $push if the filter criteria in the arrayFilters met.

db.collection.update({
  "_id": _id,
  "menu.dishCategory": dishCategoryId
},
{
  $push: {
    "menu.$[menu].dishMeals": newDish
  }
},
{
  arrayFilters: [
    {
      "menu.dishCategory": dishCategoryId
    }
  ]
})

Sample Mongo Playground

edited Jan 20, 2022 at 1:20

answered Jan 20, 2022 at 0:27

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

2 Comments

mne_web_dev Over a year ago

Sorry I've made a mistake I have "dishCategory":"61e6089f209b802518e2b4a4" not the object one like earlier. When I try like this "menu.dishCategory": dishCategoryId" Its not working

Yong Shun Over a year ago

Demo looks fine for me. Maybe another thing to look up is make sure you pass the value with exact type, for example, if dishCategory is ObjectId, then the value of dishCategoryId must also be ObjectId type as well.

NeNaD · Accepted Answer · 2022-01-20 01:04:08Z

2

You can do it with arrayFilters config in update query:

db.collection.update({
  "restaurant_id": 1
},
{
  "$push": {
    "menu.$[element].dishMeals": {
      "dishMealName": "Best Burger",
      "dishMealIngredients": "Best burger in town",
      "dishMealPrice": 10
    }
  }
},
{
  "arrayFilters": [
    {
      "element.dishCategory._id": "61e6089f209b802518e2b4a4"
    }
  ]
})

Working example

answered Jan 20, 2022 at 1:04

NeNaD

20.8k11 gold badges64 silver badges118 bronze badges

1 Comment

mne_web_dev Over a year ago

Thank you your method is working fine it was my mistake for not checking if dishCategory is indeed an ObjectId not a string

kumol · Accepted Answer · 2022-07-13 06:04:47Z

2

You may read the question and the solution they provided here, Hope this one will be helpful to you.

db.collection.update({
    "_id": 1,
    "menu.dishCategory": "61e6089f209b802518e2b4a4"
},
{
    $push: {
        "menu.$.dishMeals": newMeal
    }
})

Sample Example

edited Jul 13, 2022 at 6:04

answered Jan 20, 2022 at 9:41

kumol

1842 silver badges13 bronze badges

1 Comment

mne_web_dev Over a year ago

Thank you your method is working fine it was my mistake for not checking if dishCategory is indeed an ObjectId not a string

Collectives™ on Stack Overflow

Mongoose - How to push object in nested array of objects

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related