How to update all all nested array with condition in MongoDB

Question

I have an array with nested objects. If the message is "Hi", I want to change it to "Hello". Here is my array:

[{
  name : "name",
  email : "email",
  conversation : [
  {
    message : "Hi",
    seenBy : "karen"
  },
  {
    message : "Hi",
    seenBy : "leo"
  },
  {
    message : "Goodbye",
    seenBy : "mark"
  }
 ]
},
{
  name : "name",
  email : "email",
  conversation : [
  {
    message : "Hi",
    seenBy : "karen"
  },
  {
    message : "Listen",
    seenBy : "leo"
  },
  {
    message : "Sit",
    seenBy : "mark"
  },
{
    message : "Hi",
    seenBy : "mark"
  }
 ]
}]

Here's have I have tried:

db.updateMany({ conversation: { $elemMatch: { message: "Hi" } } },
  { $set: {"items.$[].message": "Hello" }},
  {multi: true}
  )

But it updates all messages to "Hello" even messages that are not "Hi"

Tushar Gupta - curioustushar · Accepted Answer · 2021-04-20 12:47:36Z

1

Demo - https://mongoplayground.net/p/AUJ8k2S6S5H

Use $[<identifier>]

The filtered positional operator $[] identifies the array elements that match the arrayFilters conditions for an update operation,

db.collection.update(
  {conversation: { $elemMatch: { message: "Hi" } } },
  { $set: { "conversation.$[c].message": "Hello" } },
  { multi: true, arrayFilters: [ { "c.message": "Hi" } ]}
)

answered Apr 20, 2021 at 12:47

Tushar Gupta - curioustushar

57.2k24 gold badges106 silver badges110 bronze badges

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

Collectives™ on Stack Overflow

How to update all all nested array with condition in MongoDB

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