Hi
You can do something like:
SELECT t.id,t.summary,t.component,t.milestone FROM ticket AS t,ticket_change
AS tc
WHERE t.id=tc.ticket
AND field='status'
AND newvalue='closed'
AND strftime('%Y-%m-%d',datetime(tc.time, 'unixepoch'),'localtime') >=
datetime('$FROM','localtime')
AND strftime('%Y-%m-%d',datetime(tc.time, 'unixepoch'),'localtime') <
datetime('$TO','localtime')
Then pass the arguments TO and FROM by adding ?FROM=2007-10-01&TO=2007-11-01
to the end of the report url.
Also see: http://trac.edgewall.org/wiki/TracReports
Cheers / Erik
On Nov 28, 2007 6:30 PM, <[EMAIL PROTECTED]> wrote:
>
> Folks,
>
> I'm a bit new to the TRACS reporting and my SQL skills are non-
> existent. However I need to generate reports from tickets we put into
> TRACS.
>
> I want to create a report that will only give me closed tickets for a
> specified date range (typically, 1 month like you can do in the
> timeline view). It would also be nice (maybe as a seperate report) to
> collate closed tickets by component and a specified date range.
>
> Is this possible? Does anyone know how to do it?
>
> thanks
>
> Pat
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
