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

[Andy Lee]

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 <ruz at bestpractical.com>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 <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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110105/6498240b/attachment.htm>