node.js mongoose update specific value in document

Question

I have a document like below:

{
    "_id" : ObjectId("52e51809454115b7c5d593a4"),
    "usage" : {
        "from" : "2013-12-02T00:00:00+01:00",
        "to" : "2014-02-02T00:00:00+01:00",
        "used" : 674999999,
        "total" : NumberLong(4000000000)
    },
        "refills" : [ 
        {
            "id" : "RXh0cmEgU3VyZnZvbHlt",
            "amount" : 1000000000,
            "fee" : "5520",
            "feeVat" : "6900",
            "validTo" : "2014-02-02T00:00:00+01:00"
        }
    ],
}

Where i would like to update the value "total" in "usage" and add to it the value "amount" in "refills" All other values should be the same.

How do i do that best?

score 0 · Answer 1 · edited May 23 '17 at 12:28

0

Assuming that refills is an object and not an array as in your example:

coll.find( ..., function( err, result) {
    ...
    coll.update( ..., { $set: { 'refills.amount': ... } }, function( err,result ) {
        ...
    });
});

So you first have to read the specific document to get the value of total and then update the field refills.amount. You can use $set or $inc depending on how you want to update.

EDIT:

If refills is an array it is not that different. See here.

edited May 23 '17 at 12:28

Community

1
1

answered Jan 26 '14 at 17:49

heinob

19,127
5
41
61

Hi, the thing is that refills is a array :/ – morto Jan 26 '14 at 18:05
How many array elements are there and do you know which one of them to update? If yes, where do you know? – heinob Jan 26 '14 at 18:28
Yes, I understood that. But `amount` of which array element? In an array there can be multiple... – heinob Jan 26 '14 at 19:02
Aa sorry in this case it will always be just one. Or the one with a specific "id" – morto Jan 26 '14 at 19:17

node.js mongoose update specific value in document

1 Answers1