db.collection.findOneAndUpdate () is not returning the "updated" document

Question

following the official manual,

db.students2.findOneAndUpdate(
   { _id : 1 },
   [ { $set: { "total" : { $sum: "$grades.grade" } } } ],  // The $set stage is an alias for ``$addFields`` stage
   { returnNewDocument: true }
)

My implementation,

const usersCollection = db().collection("users"); // db() is exposed via a module

usersCollection.findOneAndUpdate(
   { _id : new ObjectID (this.data._id)},
   { $set: { 
           total : this.data.updatedTotal
        }
    } ,
   { returnNewDocument: true }
)

despite the `{ returnNewDocument: true }` option, it still returns the old document

But, when I query the collection again,

usersCollection.findOne({_id: new ObjectID()}); // returns the updated document

it returns the updated document. Which means that the db.collection.findOneAndUpdate() worked.

the problem is, it's not returning the updated document, despite the `{ returnNewDocument: true }` option .

Why is that ?

check this answer https://stackoverflow.com/a/32811548/5990249 — sharun k k, Nov 21 '20 at 08:56
you have to add one more argument `{new:true}` for monoose to understand you need updated document — sharun k k, Nov 21 '20 at 08:57

score 1 · Answer 1 · answered Nov 21 '20 at 09:08

1

For mongoose to return the new document, you need to add { new: true } to the query.

I would give this as shot:

usersCollection.findOneAndUpdate(
   { _id : new ObjectID (this.data._id) },
   { $set: { total : this.data.updatedTotal } },
   { new: true }
)

answered Nov 21 '20 at 09:08

Stephan Bakkelund Valois

992
1
9
23

score 1 · Accepted Answer · answered Nov 21 '20 at 09:10

1

To return it you need to add

{returnOriginal: false}

Always check the Node JS MongoDB API

answered Nov 21 '20 at 09:10

Minsky

2,277
10
19

score 1 · Answer 3 · answered Dec 05 '22 at 06:34

1

Node mongodb driver: returnOriginal was Deprecated, use returnDocument with "before" or "after" instead.

{returnDocument: 'after'}

answered Dec 05 '22 at 06:34

Elect2

1,349
2
12
22

score -1 · Answer 4 · answered Nov 21 '20 at 09:14

-1

I solved it.

Since I am using the native mongodb driver,

we'll want to use {returnOriginal: false} instead of {new: true}.

answered Nov 21 '20 at 09:14

Rahul Dahal

152
1
12