Meteor: Update nested object in document array

Question

I try to update a specific object in a document. In this example, I want to change the object with group.id = 'fdsfsFDSFdsfFdsFd' and data.id = 'qqdWSdksFVfSVSSCD'.

That means I want to update the object { "id" : "qqdWSdksFVfSVSSCD", "note 2" : "text" } with var newData = { "id" : "qqdWSdksFVfSVSSCD", "new one" : "anything" }.

{
    "_id" : "wLXDvjDvbsxzfxabR",
    "group" : [
        {
            "id" : "dfDFSfdsFDSfdsFws",
            "title" : "title 1",
            "data" : [
                {
                    "id" : "efBDEWVvfdvsvsdvs",
                    "note" : "text"
                }
            ]
        },
        {
            "id" : "fdsfsFDSFdsfFdsFd",
            "title" : "title 2",
            "data" : [
                {
                    "id" : "WVvfsvVFSDWVDSVsv",
                    "note 1" : "text"
                },
                {
                    "id" : "qqdWSdksFVfSVSSCD",
                    "note 2" : "text"
                },
                {
                    "id" : "MZgsdgtscdvdsRsds",
                    "note 3" : "text"
                }
            ]
        }
    ]
}

So how do I access exactly this object?

Collection.update(
    { _id: 'wLXDvjDvbsxzfxabR' },
    { $set: { group.data: newData } } // group: fdsfsFDSFdsfFdsFd, data: qqdWSdksFVfSVSSCD
)

I don't get it to update a nested array element...

David Kleiman · Accepted Answer · 2016-01-10 00:04:50Z

3

If you want to update a specific element in the array then you will have to include that in your query. Also, when querying in nested objects you should wrap the query in quotes.

// Update element in array with id "dfDFSfdsFDSfdsFws"
Collection.update(
    { _id: "wLXDvjDvbsxzfxabR", "group.id": "dfDFSfdsFDSfdsFws"}, 
    {$set: { "group.data": newData }}
);

answered Jan 10, 2016 at 0:04

David Kleiman

6277 silver badges15 bronze badges

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

2 Comments

user3142695 Over a year ago

But i need two levels. So, how do i access exactly the object i described. The other elements in the document shouldn't be changed.

David Kleiman Over a year ago

Sorry, I misunderstood the question. See Michael Floyd's answer. That is, just change the query { _id: "wLXDvjDvbsxzfxabR", "group.id": "dfDFSfdsFDSfdsFws"} to { _id: "wLXDvjDvbsxzfxabR", "group.data.id": "qqdWSdksFVfSVSSCD"}.

Michel Floyd · Accepted Answer · 2016-01-10 07:42:45Z

1

David's answer is close:

Collection.update(
  { _id: "wLXDvjDvbsxzfxabR", "group.data.id": "qqdWSdksFVfSVSSCD"}, 
  {$set: { "group.data": newData }}
);

answered Jan 10, 2016 at 7:42

Michel Floyd

20.3k4 gold badges27 silver badges45 bronze badges

3 Comments

Gobliins Over a year ago

i am getting "group.data" is not allowed by the schema?

Michel Floyd Over a year ago

That means your using a schema manager (ex: simpl-schema) - check your schema definition. Does the schema allow for a group object in Collection and does the group object include a data array?

Gobliins Over a year ago

i use aldeed:simpleschema, and i have an array in my schema wit objects in it. Schema (according to this example) group: { type: [Object] }, group.$.data: { type: Object }. But i fugred out with the $ in between. It works..

Community · Accepted Answer · 2017-05-23 12:08:18Z

As mentioned here and here it is impossible to update nested arrays in array right now.

If you can I would recommend you to change you document schema in order to remove embedded array in array. You can change one array to JSON object:

{
"_id" : "wLXDvjDvbsxzfxabR",
"group" : [
    {
        "id" : "dfDFSfdsFDSfdsFws",
        "title" : "title 1",
        "data" : {
             "efBDEWVvfdvsvsdvs": {
                "note" : "text"
             } 
        }
    },
    {
        "id" : "fdsfsFDSFdsfFdsFd",
        "title" : "title 2",
        "data" : {
            "WVvfsvVFSDWVDSVsv": {
                "note 1" : "text"  
            },
            "qqdWSdksFVfSVSSCD": {
                "note 2" : "text"
            },
            "MZgsdgtscdvdsRsds": {
                "note 3" : "text"
            }
        }
    }
]
}

With such schema you can update specific object in data field with such query:

db.collection.update(
  {'group.id': 'fdsfsFDSFdsfFdsFd'}, 
  {$set: {'group.$.data.qqdWSdksFVfSVSSCD': {"new one" : "anything"}}}
)

Collectives™ on Stack Overflow

Meteor: Update nested object in document array

3 Answers 3

2 Comments

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

3 Comments

Comments

Linked

Related