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.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
