Hi, guys!
I just create my personal report (by date). I read this tutorial for SQLite3 (
http://freshmeat.net/articles/view/1428/) to customize the trac report.
Well, some of then was built ok althought other one no, but I find
the way how I could do that.
Thx all , thanks Johannes!
Adriano Vieira
PS: It's here one of my own report. This one group tickets by type
from one day before current day):
===========================================================
SELECT p.value AS __color__,
t.type AS __group__, id AS ticket,t.priority, summary, component,
version, milestone,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
datetime(t.time, 'unixepoch', 'localtime') AS Created,
changetime AS _changetime, description AS _description,
reporter AS _reporter
FROM ticket t, enum p
WHERE status IN ('closed') AND
p.name = t.priority AND p.type = 'priority' AND
strftime("%m-%d-%Y",datetime(t.time, 'unixepoch'),'localtime') =
strftime("%m-%d-%Y",datetime('now','-1 days'),'localtime')
ORDER BY t.type, p.value, milestone, time
===========================================================
On 8/30/07, jtuchscherer <[EMAIL PROTECTED]> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
