[rt-users] Advanced Query: Total of Time Worked

Jay R. Ashworth jra at baylink.com
Mon Mar 21 19:59:57 EST 2005


On Tue, Mar 22, 2005 at 11:16:59AM +1100, CyberPro Support wrote:
> When running an advanced query, I can add the "time worked" column.
> In advanced, I use:
> 
> Status = 'resolved'  AND Queue = 'Help'  AND TimeWorked > 1
> 
> '   <b><a href="/Ticket/Display.html?id=__id__">__id__</a></b>/TITLE:#',
> '<b><a 
> href="/Ticket/Display.html?id=__id__">__Subject__</a></b>/TITLE:Subject',
> '__Status__',
> '__QueueName__',
> '__OwnerName__',
> '',
> '<small>__Requestors__</small>',
> '<small>__CreatedRelative__</small>',
> '<small>__TimeWorked__</small>'
> 
> Is there a query keyword that would give a total or would this require a 
> template patch?

In SQL, to get totals, you typically run a second query, using
aggregate functions in your 'SELECT what' section.  This is why report
writers exist.  :-)

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system adminstrator.  Or two.  --me



More information about the rt-users mailing list