[ILUG] Request Tracker

[Conor Daly]

On Mon, Jan 15, 2007 at 04:49:52PM +0000 or so it is rumoured hereabouts, 
Kevin Philp thought:
> I asked for ticketing system suggestions a few days ago and of those 
> suggested Request Tracker seems to fit the bill. However I can't work 
> out how to run a query along the lines of:
> 
> Total all the hours worked under the queue bugs.
> 
> Is their an aggregate function in the ticket SQL??

I don't know the details of the Request Tracker database but the generic
sql for such a query would be:

select bug_id, sum(time) from table
group by bug_id;

Conor
-- 
Conor Daly <conor.daly at cod.homelinux.org>
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCS/G/S/O d+(-) s:+ a+ C++(+) UL++++ US++ P>++ L+++>++++ E--- W++ !N
PS+ PE Y+ PGP? tv(-) b+++(+) G e+++(*) h-- r+++ z++++ 
------END GEEK CODE BLOCK------
http://www.geekcode.com/ http://www.ebb.org/ungeek/