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