How to update records without triggering the updatedAt timestamp?

[Renand]

Hello,
I need to update some records without triggering the automatic updatedAt timestamp. Is there a way to do this?
Thank you in advance.

V 2.5.1

[dbelanger]

On the update method, there is an argument called allowExplicitTimestamps. You can set that to true and force the old updatedAt like so:

post = model("post").findByKey(params.key);
post.update(
    createdAt=post.createdAt,
    updatedAt=post.updatedAt,
    deletedAt=post.deletedAt,
    properties=PARAMS.post
);

This example of course assumes the post params you need to update are coming in through a post struct in your PARAMS.

[Renand]

Thank you !

You confirm that it is possible to use allowExplicitTimestamps only for certain updates ?

, e.g.:

post = model("post").findByKey(params.key, allowExplicitTimestamps=false); post.update(

createdAt=post.createdAt,
updatedAt=post.updatedAt,
deletedAt=post.deletedAt,
properties=PARAMS.post

);

[Renand]

Sorry, I misunderstood. The cleanliness: allowExplicitTimestamps is part of the update() function — I have this code, but it doesn’t work.

local.user = model("user").findByKey(key=session.user.id);
if (IsObject(local.user)) {
local.user.action = params.action;
local.user.logType = "success";
local.user.rememberToken = "";
local.user.update(allowExplicitTimestamps=true, updatedAt=local.user.updatedAt);
}