MongoDB add field to an object inside an array

Question

I have an object user that looks like that

{
    "_id" : ObjectId("5edbdf57ac52325464b054ec"),
    ...
    "purchaseHistory" : [ 
        {
            "_id" : ObjectId("5ee7a8f6b438a1254cec3f74"),
        ...
        },
        {
            "_id" : ObjectId("5ee7a8f6b438a1254cec3f88"),
        ...
        }
    ]
}

What I wanna do is to add a new field to a specific object inside "purchaseHistory" by ID, for example I wanna add to "5ee7a8f6b438a1254cec3f88" a field "status": 0

What I tried is

users.findOneAndUpdate(
    {
        _id: ObjectId(userId),
        'purchaseHistory._id': ObjectId(saleId)
    },
    {
        $set: { 'purchaseHistory.$.status': status}
    }
)

But it gives me an error, how can I do it properly?

@AyushGupta the error was because I called it from a different function and I missed the userId :) I didn't see that but I fixed it after I read the error by using try & catch, thanks! — daniel93, Jun 15 '20 at 21:14
Does this answer your question? [MongoDB - Update objects in a document's array (nested updating)](https://stackoverflow.com/questions/10522347/mongodb-update-objects-in-a-documents-array-nested-updating) Marking it as dup.. — whoami - fakeFaceTrueSoul, Jun 16 '20 at 05:41

score 0 · Answer 1 · answered Jun 15 '20 at 21:13

According to the website provided by D. SM, I was able to do it this way

users.findOneAndUpdate(
    {
        '_id': ObjectId(userId),
        'purchaseHistory._id': ObjectId(saleId)
    },
    {
        $set: { 'purchaseHistory.$.status': status }
    }
)

score -1 · Accepted Answer · answered Jun 15 '20 at 21:01

-1

MongoDB provides the positional update operator for cases like this.

answered Jun 15 '20 at 21:01

D. SM

13,584
3
12
21

MongoDB add field to an object inside an array

2 Answers2