how to report all tickets closed in version....

[yoh...@gmail.com]

Hi all,

We use milestones and versions independently. We release "versions"
regularly. I am trying to wrap my head around how to find out what
tickets have been closed (or any other modification) in version X of
the software.

Assuming 1 of 2 options, with, or without subversion source conrtol,
what is the best way to go about keeping/reporting this information?

my thought was, any ticket that is in state closed, and the changetime
is between versinon x release date, and version y release date, was
fixed in version y. this is a critical distiction, since it could of
been created against version a, or b, or c.....x, but not fixed until
y.

This has few problems. It assumes that once the ticket is closed, it
is never updated, which is 99% of the time true, but once in a while,
a ticket is closed, and additional information is added to it.
addtionally, in my case, I would actually want tickets that are
closed, or in the custom state "resolved", since they might acutally
be verified in the next release (in this example y) which actually
closes them.

I also am not entirely sure how to get the release date from the
version in trac, but in psuedo-code, how would you get all tickets
where:
(date of transtion to 'resloved') or
(date of transition to 'closed') is greater than
release XXX date

where release XXX is a select field of the versions, or if need be, a
hand input date (or both?)

I am sure the information is hidden in there somewhere....just not
sure how to extract it, essentially to generate a "fixes in this
release" list

could be a plugin, a query, and sql report, an external script I run
manually and just paste into a wiki page, etc.

[yoh...@gmail.com]

OK, I have found out how to find all tickets that transitioned to
closed between certain dates here :
http://groups.google.com/group/trac-users/browse_thread/thread/c3452e8656af5988/ee2ce7d201f9253f?hl=en&lnk=gst&q=tickets+closed+in+version#ee2ce7d201f9253f

can anyone point me to how to get the "released data" from the version
id from trac, and insert into this script:

select id, type, summary, component, milestone, owner,

datetime((select max(tc.time) from ticket_change tc
where t.id = tc.ticket and field = 'status' and newvalue =
'closed'),
'unixepoch', 'localtime') as closedate,
(select max(tc.time) from ticket_change tc
where t.id = tc.ticket and field = 'status' and newvalue =
'closed')
as closetime
from ticket t
where status = 'closed'
and closetime > strftime('%s',datetime('2006-03-24 16:38:45')) +0
and closetime < strftime('%s',datetime('2006-04-06 15:25:34')) +0
AND type IN ('defect','enhancement')
order by -closetime

where the 2 datetime(....)s I would want to insert versionX.release
and versionY.release

This would be in the off-chance that the release date was entered
incorrectly for a version, therefore requiring one to re-edit these
queries with the correct dates, every time a release date changes. Or
when we just want a "LATEST" version, which is always changing and we
do between LASTEST.releasedate and NOW

guess it's time to snoop the trac db again.

Thanks in advance