MongoDB Update Array of objects if property is the same

Question

I want to update this document's subscribers array if property 'name' is the same as the name I specify, if not add it to the array

{
    id: "Test-123456789",
    subscribers: [
        {
            name: "Test1",
            points: 123
        },
        {
            name: "Test2",
            points: 3282
        }

    ]
}

J.F. · Accepted Answer · 2021-11-02 12:28:03Z

1

You can use positional operator $ like this:

db.collection.update({
  "id": "Test-123456789",
  "subscribers.name": yourValue
},
{
  "$set": {
    "subscribers.$.points": 0
  }
})

Example here.

Note that I've modified points field but using $ you can access the object and modify as you want, like this example

answered Nov 2, 2021 at 12:28

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

MongoDB Update Array of objects if property is the same

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