- Roadmap
-
Ideas
+130
Completed
Last modification time
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)
(http://cintanotes.com/forum/viewtopic.php?f=4&t=194)
Answer
0
Answer
Completed
Alex Jenter 13 years ago
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 :(
* 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 :(
Customer support service by UserEcho
