Is it possible to get search results with a sum of the TimeTaken values from the Transactions table?
Our internal developers need to fill out time sheets each week. At the moment this is labour intensive so I have been trying to work out a way to pull the time out of the tickets for the previous week. I thought I had it with the following: Search Query: Owner = '__CurrentUser__' AND Updated > '1 week ago' AND TimeWorked > 1 Results format: '<a href="/rt/Ticket/Display.html?id=__id__">__id__</a>/TITLE:#', '<a href="/rt/Ticket/Display.html?id=__id__">__Subject__</a>/TITLE:Subject', '__Priority__', '__QueueName__', '__ExtendedStatus__', '__TimeWorked__', '__TimeEstimated__' This returns all tickets that have been worked on the last week, but shows the total time ever worked on the ticket, which isn't any good. I see the transactions table contains a TimeTaken value. The ideal solution would be to add up all the TimeTaken values from the last 7 days and display them in the search results. I thought maybe I could have modified the http://wiki.bestpractical.com/view/TimeWorked code, but the date part of that didn't, and I have been unable to get it to work. It just returns all results from every queue. Any pointers? After spending the last week working on RT and reading the wiki and mailing lists I am stuck. Thanks, Alex
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com