How can you only update one match of an array filter

[steevej (Steeve Juneau)]

To help the discussion I have linked your other thread as it looks like it is exactly the same question.

Why is my Mongodb aggregation pipeline updateOne() working in compass, but not working in my node driver

An aggregation does not update the original document and since you are calling updateOne, I assume that you want to update the original document. So whatever what you end up doing in your aggregation with limit:1 or not, your original document will not be updated. I was able to update all wieghts.$.spotsAvailable by using the arrayFilters: { "el2" : { "userId" : "empty" , "name" : "empty" } } I still do not know how to set up a filter that test only one of the field of a sub-object. I stil…