Hi there, Here is a report that shows you all the tickets modified in the last seven days. I got it myself here from the list. This only works in MySQL. You probably would need to change something to the timestamp function.
select t.id as id, t.summary as title, t.reporter, t.owner, t.time as created, t.changetime as modified from ticket t where unix_timestamp(DATE_SUB(CURDATE(),INTERVAL 7 DAY)) <= t.changetime order by t.changetime DESC; HTH Johannes On Aug 30, 5:24 am, "Hapia IN" <[EMAIL PROTECTED]> wrote: > Hi, gays! > > I need to build ticket reports, some of them as follow: > > - tickets by date (e.g. select * from ticket where time between > 08-01-2007 and 08-31-2007) > > - Dynamic reports by date (e.g: select * from ticket where time = > 'yesterday'). It's great if I could make one like this ;) > > How could I do those kind of report? > > Thanks a lot in advance > > Adriano Vieira --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
