Hi,
I wondered, whether there's an easy way to create following report
without writing python code.
I wanted create a table, which reports for each day the number of
new, closed (and modified) tickets.
I can create one or the other, but not both in one shot.
I am not really used to sql, so my queries might be a little awkward:
Listing all new tickets per day should work with:
SELECT
date(t.time,'unixepoch') as dt,
count(date(t.time,'unixepoch')) as new
FROM ticket as t
GROUP by dt
ORDER BY dt
Listing all closed tickets per day would be
SELECT
ticket,
date(c.time,'unixepoch') as dc,
count(newvalue = 'closed') as closed
FROM ticket_change as c
where field = 'status'
group by dc
ORDER BY dc
I have problems joining both
Do you have any ideas?
thanks a lot in advance and by
Klaus
--
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.
