How to update the array inside embedded fields using mongodb [duplicate]

Question

I tried to update the array inside the embedded document field. but it is not working how to achieve this scenario.

data_Collection

{
    "id":101,
    "review_ratings":[
       {
           id:102,
           name:"hari"
       },{
           id:103,
           name:"mani"
       }
    ]
}

How to update id 103 name field

Check here. docs.mongodb.com/manual/reference/operator/update/positional — Ankur
– Ankur, Commented Aug 8, 2019 at 5:11

Mohit Mutha · Accepted Answer · 2019-08-08 05:22:16Z

0

You should use positional operators

db.test.update({"id":101, "review_ratings.id": 103},
               {$set: {"review_ratings.$.name":"mohit"}});

answered Aug 8, 2019 at 5:22

Mohit Mutha

3,00117 silver badges28 bronze badges

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

Comments

vimmi · Accepted Answer · 2019-08-08 05:33:58Z

You can use aggregate function for searching and can use find and update method like:-

test.aggregate(
                [
                  { $match: {} },
                  {$project: {
                    review_ratings: {
                      $filter: {
                        input: '$review_ratings',
                        as: 'review_ratings',
                        cond: { $wq: [ '$$review_ratings.id', '103' ] }
                      }
                    }
                   }
                  }

                ],
                (err, res) => {

                });

Collectives™ on Stack Overflow

How to update the array inside embedded fields using mongodb [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related