[rt-users] tracking time from Created to Opened / "Given to"

Dave Dennis dmd at speakeasy.org
Tue Aug 17 12:44:42 EDT 2004

Attempting to come up with query logic that tells me

Time between Created and "Opened and Assigned to Someone"

Need to find the table vars for the entry in the ticket history that is

Fri Jul 30 05:36:04 2004  	fred - Given to bob

For created I know its Tickets.Created or
TIME_FORMAT(SEC_TO_TIME(Tickets.Created))) ... What is it for this entry
when the ticket is opened and Given to someone?

Is that the same as Tickets.Started ?


+ Dave Dennis
+ Seattle, WA
+ dmd at speakeasy.org
+ http://www.dmdennis.com

More information about the rt-users mailing list