How to update specific object inside the array?

Question

I have a data that looks like below in MongoDB

{
_id: aasdfeasfeasdf,
todo: [
         {_todoIde: 333, _with: []},
         {_todoIde: 111, _with: []},
      ]
}

I want to $addToSet value to _todoIde: 333's _with like {_todoIde: 333, _with: [aaaa]},. How can I do it?

.updateOne(
   {_id},
   { $addToSet: {}}
)

I got to the document but I can't specify that _todoIde: 333 to update just that one.

turivishal · Accepted Answer · 2021-01-12 17:02:25Z

2

The positional $ operator identifies an element in an array to update without explicitly specifying the position of the element in the array,

.updateOne(
  { _id: "aasdfeasfeasdf", "todo._todoIde": 333 },
  {
    $addToSet: {
      "todo.$._with": "aaaa"
    }
  }
)

answered Jan 12, 2021 at 16:49

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

Comments

Algo7 · Accepted Answer · 2021-01-12 16:50:25Z

1

You have to add an extra condition to specify the todoIde

Try this:


db.collection.update(
            {$and:[{_id: typeId},{'todo._todoIde': 333}]},
            {$set: { "todo._todoIde.$._with":[a,b,c]}},
        );

answered Jan 12, 2021 at 16:50

Algo7

2,1561 gold badge10 silver badges20 bronze badges