MongoDB - Updating multiple subarrays in an array

Question

Is it possible to remove elements from multiple subarrays inside of one big array? My structure looks something like this:

{
  "_id": {
    "$oid": ""
  },
  "users": [
    {
      "friends": [
        "751573404103999569"
      ]
    },
    {
      "friends": [
        "220799458408005633"
      ]
    }
  ]
}

I have a friend id and I need to remove it from all the "friends" arrays in the "users" array

R2D2 · Accepted Answer · 2021-01-06 01:23:39Z

1

You can do with the positional operator $[] as follow:

db.no_more_friends.update({ "users.friends":"the_friend_id"  },{ $pull:{"users.$[].friends":"the_friend_id"}} ,{multi:true})

Just take in consideration that with {multi:true} it will perform the user id removal to all friends sub-arrays in all documents where "the_friend_id" is found

edited Jan 6, 2021 at 1:23

answered Jan 6, 2021 at 0:56

R2D2

10.9k2 gold badges20 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

MongoDB - Updating multiple subarrays in an array

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