Edgewall Software

Opened 11 years ago

Last modified 6 months ago

#8728 new enhancement

add Closed Date to list of columns offered in custom query

Reported by: jhn@… Owned by:
Priority: normal Milestone: next-major-releases
Component: query system Version:
Severity: normal Keywords:
Cc: jhn@…, Ryan J Ollos, torsten.piotraschke@… Branch:
Release Notes:
API Changes:
Internal Changes:


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.

Attachments (0)

Change History (17)

comment:1 by Remy Blank, 11 years ago

Milestone: 0.13

Sounds like a good idea.

comment:2 by Remy Blank, 11 years ago

Milestone: 0.131.0

Wrong milestone, sorry.

comment:3 by anonymous, 10 years ago

I'd love to see this too. We've got very similar requirements to the requestor.

comment:4 by Christian Boos, 10 years ago

Milestone: 1.0unscheduled

Milestone 1.0 deleted

comment:5 by Remy Blank, 10 years ago

Milestone: triagingnext-major-0.1X
Owner: set to Remy Blank

Related to #8371, which suggests a filter for the last updater.

comment:6 by Remy Blank, 8 years ago

Owner: Remy Blank removed


comment:7 by anonymous, 6 years ago

I have to report that this missing features is the main reason I am looking for an alternative solution to Trac. We really like using Trac otherwise.

When managing projects with different builds going to different customers, or using multiple milestones for each (Agile), one needs to be able to quickly assess the changes from different Milestones that went into the current release. The only way I have found is using "Last Modified date". However, this is not equivalent to closed (for many people I guess). We put validation results in tickets, and other sorts of information, after the ticket is closed. Without being able to search on the closed date, it takes a day worth of sorting through tickets to get the proper list to report to customers. I've added a changeset closed on field, but that isn't automatic like a date would be.

comment:8 by Ryan J Ollos, 6 years ago

Cc: Ryan J Ollos added

comment:9 by rpshaw@…, 4 years ago

I would like to see this added to Trac as well. Getting the date closed from the custom query would allow me to much more easily calculate ticket life and generate other reports.

comment:10 by Andrew Kindred, 3 years ago

Just to add another name to the request for this. I too would love to have a Closed Date for the custom query. It would be extremely useful so please add this in ASAP.

comment:11 by richard.mair@…, 3 years ago

Another request for that feature. We really need that heavily….

comment:12 by torsten <torsten.piotraschke@…>, 3 years ago

We need this, too.

comment:13 by torsten <torsten.piotraschke@…>, 3 years ago

Cc: torsten.piotraschke@… added

comment:14 by john.ferg@…, 3 years ago


comment:15 by Marco A., 15 months ago

We too would like to see this feature; it would be a great help in easily summarising metrics for our internal configuration management standards.

comment:16 by Jun Omae, 15 months ago

Component: report systemquery system
Version: none

comment:17 by jtorres, 6 months ago

This would be useful to have

Modify Ticket

Change Properties
Set your email in Preferences
as new The ticket will remain with no owner.
The ticket will be disowned.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.