How to modify updated_at column or prevent auto update while updating certain property?

[homocodian]

Implimenting trash feature, i have column _deleted typeof boolean when i update it i don't wanted to update the updated_at column because I'm sorting data by updated_at column and don't want to change the order when it is marked as delete.

I have already tried managing updated_at column with different name _deleted_at but i'm getting cannot ready of type undefind error.

this is not working

export default class Note extends Model {
  static table = Table.note.name;

  @text("text") text!: string;
  @text("category") category!: string;
  @field("is_complete") isComplete!: boolean;
  @nochange @field("user_id") userId!: number;

  @field("_deleted") deleted!: boolean;

  @readonly @date("created_at") createdAt!: Date;
  @date("updated_at") updatedAt!: Date;
}

  static async delete(id: string) {
    await database.write(async () => {
      const data = await notes.find(id);
      const updatedDate = data.updatedAt;
      data.update((note) => {
        note.deleted = true;
        note.updatedAt = updatedDate;
      });
    });
  }
  
    static async undo(id: string) {
    await database.write(async () => {
      await (
        await notes.find(id)
      ).update((note) => {
        note.deleted = false;
      });
    });
  }

Query

const EnhancedNoteList = withObservables([], () => ({
  data: notes
    .query(Q.where("_deleted", Q.eq(false)), Q.sortBy("updated_at", Q.desc))
    .observe()
}))(NoteList);