- Status Closed
- Percent Complete
- Task Type Feature Request
- Category Backend/Core
- Assigned To No-one
- Operating System All
- Severity Low
- Priority Very Low
- Reported Version 1.0 alpha1
- Due in Version 1.1 devel
-
Due Date
Undecided
- Votes
- Private
Attached to Project: Flyspray - The bug killer!
Opened by peterdd - 18.07.2015
Last edited by peterdd - 20.07.2018
Opened by peterdd - 18.07.2015
Last edited by peterdd - 20.07.2018
FS#2011 - last modified table sorting
If you sort the task result list by last modified date, it ignores the tasks, that are new created, but not changed.
I think better is to sort by create date too when sorting by modifed date.
- Either we do it by a modified sql sorting rule using both date fields.
- Or we just save the the creation date also in the modified field on the creation, so this field is never empty or null. (this would be the easiest)
In the 2nd solution the upgrade sql script should write the task creation datetime to the modifed datetime field
Something like
UPDATE tasks SET modified=created WHERE modified='' or modified IS NULL