add Closed Date to list of columns offered in custom query
|Reported by:||Owned by:|
|Cc:||jhn@…, Ryan J Ollos, torsten.piotraschke@…||Branch:|
the Created and Modified columns are already offered by TracQuery. it would be very useful to also be able to add the Closed date to a report.
note that the Closed date on a ticket is not the same as the Last Modified date on a closed ticket. there may be follow-up communications long after a ticket has already been closed.
we often get requests from upper management or from clients for reports such as how many tickets were closed in a particular month. it is extremely tedious to search all closed tickets that were modified during or after that time, and then see when the ticket was actually closed.
another use of the Closed date column would be to run metrics such as average length of time that a ticket was open. if this column was available, it would take a quick export to excel and some simple calculations.
this data would be accessible with custom sql but i think there are enough common use cases that it would be worthwhile to make it part of the default package. i recall seeing many tickets related to custom date reports and this enhancement might provide enough for a lot of people.
it may not be that simple since i see in TracReports that the time and changetime columns live on the ticket table, but not the closed time. but the TracTimeline does show when tickets are closed, so hopefully that means it wouldn't be too hard to get at the data.