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 < stephen.a.cochran.li...@cahir.net> wrote: > > 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 > ticket might still be open. I could query the Transactions table for the > TimeTaken field, but that could lead to double-counting if any of those > transactions are part of a resolved ticket. > > I know I could work through the db/sql and find the right query to pull out > the time worked in the last week, but I'm wondering if someone else has > already done it so I can save myself the trouble. > > Thanks, > Steve >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
