I´m using mongotemplate for Spring, and I was wondering how I could increment a value of one of my documents that I have in an array atomically. Imagine that we have


What I would like is increment c from 3 to 4 for the _id 341445

I have been using findAndModify but I dont know how can I make it for a nested document in an array.


Solution 1

To update an element in an array field, you can use the positional $ operator

For example, the following js increments c from 3 to 4 for _id 341445:

db.collection.update({a:1, "b._id":341445} , {$inc:{"b.$.c":1}})