[rt-users] Time until first take
docana at ebi.ac.uk
Mon Jun 8 07:13:00 EDT 2015
I'm trying to get a report of the average time for the first owner
change transaction in a ticket. Is there a way of achieving this using
TicketSQL or would I have to use something external to RT to make a
query to the database directly?
My idea is to grab all the 'owner change' type of transactions for a
ticket keeping just the first one, and calculate the difference between
this event and the 'created' time for the ticket.
Does this make any sense?
More information about the rt-users