MongoDB - How to replace only one object from array

Question

I have the following BSON data in MongoDB:

[
  {
     partyName : "p1",
     poNumber : "789",
  },
  {
     partyName : "p2",
     poNumber : "700",
  },
  {
     partyName : "p3",
     poNumber : "889",
  }
]

I want to replace the object where partyName is "p2" with a new object. I tried this

const user1 = await User.findOneAndUpdate({"array.partyName" :"p2"},{$set:{array:newObject}})

It replaces the object "p2" but it deletes the other objects (p1 and p3). I want to keep p1, and p3, but only update the p2 objects.

How can I overcome this problem?

Peter Mortensen · Accepted Answer · 2023-04-14 04:53:09Z

1

Work with the $ positional operator.

await User.findOneAndUpdate(
  { "array.partyName" :"p2" },
  { $set: { "array.$": newObject } }
)

Demo @ Mongo Playground

edited Apr 14, 2023 at 4:53

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Sep 10, 2022 at 12:22

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

MongoDB - How to replace only one object from 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