[rt-users] SLA Extension config problems while manipulating due date

[Kevin Falcone]

On Fri, Feb 28, 2014 at 09:36:24AM +0100, Pablo Fernandez wrote:
>    The Reponse type is nice and dynamic... but the Resolve type is very static: either the ticket
>    original due date, or nothing.
>    It would be ideal to make it $ticket->CreatedObj->Unix + TIME_SPENT_IN_IGNORED_STATES.
> 
>    Is there a way we can query how much time did a ticket spend in one state?
>    (this is probably a question for the rt-devel list, I will subscribe if needed)

That information is in the transaction table, you would have to walk
$Ticket->Transactions looking for Status changes in and out of the ignored states and 
calculating.  Obviously this could be expensive, so some form of
caching is more common (but this would require either an Attribute or
another Custom Field).

In theory, it sounds like a nice feature, but I worry at the
implementation.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140303/f135816b/attachment.sig>