[ILUG] Request Tracker

[David Golden]

On Monday 15 January 2007 16:49, Kevin Philp wrote:
> 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??
>

Umph. I dunno.  I'd tend to just run a SQL select on the underlying DB
for that sort of rollup info - RT's schema is kept pretty 
straightforward.

i.e. in, say, psql (I have no idea where one would put it into the web 
gui, worst case you'd have to make an extra page that runs the query I 
guess):

select sum(timeworked) from tickets join queues on 
tickets.queue=queues.id where queues.name='Bugs';

... or something like that. Wrapping that in a web page query and adding 
it to a "Rollup" view in RT's interface 'manually' would be another 
matter, but if you contact the rt-users mailing list they might have 
better suggestions anyway.