[rt-users] Query / Report worked time

Ruslan Zakirov ruz at bestpractical.com
Wed Nov 23 12:24:11 EST 2011

On Wed, Nov 23, 2011 at 7:42 PM, Mayk Backus <backus at nlcom.nl> wrote:
> Hi Ruslan,
> the link to the wiki is :
> http://requesttracker.wikia.com/wiki/TimeWorkedReport
> A coworker of mine, who is a coder, fixed the code, only the integration
> in the menu still doesn't work (perhaps due to 3.8 code?). I will create

Yes. Menu subsystem have been changed in RT4. Take a look at some
extension that have been ported over RT4. Actually the wiki page has
hints about the menu.

> a wiki login to share the changes, it was an issue with quotes i
> learned. We are also changing the script to have some extra output.
> We are still noobs in RT, what's the best way to share modifications ?
> We have some modifications in place to let RT better integrate in i-doit
> (cmdb and documentation software).

Syntax errors should be fixed. If you update with new functionality
then either wrap it as an extension or replace code on the page (if
old functionality is kept and new is generic enough to be used by many

It's really easy to create an extension for RT. Developer installs
Module::Install::RTx and steals Makefile.PL from any extension (steal
from http://search.cpan.org/~ruz/).

> Regards
> Mayk
> On 11/23/11 4:38 PM, Ruslan Zakirov wrote:
>> On Wed, Nov 23, 2011 at 5:24 PM, Mayk Backus <backus at nlcom.nl> wrote:
>>> Hi Ruslan,
>>> thanx for the reply.  I've looked at the database, and it has a table
>>> called transactions. It contains the needed info, so my gues is it can
>>> be done with a script that gets the data straight from the sql. Not
>>> pretty, but could work. I'm more interested in a nice module/extension
>>> that can provide me with the info. At the moment we are looking into the
>>> ActivityReports and the TimeWorked .
>>> The timeworked on the wikia has instructions for RT 4 , but in another
>>> reply you note it contains 3.8 code. Is the information on the wikia
>>> incorrect then ?
>> Give me a link to check those instructions. Tools/Reports dir doesn't
>> exist in RT4. I assumed that that file you have in local comes from
>> your 3.8 installation. If it's something from the wiki then it's
>> possible that it was ported over RT4. You have syntax error in the
>> file, so it can be copy&paste error.
>>> Thanx
>>> Regards,
>>> Mayk
>>> On 11/23/11 2:18 PM, Ruslan Zakirov wrote:
>>>> On Wed, Nov 23, 2011 at 1:21 AM, Mayk Backus <backus at nlcom.nl> wrote:
>>>>> Hi List,
>>>>> Is there a way to get a report timeworked a little detailed ?
>>>>> For example, show me all tickets that have been worked on today, and
>>>>> show the time worked on the tickets today, so not the total worked time
>>>>> on a ticket. We have tickets that span a couple of days, so i'm
>>>>> interested in reporting today's worked time.
>>>>> Can this be done with a query ?
>>>> You probably need a new column, TimeWorkedToday, and a custom code in
>>>> tickets' column map to implement it.
>>>>> Thank you for your time.
>>>>> Reagards,
>>>>> Mayk
>>>>> --------
>>>>> RT Training Sessions (http://bestpractical.com/services/training.html)
>>>>> *  Barcelona, Spain  November 28 & 29, 2011
>>> --------
>>> RT Training Sessions (http://bestpractical.com/services/training.html)
>>> *  Barcelona, Spain  November 28 & 29, 2011
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> *  Barcelona, Spain  November 28 & 29, 2011

Best regards, Ruslan.

More information about the rt-users mailing list