RT::Extension::ElapsedBusinessTime(3pm) User Contributed Perl Documentation RT::Extension::ElapsedBusinessTime(3pm)

RT-Extension-ElapsedBusinessTime - Calculate the elapsed business time that tickets are open

This extension provides for new colummns in reports that display the elapsed business time that a ticket has been open. Various items are configurable to define what constitutes a business day.

Works with RT 4.4.x and RT 5.0.x.

"perl Makefile.PL"
"make"
"make install"
May need root permissions
Add this line: 

    Plugin('RT::Extension::ElapsedBusinessTime');
    
    rm -rf /opt/rt4/var/mason_data/obj

The available configuration options, with their defaults are given here.

    Set( %ElapsedBusinessTime,
        Start   => '08:30',
        End     => '17:30',
        Country => undef,
        Region  => undef,
        'Exclude Days'   => [6, 7],
        'Exclude States' => ['stalled', 'blocked', 'resolved', 'rejected', 'deleted'],
    );

Options are:

The start of the business day.
The end of the business day.
A country for which there is a Date::Holidays module which describes the holidays for that country. If there isn't one, please consider writing one! For example 'NZ' for New Zealand.
Some country modules for Date::Holidays include regions for regional holidays. For example 'Wellington' within New Zealand for Wellington Anniversary Day.
Days which should not be considered working days. The day numbers are from DateTime. For reference they are: 

    1: Monday
    2: Tuesday
    3: Wednesday
    4: Thursday
    5: Friday
    6: Saturday
    7: Sunday
Which a ticket is in one of these states, then it is considered inactive and the counter stops. This is to allow when a ticket is waiting on a customers feedback, and for some businesses, that time shouldn't be added to their ticket duration time.

There are three display columns which this extension adds, which all show the same information, just in different formats:

Andrew Ruthven, Catalyst Cloud Ltd <puck@catalystcloud.nz>

This software is Copyright (c) 2019-2020 by Catalyst Cloud Ltd

This is free software, licensed under:

  The GNU General Public License, Version 2, June 1991
2023-09-26 perl v5.36.0