[rt-users] time worked - within a certain time period

[Ruslan Zakirov]

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 <tarminuscf at 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.