Update an item in an array that is in an array

Question

I have a document in a mongodb collection like this :

{
    sessions : [
        {
            issues : [ 
                {
                    id : "6e184c73-2926-46e9-a6fd-357b55986a28",
                    text : "some text"
                },   
                {
                    id : "588f4547-3169-4c39-ab94-8c77a02a1774",
                    text : "other text"
                }
            ]
        } 
    ]
}

And I want to update the issue with the id 588f4547-3169-4c39-ab94-8c77a02a1774 in the first session.

The problem is that I only know that it's the first session and the issue id (NOT the index of the issue !)

So I try something like this :

db.mycollection.update({ "sessions.0.issues.id" : "588f4547-3169-4c39-ab94-8c77a02a1774"}, 
                       { $set: { "sessions.0.issues.$.text" : "a new text" }})

But I got the following result :

WriteResult({
    "nMatched" : 0,
    "nUpserted" : 0,
    "nModified" : 0,
    "writeError" : {
        "code" : 16837,
        "errmsg" : "The positional operator did not find the match needed from the query. Unexpanded update: sessions.0.issues.$.text"
    }

How can I do this ?

Thanks for help.

i dont think "sessions.0.issues.Id" will work since issues is again an array — Sikorski
– Sikorski, Commented Jun 11, 2014 at 15:20

dgiugg · Accepted Answer · 2014-06-11 16:42:38Z

11

You have to use this (apparently equivalent) query:

db.mycollection.update({"sessions.0.issues": {$elemMatch: {id: <yourValue>}}}, {$set: {"sessions.0.issues.$.text": "newText"}})

Notice that your update expression was correct.

More information about $elemMatch.

Btw, MongoDB reference explicits that $ operator does not work "with queries that traverse nested arrays".

Important: $elemMatch only works with version 4 or more.

answered Jun 11, 2014 at 16:42

dgiugg

1,33414 silver badges24 bronze badges

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

3 Comments

Frédéric Guégan Over a year ago

It works ! I tried many combinations with $elemMatch but no one worked. Thank you

Desprit Over a year ago

Hi @dgiugg What if document with given id not exists? I'm populating update() method with upsert=True but it doesn't help creating new document...

dgiugg Over a year ago

@Desprit You cannot use $ operator with upsert. I recommend you to use two different queries. You also have $setOnInsert but it will run both on an new document: $set and then $setOnInsert.

Collectives™ on Stack Overflow

Update an item in an array that is in an array

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related