[rt-devel] Time difference between certain transaction types

Bruce Campbell bruce_campbell at ripe.net
Mon Jun 2 07:45:56 EDT 2003


On Sun, 1 Jun 2003, Robert Spier wrote:

> rt-devel wrote:
> > for reporting I am trying to get time differences between certain
> > transaction types, e.g. I would like to know the time between "Take"
> > and "stalled" or "resolved". Right now, I do the following, but it
> > produces negative results, when a ticket is stalled first and taken
> > later. Maybe someone knows a solution that respects the order :-)
>
> You could keep a simple flag and not look for the $start time until
> after you've seen a Take

Or, simply use perl's abs() function to show the difference sans negative.

Of course, this may not be what you want, as a ticket could easily be
Created -> Stalled -> Taken -> Resolved -> Opened -> Taken -> Stalled ->
Opened -> Resolved, just to give an example.

-- 
                             Bruce Campbell                            RIPE
                   Systems/Network Engineer                             NCC
                 www.ripe.net - PGP562C8B1B             Operations/Security




More information about the Rt-devel mailing list