How to update Meteor array element inside a document

Question

I have a Meteor Mongo document as shown below

{
    "_id" : "zFndWBZTvZPgSKXHP",
    "activityId" : "aRDABihAYFoAW7jbC",
    "activityTitle" : "Test Mongo Document",
    "users" : [
        {
            "id" : "[email protected]",
            "type" : "free"
        },
                {
            "id" : "JqKvymryNaCjjKrAR",
            "type" : "free"
        },
    ],
}

I want to update a specific array element's email with custom generated id using Meteor query something like the below.

for instance, I want to update the document if 'users.id' == "[email protected]" then update it to users.id = 'SomeIDXXX'

So updated document should looks like below.

{
    "_id" : "zFndWBZTvZPgSKXHP",
    "activityId" : "aRDABihAYFoAW7jbC",
    "activityTitle" : "Test Mongo Document",
    "users" : [
        {
            "id" : "SomeIDXXX",
            "type" : "free"
        },
        {
            "id" : "JqKvymryNaCjjKrAR",
            "type" : "free"
        },

    ],
}

I have tried the below but didnt work.

 Divisions.update(
      { activityId: activityId, "users.id": emailId },
      { $set: { "users": { id: _id } } }
    );

Can someone help me with the relevant Meteor query ? Thanks !

Harry Adel · Accepted Answer · 2020-03-10 17:11:06Z

1

Your query is actually almost right except for a small part where we want to identify the element to be updated by its index.

Divisions.update({
"activityId": "aRDABihAYFoAW7jbC",
 "users.id": "[email protected]"
}, {
$set: {"users.$.id": "[email protected]"}
})

answered Mar 10, 2020 at 17:11

Harry Adel

1,46513 silver badges17 bronze badges

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

Comments

thatsmycode · Accepted Answer · 2020-03-10 17:40:16Z

1

You might need the arrayFilters option.

Divisions.update(
  { activityId: activityId },
  { $set: { "users.$[elem].id": "SomeIDXXX" } },
  { arrayFilters: [ { "elem.id": "[email protected]" } ], multi: true }
);

https://docs.mongodb.com/manual/reference/operator/update/positional-filtered/

answered Mar 10, 2020 at 17:40

thatsmycode

212 bronze badges

Comments

Erez Hochman · Accepted Answer · 2020-03-10 15:23:34Z

0

You need to use the $push operator instead of $set.

{ $push: { <field1>: <value1>, ... } }

answered Mar 10, 2020 at 15:23

Erez Hochman

1,7081 gold badge12 silver badges14 bronze badges

2 Comments

Bart S Over a year ago

This adds a new object to the array. Syam is asking how to update an existing object in the array.

Syam Kumar Over a year ago

Yes @BartS said is right. I want to update existing element.

Collectives™ on Stack Overflow

How to update Meteor array element inside a document

3 Answers 3

Comments

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Related