+130
Voltooid

Last modification time

Alex Jenter 14 jaar geleden bijgewerkt 13 jaar geleden 1
At the moment CN saves creation date and time of a note. As an enhancement we might also save date and time of last modification.
(http://cintanotes.com/forum/viewtopic.php?f=4&t=194)
editing date-time complexity:easy

Antwoord

Antwoord
Voltooid
Released in 1.5.4
+1
* Sorting notes by "Date" should sort using the modification time.

* Why?
  Because last modified entries become visible on top of the notes list
  not only entries entered newly.

* How to handle new entries?
  Modification time must be set same as creation time.

* Migration of database
  If modification time is a new db column then a migration
  process must assign a value the same as creation time.

* Alternative #1
  Maybe a coalesce() function could be used e.g.
  ORDER BY COALESCE(ModificationTime, CreationTime).
  This would avoid complexity and a migration process.

* Alternative #2
  The creation date could be modified any time an entry gets changed.
  The advantage would be to avoid a db schema change.
  The disadvantage would be the loss of the creation date :(
Antwoord
Voltooid
Released in 1.5.4