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 Mayk On 11/23/11 4:38 PM, Ruslan Zakirov wrote: > On Wed, Nov 23, 2011 at 5:24 PM, Mayk Backus <[email protected]> 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 <[email protected]> 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 >> > > -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 & 29, 2011
