Thank you Kenneth. That does help. The one thing I'm struggling with is the
Time Worked. I only want to see the Time Worked for that week. For example if
I have a ticket that has 40 hours of work over two weeks, I only want Time
Worked to reflect the time put in during the week the report co
pl remove us from yr mailing list
- Original Message -
From: Frankie Gibbs
To: rt-us...@bestpractical.com
Sent: Thursday, September 20, 2012 03:22
Subject: [rt-users] time worked report
I currently use the RT 3.8.7 and I need to automatically calculate the time
worked on
pl remove us from yr mailing list
- Original Message -
From: "Thomas Sibley"
To:
Sent: Thursday, September 20, 2012 03:50
Subject: Re: [rt-users] time worked report
On 09/19/2012 02:48 PM, Frankie Gibbs wrote:
I currently use the RT 3.8.7 and I need to automatically cal
Paul,
Like Thomas said, build the query you want and add the Timeworked column.
However, to make this a weekly report, you need to put it in a dashboard
set to run weekly. That would do it.
Hope this helps.
Kenn
On Wed, Sep 19, 2012 at 3:41 PM, Paul Muther wrote:
> Is there a way to do this e
Is there a way to do this easily to show time worked for a range of dates? For
example if I submit time for techs on a weekly basis showing the effort put
into each ticket? Currently I'm using a rather unreliable method of table
joins and a back end SQL query.
In almost all implementations
On 09/19/2012 02:48 PM, Frankie Gibbs wrote:
> I currently use the RT 3.8.7 and I need to automatically calculate the
> time worked on each ticket, is this possible?. how I can do to get that
> report?
Construct the search for the tickets you want using the Query Builder
and then add the TimeWorke
I currently use the RT 3.8.7 and I need to automatically calculate
the time worked on each ticket, is this possible?. how I can do to
get that report?
thanks
--
Final RT training for 2012 in Atlanta, GA - October 23 & 24
http://bestpracti
I currently use the RT 3.8.7 and I need to automatically calculate
the time worked on each ticket, is this possible?. how I can do to
get that report?
thanks
--
Final RT training for 2012 in Atlanta, GA - October 23 & 24
http://bestpracti
On Fri, Feb 10, 2012 at 10:25:51AM +0530, Pattabi Prasanna wrote:
> Hi
>
> I have installed RT 3.8.9 and when installing Time Worked Report
> it is showing this error. Kindly let me know how to solve this error.
>
>
> Error during compilation of
> /opt/rt3/local/html/Elements/SelectMultiQ
Hi
I have installed RT 3.8.9 and when installing Time Worked Report
it is showing this error. Kindly let me know how to solve this error.
Error during compilation of
/opt/rt3/local/html/Elements/SelectMultiQueue: Global symbol "$d"
requires explicit package name at
/opt/rt3/local/html/Ele
half Of *Kenneth Crocker
> *Sent:* quinta-feira, 31 de Março de 2011 18:35
>
> *To:* rt-users@lists.bestpractical.com
> *Subject:* Re: [rt-users] Time Worked Report
>
>
>
> Walid,
>
> In step 4, you don't mention editing the "Tabs" file with the changes
-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker
Sent: quinta-feira, 31 de Março de 2011 18:35
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Time Worked Report
Walid,
In step 4, you don't mention editing the
inally, I tried creating the *local* directory in /usr and the
> *rt3*directory within it (/usr/local/rt3). I then moved the entire
> *html *directory, created in 1. (above), to /usr/local/rt3. But again,
> after restarting httpd I could not see the Time Worked Report.
>
>
>
> Thanks in advance
-users@lists.bestpractical.com
Subject: Re: [rt-users] Time Worked Report
Opps, that was supposed to be /local/html/Tools/Report. Sorry.
Kenn
On Tue, Mar 29, 2011 at 8:39 AM, Kenneth Crocker
mailto:kfcroc...@lbl.gov>> wrote:
Walid,
Also, we used to have a different $home than /opt/rt3/ (in S
t;>>
>>>
>>> No, I do not. Should I go ahead and create it and then follow Kenn’s
>>> instructions?
>>>
>>>
>>>
>>>
>>>
>>> Regards,
>>>
>>> Walid
>>>
>>>
>>>
>
rt-users-boun...@lists.bestpractical.com [mailto:
>> rt-users-boun...@lists.bestpractical.com] *On Behalf Of *Johan Sjöberg
>> *Sent:* terça-feira, 29 de Março de 2011 14:56
>>
>> *To:* rt-users@lists.bestpractical.com
>> *Subject:* Re: [rt-users] Time Worked Report
*On Behalf Of *Walid Haider
> *Sent:* den 29 mars 2011 15:20
> *To:* Kenneth Crocker; rt-users@lists.bestpractical.com
> *Subject:* Re: [rt-users] Time Worked Report
>
>
>
> Kenn,
>
>
>
> Again, thanks for the reply. As I ran a packaged install of RT 3.8.4, my
users@lists.bestpractical.com
Subject: Re: [rt-users] Time Worked Report
Do you have a /usr/local/rt3?
/Johan
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Walid Haider
Sent: den 29 mars 2011 15:20
To: Kenneth Crocker; rt-
Do you have a /usr/local/rt3?
/Johan
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Walid Haider
Sent: den 29 mars 2011 15:20
To: Kenneth Crocker; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Time Worked Report
Kenn
/share/rt3.
Thanks,
Walid
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker
Sent: segunda-feira, 28 de Março de 2011 17:33
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Time Worked Report
Walid,
What I
On Thu, Mar 24, 2011 at 04:51:28PM +, Walid Haider wrote:
This implies that you have a syntax error in your copy and paste
>Error during compilation of /usr/share/rt3/html/Elements/SelectMultiQueue:
> Global symbol "$d"
>requires explicit package name at
> /usr/share/rt3/html/Elemen
Walid,
Did you copy the /share/... directories/files to .../local/.
directories/files and make your modifications there? That a WAY safer way to
make modifications. You may have forgotten one and that is the problem?
Kenn
LBNL
On Thu, Mar 24, 2011 at 9:51 AM, Walid Haider wrote:
> Hi,
Hi,
I am a bit of a newbie with RT, and was wondering if you could help me.
After following the installation your instructions at
http://requesttracker.wikia.com/wiki/TimeWorkedReport, I get the following
errors when clicking on the Time Worked Report link in RT:
Error during compilation of /u
Hi all,
i installed the Time Worked Report
(http://requesttracker.wikia.com/wiki/TimeWorkedReport) on our RT 3.8.7
and got Errors by opening the TimeWorkedReport.html from my RT:
Error during compilation of
/usr/share/request-tracker3.8/html/Elements/SelectMultiQueue: Global
symbol "$d" r
3, 2009 7:41 AM
To: Joel Hartshorn; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Time Worked Report
Fran Fabrizio and I whipped up a script that can take a date range, either
local time or UTC, and output a report on the command line. It's trivial to
wrap that to output html t
Fran Fabrizio and I whipped up a script that can take a date range, either
local time or UTC, and output a report on the command line. It¹s trivial to
wrap that to output html to a location in your local tree and have a daily
report with cron.
I believe I put it on the wiki, but will have to look
Did the thread on the Time Worked Report ever get resolved?
This is the thread started by Stephen Cochran. back in 3/09 or so'ish...
Joel Hartshorn
Internet Engineer/New Media
The Seattle Times Company
206 464 2323
nwsource.com | seattletimes.com
smime.p7s
Description: S/MIME cryptographic s
e.
>
>
>
> Stephen, dont forget to *reply to all* if you want the list to see your
> replies. (Which I think you do)
>
>
>
>
>
> *From:* Stephen Cochran [mailto:stephen.a.cochran.li...@cahir.net]
> *Sent:* 03 March 2009 15:33
>
> *To:* Alex Young
> *Subject
extension for this purpose,
> and most of the code and info must already be available in RT to do this.
>
>
>
>
>
>
>
> *From:* Stephen Cochran [mailto:stephen.a.cochran.li...@cahir.net]
> *Sent:* 03 March 2009 14:27
> *To:* Alex Young
> *Subject:* Re: [r
; *From:* Stephen Cochran [mailto:stephen.a.cochran.li...@cahir.net]
> *Sent:* 03 March 2009 14:27
> *To:* Alex Young
> *Subject:* Re: [rt-users] Time Worked Report
>
>
>
> Thinking through this, the only way to be completely accurate list of time
> spend in some given tim
time. Same for adding time.
Stephen, dont forget to reply to all if you want the list to see your
replies. (Which I think you do)
From: Stephen Cochran [mailto:stephen.a.cochran.li...@cahir.net]
Sent: 03 March 2009 15:33
To: Alex Young
Subject: Re: [rt-users] Time Worked Report
You
[mailto:stephen.a.cochran.li...@cahir.net]
Sent: 03 March 2009 14:27
To: Alex Young
Subject: Re: [rt-users] Time Worked Report
Thinking through this, the only way to be completely accurate list of
time spend in some given time_window would be the following (in psudo
sql):
# total time worked in
Just thought of another situation where it gets tricky...if the "Time
Worked" is input in the Basics of the ticket itself, it doesn't log in a
transaction either. So only looking in the Transactions would potentially be
missing something.
On Tue, Mar 3, 2009 at 12:01 AM, Stephen Cochran <
steph
ROUP BY Subject;
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Stephen
Cochran
Sent: 03 March 2009 05:01
To: rt Users
Subject: [rt-users] Time Worked Report
I've written a sql query to pull out the time worked for all tickets
resolved in th
I've written a sql query to pull out the time worked for all tickets
resolved in the last week among other things. The problem with this is that
it doesn't give a complete picture of time worked for any given week since a
ticket could have had time worked put in as part of a transaction but the
tic
Dear RT Users,
I am trying to find/create a report from RT that
outputs the total time recorded in RT across all queues for each user each day.
In other words, I would like to be able to produce a report that looks something like
this:
User1
20 September
2006
Ticket
#1223
36 matches
Mail list logo
