Hm...I see...simple enough, I suppose. Two questions come to mind in light
of this info:
- would it be possible to reflect that so that it's easily viewable in the
web interface?
- to modify the time period I'm searching for, could I do something like
this tp get work units for March?
month(t.create_time) = '03'
Thanks very much for your input.
~Myles
On 3/20/07, Beugen, Peter van <[EMAIL PROTECTED]> wrote:
You can pretty easy create a query like:
SELECT
t.create_by,
u.first_name,
u.last_name,
Sum(t.time_unit)
FROM
time_accounting AS t
Left Join system_user AS u ON t.create_by = u.id WHERE
year(t.create_time) = '2006'
GROUP BY
t.create_by
It will give you userid, firtstname, lastname, total work-units In 2006
Regards,
Peter
*Van:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *Namens *Donald
Musser
*Verzonden:* dinsdag 20 maart 2007 22:50
*Aan:* [email protected]
*Onderwerp:* [otrs] Can I create stats for time units?
Hello everyone,
I've had a bit of exposure to OTRS, as my company has been using it as our
ticketing system for months now. We recently made the decision to start
recording work units, and I wanted to know if anyone knew of a way to
incorporate work units into the STATS objects. More specifically, I wanted
to get the work units (by minutes or hours) for a particular ticket queue
within a given time period. Any suggestions?
~Myles
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
