Mongodb remove field from Array objects all documents?

Question

I have a collection that has documents looks something like this:

{
  _id : 21353456,
  product : "xy",
  text : "asdf",
  reviews : [
    {
       username : "User1",
       userID: 12
       text : "hi",
     },
     {
       username : "User2",
       userID: 123
       text : "hi1",
     }
   ]
}

I want to remove the field in username from the objects in this array. I tried this db.collection.update({}, {$unset: {"reviews.username": 1}}, {multi: true}) I tried with even updateMany and it just matchedCouunt and acknowledged.

Or Nakash · Accepted Answer · 2022-03-25 13:51:14Z

2

Try using the positional identifier and do something like:

db.collection.update({}, {$unset: {"reviews.$[].username":true}}, {multi:true})

Personally I prefer using the method below:

db.collection.update({"reviews.username": {$exists: true}}, {$unset: {"reviews.$.username":true}}, {multi:true})

Because sometimes you should check if it exists before you do the deleting (this way you won't get any errors).

edited Mar 25, 2022 at 13:51

answered Mar 25, 2022 at 13:43

Or Nakash

3,4982 gold badges17 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Mongodb remove field from Array objects all documents?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related