Advanced Query: Total of Time Worked

Hi all,

When running an advanced query, I can add the “time worked” column.
In advanced, I use:

Status = ‘resolved’ AND Queue = ‘Help’ AND TimeWorked > 1

id/TITLE:#’,
Subject/TITLE:Subject’,
Status’,
QueueName’,
OwnerName’,
’’,
Requestors’,
CreatedRelative’,
TimeWorked

Is there a query keyword that would give a total or would this require a
template patch?
tia, Ian

When running an advanced query, I can add the “time worked” column.
In advanced, I use:

Status = ‘resolved’ AND Queue = ‘Help’ AND TimeWorked > 1

id/TITLE:#’,
Subject/TITLE:Subject’,
Status’,
QueueName’,
OwnerName’,
’’,
Requestors’,
CreatedRelative’,
TimeWorked

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. :slight_smile:

Cheers,
– jra
Jay R. Ashworth jra@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