Update multiple documents and return all updated documents

Question

I am looking for a way to update many documents at once using mongoose and return all the modified documents. I tried with setting multi:true in update(). It is updating all matching documents but not returning any. Then I tried with findOneAndUpdate(). It is updating and returning only one document even if there are many matching ones. Yeah, the function name itself tells, it will update only one, still I tried. I could not set option like multi:true in findOneAndUpdate(). How can it be done? Thanks in advance

Answer 1

Currently I don't think its possible in MongoDB to update multiple documents and return all the updated documents in the same query.

In Mongoose, the findOneAndUpdate() is based on the native findAndModify() method of MongoDB.

If you check the offical documentation of the findAndModify() method, its states that -

The findAndModify command modifies and returns a single document.

Although the query may match multiple documents, findAndModify will only select one document to modify.

Hence, you can not update multiple documents using findAndModify.

update() or updateMany() method on the other hand updates many documents with the multi flag but it only returns the WriteResult which looks like this -

WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })