[rt-users] Custom Ticket Status and Timing

[Kevin Falcone]

On Tue, Apr 02, 2013 at 01:17:33PM +0000, Mirko Spuntarelli wrote:
>    I am trying to set up Request Tracker 4 and I have customized with business hours, sla and
>    lifecycle. All I would you like to know if is it possibile to extract timestamp for my custom
>    ticket status when the status has changed from a condition to another? For example: report how
>    many hours the ticket as been in stall, or to store the date\time the ticket has been put in
>    stall and then when it has been reopened. Obviously in my case, the stall condition, is a
>    custom Ticket Status. The picture here attached will explain it better... highlighted you will
>    find date\time datas I need.

Those are Transactions of a Status type.  You can iterate them with
perl code (in fact, someone earlier today posted loops for looking
through transactions during a debugging session) or you can go in the
DB if that's easier to pull into an external reporting tool.

-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/20130402/2682648c/attachment.sig>