Update in array MONGODB

You should use $addToSet or $push . The difference is whether you want unique elements in the array or not.

There is a positional operator $ that you can use to update elements in the index that matches your query. So if you "know" that there is a skill, but you do not know your position, you should do the following query:

db.grupos.update({ _id: "...", "Pessoas.Habilidades.Nome": "Correr" }, {
  "$addToSet": {
    "Pessoas.$.Habilidades.$.Macetes": { /*...*/ }  
  }
})

If you want to remove elements, you will have to use $pull and to add / remove more than one element you will have to use $each .

Useful links:

• link

• link

• link

• link

I suggest an index in Pessoas.Habilidades.Nome .

EDIT

I just researched a little more and what you want to do is not possible:

• link

From the documentation:

  The positional operator $ can not be used for searches that traverse more than one array, such as searches that run through "arrays" in other arrays, because substitution by placeholder $ is a single value

It is necessary to change the way the data is modeled. Or lose the atomicity of the operation.

You can use $ set . Example:

db.bla.update({"_id":"55dcb404478e7227203d3a65"},
{
    "$set": {
        "Pessoas.0.Habilidades.1.Macetes": [
            {
                "HabilidadeId": "idnovo",
                "Nome": "Pular"
            }
        ]
    }
})