Minor correction:
On Mar 4, 10:25 am, klausfpga <[email protected]> wrote:
> 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
corrected version for closed tickets per day:
SELECT
date(c.time,'unixepoch') as dc,
count(newvalue = 'closed') as closed
FROM ticket_change as c
where field = 'status' and newvalue = 'closed'
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.
