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
Hi,
SELECT SUM(TimeWorked) FROM Transactions WHERE ObjectId =
AND ObjectType = ‘RT::Ticket’ AND Created BETWEEN AND
;On Thu, Jan 6, 2011 at 1:45 AM, tarminuscf tarminuscf@gmail.com 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.
Doesn’t that miss if someone just changes the TimeWorked value on the Basic tab of the ticket?
I use (in MySQL SQL):
SUM(IF(Field = ‘TimeWorked’, NewValue - OldValue, TimeTaken)) as TimeWorked
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,
tarOn Wed, Jan 5, 2011 at 4:13 PM, Ruslan Zakirov ruz@bestpractical.comwrote:
Hi,
SELECT SUM(TimeWorked) FROM Transactions WHERE ObjectId =
AND ObjectType = ‘RT::Ticket’ AND Created BETWEEN AND
;
On Thu, Jan 6, 2011 at 1:45 AM, tarminuscf tarminuscf@gmail.com 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.