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 ?
Thank you for your time.
Reagards,
Mayk
As a follow-up to myself, i’ve found something called…
Following the instructions, getting it to run on a 4.0.2 install , i
borks on the following… Can someone shed any light on this ?
Error during compilation of
/opt/rt4/local/html/Tools/Reports/TimeWorkedReport.html: syntax error at
/opt/rt4/local/html/Tools/Reports/TimeWorkedReport.html line 48, near
“)” BEGIN not safe after errors–compilation aborted at
/opt/rt4/local/html/Tools/Reports/TimeWorkedReport.html line 62. Stack:
[/opt/rt4/local/html/Tools/Reports/TimeWorkedReport.html:62]
[/usr/local/share/perl/5.10.1/HTML/Mason/Interp.pm:817]
[/usr/local/share/perl/5.10.1/HTML/Mason/Interp.pm:445]
[/usr/local/share/perl/5.10.1/HTML/Mason/Request.pm:249]
[/usr/local/share/perl/5.10.1/HTML/Mason/Request.pm:212]
[/opt/rt4/sbin/…/lib/RT/Interface/Web/Request.pm:62]
[/usr/local/share/perl/5.10.1/Class/Container.pm:275]
[/usr/local/share/perl/5.10.1/Class/Container.pm:353]
[/usr/local/share/perl/5.10.1/HTML/Mason/Interp.pm:348]
[/usr/local/share/perl/5.10.1/HTML/Mason/Interp.pm:342]
[/usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm:48]
[/usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler/Streamy.pm:52]
[/opt/rt4/sbin/…/lib/RT/Interface/Web/Handler.pm:258]
[/usr/local/share/perl/5.10.1/Plack/Util.pm:324]
[/usr/local/share/perl/5.10.1/Starlet/Server.pm:189]
[/usr/local/share/perl/5.10.1/Starlet/Server.pm:116]
[/usr/local/share/perl/5.10.1/Plack/Handler/Starlet.pm:59]
[/usr/local/share/perl/5.10.1/Plack/Loader.pm:87]
[/usr/local/share/perl/5.10.1/Plack/Runner.pm:263] [rt-server:231]
Thanks
reagards,
MaykOn 11/22/11 10:21 PM, Mayk Backus 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 ?Thank you for your time.
Reagards,
Mayk
RT Training Sessions (http://bestpractical.com/services/training.html)
- Barcelona, Spain November 28 & 29, 2011
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
Best regards, Ruslan.
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 ?
Thanx
Regards,
MaykOn 11/23/11 2:18 PM, Ruslan Zakirov wrote:
On Wed, Nov 23, 2011 at 1:21 AM, Mayk Backus backus@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
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
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.
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
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).
Regards
MaykOn 11/23/11 4:38 PM, Ruslan Zakirov wrote:
On Wed, Nov 23, 2011 at 5:24 PM, Mayk Backus backus@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@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
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
people).
It’s really easy to create an extension for RT. Developer installs
Module::Install::RTx and steals Makefile.PL from any extension (steal
from Руслан У. Закиров (RUZ) - metacpan.org).
Regards
Mayk
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
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.