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’,
‘’,
‘Requestors’,
‘CreatedRelative’,
‘ToldRelative’,
‘LastUpdatedRelative’,
‘Product’,
‘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