[rt-users] Query / Report worked time

[Ruslan Zakirov]

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
>



-- 
Best regards, Ruslan.