View Ticket
Not logged in
Ticket UUID: d0e0bc0da5dc63187fc64643ff1ce391a02e6237
Title: add ticket created time
Status: Open Type: Feature_Request
Severity: Minor Priority:
Subsystem: Resolution: Open
Last Modified: 2008-11-27 23:09:31
Version Found In:
Description & Comments:
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:
Initially I agreed, but considering that tickets are stored with full history (*), and there is a history button, there is no real need for a tkt_ctime column. If you really want one: you can change the ticket table to your liking in Setup, and use any columns in ticket reports.

(*) 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.