The
findOneAndUpdate()
function in Mongoose
has a wide variety of use cases.
You should use
save()
to update documents where possible
, for better
validation
and
middleware
support.
However, there are some cases where you need to use
findOneAndUpdate()
. In this tutorial, you'll see how to use
findOneAndUpdate()
, and learn when you need to use it.
Getting Started
Atomic Updates
Upsert
The
includeResultMetadata
Option
Updating Discriminator Keys
Getting Started
As the name implies,
findOneAndUpdate()
finds the first document that matches a given
filter
, applies an
update
, and returns the document.
The
findOneAndUpdate()
function has the following signature:
function findOneAndUpdate(filter, update, options) {}
By default, findOneAndUpdate()
returns the document as it was before update
was applied.
In the following example, doc
initially only has name
and _id
properties.
findOneAndUpdate()
adds an age
property, but the result of findOneAndUpdate()
does not have an age
property.
const Character = mongoose.model('Character', new mongoose.Schema({
name: String,
age: Number
const _id = new mongoose.Types.ObjectId('0'.repeat(24));
let doc = await Character.create({ _id, name: 'Jean-Luc Picard' });
doc;
const filter = { name: 'Jean-Luc Picard' };
const update = { age: 59 };
doc = await Character.findOneAndUpdate(filter, update);
doc;
doc = await Character.findOne(filter);
doc.age;
You should set the new
option to true
to return the document after update
was applied.
const filter = { name: 'Jean-Luc Picard' };
const update = { age: 59 };
const doc = await Character.findOneAndUpdate(filter, update, {
new: true
doc.name;
doc.age;
Mongoose's findOneAndUpdate()
is slightly different from the MongoDB Node.js driver's findOneAndUpdate()
because it returns the document itself, not a result object.
As an alternative to the new
option, you can also use the returnOriginal
option.
returnOriginal: false
is equivalent to new: true
. The returnOriginal
option
exists for consistency with the the MongoDB Node.js driver's findOneAndUpdate()
,
which has the same option.
const filter = { name: 'Jean-Luc Picard' };
const update = { age: 59 };
const doc = await Character.findOneAndUpdate(filter, update, {
returnOriginal: false
doc.name;
doc.age;
Atomic Updates
With the exception of an unindexed upsert, findOneAndUpdate()
is atomic. That means you can assume the document doesn't change between when MongoDB finds the document and when it updates the document, unless you're doing an upsert.
For example, if you're using save()
to update a document, the document can change in MongoDB in between when you load the document using findOne()
and when you save the document using save()
as show below. For many use cases, the save()
race condition is a non-issue. But you can work around it with findOneAndUpdate()
(or transactions) if you need to.
const filter = { name: 'Jean-Luc Picard' };
const update = { age: 59 };
let doc = await Character.findOne({ name: 'Jean-Luc Picard' });
await Character.updateOne(filter, { name: 'Will Riker' });
doc.age = update.age;
await doc.save();
doc = await Character.findOne();
doc.name;
doc.age;
Upsert
Using the upsert
option, you can use findOneAndUpdate()
as a find-and-upsert operation. An upsert behaves like a normal findOneAndUpdate()
if it finds a document that matches filter
. But, if no document matches filter
, MongoDB will insert one by combining filter
and update
as shown below.
const filter = { name: 'Will Riker' };
const update = { age: 29 };
await Character.countDocuments(filter);
const doc = await Character.findOneAndUpdate(filter, update, {
new: true,
upsert: true
doc.name;
doc.age;
Mongoose transforms the result of findOneAndUpdate()
by default: it
returns the updated document. That makes it difficult to check whether
a document was upserted or not. In order to get the updated document
and check whether MongoDB upserted a new document in the same operation,
you can set the includeResultMetadata
flag to make Mongoose return the raw result
from MongoDB.
const filter = { name: 'Will Riker' };
const update = { age: 29 };
await Character.countDocuments(filter);
const res = await Character.findOneAndUpdate(filter, update, {
new: true,
upsert: true,
includeResultMetadata: true
res.value instanceof Character;
res.lastErrorObject.updatedExisting;
Here's what the res
object from the above example looks like:
{ lastErrorObject:
{ n: 1,
updatedExisting: false,
upserted: 5e6a9e5ec6e44398ae2ac16a },
value:
{ _id: 5e6a9e5ec6e44398ae2ac16a,
name: 'Will Riker',
__v: 0,
age: 29 },
ok: 1 }
Updating Discriminator Keys
Mongoose prevents updating the discriminator key using findOneAndUpdate()
by default.
For example, suppose you have the following discriminator models.
const eventSchema = new mongoose.Schema({ time: Date });
const Event = db.model('Event', eventSchema);
const ClickedLinkEvent = Event.discriminator(
'ClickedLink',
new mongoose.Schema({ url: String })
const SignedUpEvent = Event.discriminator(
'SignedUp',
new mongoose.Schema({ username: String })
Mongoose will remove __t
(the default discriminator key) from the update
parameter, if __t
is set.
This is to prevent unintentional updates to the discriminator key; for example, if you're passing untrusted user input to the update
parameter.
However, you can tell Mongoose to allow updating the discriminator key by setting the overwriteDiscriminatorKey
option to true
as shown below.
let event = new ClickedLinkEvent({ time: Date.now(), url: 'google.com' });
await event.save();
event = await ClickedLinkEvent.findByIdAndUpdate(
event._id,