[rt-users] Query Builder - Need to know whenever a ticket has been updated, commented, or resolved, in sense a COUNT.

cavemancanada martin.salovsky at gmail.com
Mon Aug 25 10:53:54 EDT 2008


Is there a way, and what would the syntax be to build a query that will
output how many times a particular ticket was updated, commented, and or
resolved? In a sense to find out how many comments were added to a
particular ticket.

Here is a sample query I was running in order to gather the number of
tickets that were opened in particular queues, with certain custom fields
(product and severity).

-----------------------------------------------
 (  Created > '2008-08-01' AND Created < '2008-08-22' )  AND  (  Queue =
'Support Level 0'  ) AND  (  'CF.{Product}' IS 'NULL' OR 'CF.{Severity}' IS
'NULL' )

'    /Ticket/Display.html?id=__id__ __id__ /TITLE:#',
' /Ticket/Display.html?id=__id__ __Subject__ /TITLE:Subject',
'__Status__',
'__QueueName__',
'__OwnerName__',
'__Product__',
'__NEWLINE__',
'',
'<small>__Requestors__</small>',
'<small>__CreatedRelative__</small>',
'<small>__ToldRelative__</small>',
'<small>__LastUpdatedRelative__</small>',
'<small>__Product__</small>',
'__CustomField.{Product}__',
'__CustomField.{Severity}__'
-----------------------------------------------
-- 
View this message in context: http://www.nabble.com/Query-Builder---Need-to-know-whenever-a-ticket-has-been-updated%2C-commented%2C-or-resolved%2C-in-sense-a-COUNT.-tp19117898p19117898.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.




More information about the rt-users mailing list