Ticket Hash: | d0e0bc0da5dc63187fc64643ff1ce391a02e6237 | |||
Title: | add ticket created time | |||
Status: | Open | Type: | Feature_Request | |
Severity: | Minor | Priority: | ||
Subsystem: | Resolution: | Works_As_Designed | ||
Last Modified: | 2009-12-31 21:15:45 | |||
Version Found In: | ||||
Description: | ||||
ticket schema has tkt_mtime but there is no column which saves the creation time. this would be useful for ordering tickets by open time or by time since last edited. this might be possible using the current ticket configuration but I think it is more appropriate to have a tkt_ctime column that is managed automatically.
anonymous claiming to be Kees Nuyt added on 2008-11-27 23:09:31: (*) I seem to have read the current status is obtained by replaying all ticket updates in chronological order, where the newer value replaces an old one, and comments are appended to form the text blocks at the bottom of the ticket detail page. jeremy_c added on 2009-12-31 03:57:22: create_date datetime default CURRENT_TIMESTAMP jeremy_c added on 2009-12-31 04:26:49: rwilson added on 2009-12-31 19:42:25: i'm not sure that the OP's request can be resolved without writing some fossil code. i'm going to try a few more things with the ui to see if i can get the desired result, but i don't have any more time today. jeremy_c added on 2009-12-31 21:15:45: Add to your database schema something like: create_date TEXT Then in your New Ticket template, add something like: <th1> if {[info exists submit]} { set create_date [date] submit_ticket } </th1> You likely already have the above if statement and only need to add the set create_date part. You can then display the create date in your View template. Sorry for the bum fix to start with. I made a simple test case and didn't test editing. |