[rt-users] Query / Report worked time

Mayk Backus backus at nlcom.nl
Wed Nov 23 10:42:48 EST 2011

Hi Ruslan,

the link to the wiki is :
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
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).



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

More information about the rt-users mailing list