Mongoose findOneAndUpdate doesn t return updated document

Question

Below is my code  var mongoose   require  mongoose    mongoose connect  mongodb   localhost test     var Cat   mongoose model  Cat         name  String      age   type  Number  default  20       create   type  Date  default  Date now        Cat findOneAndUpdate  age  17     set  name  Naomi    function err  doc       if err           console log  Something wrong when updating data                console log doc         I already have some record in my mongo database and I would like to run this code to update name for which age is 17 and then print result out in the end of code   However  why I still get same result from console not the modified name  but when I go to mongo db command line and type  db cats find      The result came with modified name   Then I go back to run this code again and the result is modified   My question is   If the data was modified  then why I still got original data at first time when console log it

User · Answer

By default findOneAndUpdate returns the original document  If you want it to return the modified document pass an options object   new  true   to the function   Cat findOneAndUpdate   age  17       set    name   Naomi         new  true    function err  doc

User · Answer

If you want to return the altered document you need to set the option  new true  API reference you can use Cat findOneAndUpdate conditions  update  options  callback     executes   Taken by the official Mongoose API http   mongoosejs com docs api html findoneandupdate findOneAndUpdate you can use the following parameters  A findOneAndUpdate conditions  update  options  callback     executes A findOneAndUpdate conditions  update  options      returns Query A findOneAndUpdate conditions  update  callback     executes A findOneAndUpdate conditions  update               returns Query A findOneAndUpdate                                  returns Query   Another implementation thats is not expressed in the official API page and is what I prefer to use is the Promise base implementation that allow you to have  catch where you can deal with all your various error there       let cat  catInterface             name   Naomi              Cat findOneAndUpdate  age 17   cat  new  true   then  data    gt           if data     null               throw new Error  Cat Not Found                      res json   message   Cat updated              console log  New cat data   data          catch   error    gt                           Deal with all your errors here with your preferred error handle middleware   method                     res status 500  json   message   Some Error              console log error

User · Answer

Below shows the query for mongoose s findOneAndUpdate  Here new  true is used to get the updated doc and fields is used for specific fields to get   eg  findOneAndUpdate conditions  update  options  callback   await User findOneAndUpdate           id   data id            set    name   Amar   designation   Software Developer               new  true        fields             name   1           designation   1                exec

User · Answer

Mongoose maintainer here  You need to set the new option to true  or  equivalently  returnOriginal to false   await User findOneAndUpdate filter  update    new  true         Equivalent await User findOneAndUpdate filter  update    returnOriginal  false       See Mongoose findOneAndUpdate   docs and this tutorial on updating documents in Mongoose

User · Answer

So   findOneAndUpdate  requires an option to return original document  And  the option is   MongoDB shell   returnNewDocument  true   Ref  https   docs mongodb com manual reference method db collection findOneAndUpdate   Mongoose   new  true   Ref  http   mongoosejs com docs api html query Query-findOneAndUpdate  Node js MongoDB Driver API    returnOriginal  false   Ref  http   mongodb github io node-mongodb-native 3 0 api Collection html findOneAndUpdate

User · Answer

This is the updated code for findOneAndUpdate  It works   db collection findOneAndUpdate          age  17               set    name   Naomi                      returnNewDocument  true

User · Answer

For whoever stumbled across this using ES6   ES7 style with native promises  here is a pattern you can adopt     const user     id  1  name   Fart Face 3rd    const userUpdate     name   Pizza Face      try       user   await new Promise    resolve  reject     gt            User update     id  user id    userUpdate    upsert  true  new  true      error  obj     gt                if  error                     console error  JSON stringify  error                      return reject  error                               resolve  obj                         catch  error        set the world on fire

User · Answer

I know  I am already late but let me add my simple and working answer here  const query        your query here const update        your update in json here const option    new  true    will return updated document  const user   await User findOneAndUpdate query   update  option

User · Answer

Why this happens   The default is to return the original  unaltered document  If you want the new  updated document to be returned you have to pass an additional argument  an object with the new property set to true   From the mongoose docs       Query findOneAndUpdate  Model findOneAndUpdate conditions  update  options   error  doc    gt         error  any errors that occurred      doc  the document before updates are applied if  new  false   or after updates if  new   true            Available options         new  bool - if true  return the modified document rather than the original  defaults to false  changed in 4 0       Solution  Pass  new  true  if you want the updated result in the doc variable                                                              V--- THIS WAS ADDED Cat findOneAndUpdate  age  17     set  name  Naomi      new  true    err  doc    gt        if  err            console log  Something wrong when updating data                console log doc

User · Answer

In some scenarios  new  true  is not working  Then you can try this    returnNewDocument  true

User · Answer

For anyone using the Node js driver instead of Mongoose  you ll want to use  returnOriginal false  instead of  new true

[node.js] Mongoose: findOneAndUpdate doesn't return updated document

Examples related to node.js

Examples related to mongodb

Examples related to mongoose