MongoDB: Update nested element

Question

I want to update this document...

{
    "_id" : "2QCTWXJHMa3Sjnta5",
    "text" : [
        {
            "id" : "krD8yXFEEd8Esc4Qc",
            "sentence" : "dasdsada."
        },
        {
            "id" : "AwXHZmPKSPyKvd9E9",
            "sentence" : "adsdadas ."
        },
        {
            "id" : "bsf6RyKDQyrnqsmK7",
            "sentence" : "daadadadad"
        }
    ]
}

... to this

{
    "_id" : "2QCTWXJHMa3Sjnta5",
    "text" : [
        {
            "id" : "krD8yXFEEd8Esc4Qc",
            "sentence" : "dasdsada."
        },
        {
            "id" : "AwXHZmPKSPyKvd9E9",
            "sentence" : "Just changed"
        },
        {
            "id" : "bsf6RyKDQyrnqsmK7",
            "sentence" : "daadadadad"
        }
    ]
}

Therefore I tried:

Collection.update(
    { _id: '2QCTWXJHMa3Sjnta5', text.id: 'AwXHZmPKSPyKvd9E9' },
    { $set: { sentence: "Just changed" }}

);

What am I doing wrong?

Volodymyr Synytskyi · Accepted Answer · 2016-01-15 12:41:39Z

1

You need to identify an element in an array in order to update it. You can do it with the positional $ operator.

Be aware that positional $ operator acts as a placeholder for the first element in array that matches the query. So you can update only the first matched element in array with it.

Try the following query:

Collection.update(
  { _id: '2QCTWXJHMa3Sjnta5', 'text.id': 'AwXHZmPKSPyKvd9E9' },
  { $set: { 'text.$.sentence': "Just changed" }}

);

edited Jan 15, 2016 at 12:41

answered Jan 15, 2016 at 12:35

Volodymyr Synytskyi

4,0751 gold badge17 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

MongoDB: Update nested element

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related