[rt-users] Query / Report worked time

Mayk Backus backus at nlcom.nl
Wed Nov 23 08:24:54 EST 2011

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 ?




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

More information about the rt-users mailing list