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 Daly <conor.daly at cod.homelinux.org>
-----BEGIN GEEK CODE BLOCK-----
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------
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!