Last modification time
Alex Jenter 13 years ago • updated 11 years ago • 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.
Customer support service by UserEcho
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 :(