timestamps query option doesn't work in 6.x+ about mongoose HOT 6 CLOSED

Everything seems good in the _setTimestampsOnUpdate pre middleware, if I console.log(this.getUpdate()) before the next() I see:

{ '$set': { createdAt: 2023-01-10T16:45:36.366Z } }

However, with debug enabled, I can see Mongoose only runs Mongoose: people.findOne({ name: 'John' }, { new: true }) - the createdAt field is being stripped at some point and Mongoose apparently determines the update to be empty.

Similarly, setting {timestamps: {createdAt: false}} correctly yields this in the timestamps middleware:

{
    '$set': {
      createdAt: 2023-01-10T16:49:29.791Z,
      updatedAt: 2024-01-10T16:49:29.792Z
    }
  }

But Mongoose is again stripping out the createdAt field when running the query:

Mongoose: people.findOneAndUpdate({ name: 'John' }, { '$set': { updatedAt: new Date("Wed, 10 Jan 2024 16:49:29 GMT") } }, { returnDocument: 'after', returnOriginal: false })

from mongoose.

Never mind, I missed this update in the 6.x migration guide:

Immutable createdAt
If you set timestamps: true, Mongoose will now make the createdAt property immutable. See gh-10139

Would a PR making this more explicit in the docs be helpful @vkarpov15?

from mongoose.

@eric-titan yes please, put in a PR with where you think would be a good place to put this information in the docs.

from mongoose.

@eric-titan I took a closer look and our timestamps docs do have an example of how to overwrite createdAt using findOneAndUpdate() in this section: https://mongoosejs.com/docs/timestamps.html#disabling-timestamps. Below is the code sample:

let doc = await User.create({ name: 'test' });

// To update `updatedAt`, do a `findOneAndUpdate()` with `timestamps: false` and
// `updatedAt` set to the value you want
doc = await User.findOneAndUpdate({ _id: doc._id }, { updatedAt: new Date(0) }, {
  new: true,
  timestamps: false
});
console.log(doc.updatedAt); // 1970-01-01T00:00:00.000Z

// To update `createdAt`, you also need to set `strict: false` because `createdAt`
// is immutable
doc = await User.findOneAndUpdate({ _id: doc._id }, { createdAt: new Date(0) }, {
  new: true,
  timestamps: false,
  strict: false
});
console.log(doc.createdAt); // 1970-01-01T00:00:00.000Z

Is there somewhere else in the docs you would expect to see this example?

from mongoose.

This issue is stale because it has been open 14 days with no activity. Remove stale label or comment or this will be closed in 5 days

from mongoose.

This issue was closed because it has been inactive for 19 days and has been marked as stale.

from mongoose.