Thanks Ruslan/Stuart, I haven't given your query a shot but I believe i've found a solution that was already developed by Fran F. :
http://requesttracker.wikia.com/wiki/TimeWorkedReport Thanks all! Regards, tar On Wed, Jan 5, 2011 at 4:13 PM, Ruslan Zakirov <[email protected]>wrote: > Hi, > > SELECT SUM(TimeWorked) FROM Transactions WHERE ObjectId = <ticket id> > AND ObjectType = 'RT::Ticket' AND Created BETWEEN <start date> AND > <end date>; > > On Thu, Jan 6, 2011 at 1:45 AM, tarminuscf <[email protected]> wrote: > > > > Hi All, > > > > If I have a ticket that is 1 month old. How can I get the value of time > > worked tallied up for only the last 7 days the ticket was worked on? > > > > So if the ticket has a grand total of 200 minutes on the 1 month old > ticket. > > But the last 7 days only have a cumulative 60 minutes worked. The value > > I would be looking for is that 60 minutes. > > > > Anyone have insights on how I can get that value by means of RT reporting > > or direct DB query? > > > > thanks, > > tar > > -- > > View this message in context: > http://old.nabble.com/time-worked---within-a-certain-time-period-tp30600856p30600856.html > > Sent from the Request Tracker - User mailing list archive at Nabble.com. > > > > > > > > -- > Best regards, Ruslan. >
