2007/1/10, Beugen, Peter van <[EMAIL PROTECTED]>:
Do you use MySQL? Runs perfectly on my OTRS MySQL 5 database....
But you can change the where clause to your needs and database...
Regards,
Peter van Beugen
Here is the postgresql query:
SELECT
t.create_by,
u.first_name,
u.last_name,
Sum(t.time_unit) as stime
FROM
time_accounting AS t
Left Join system_user AS u ON t.create_by = u.id
WHERE
date_part('YEAR'::text, t.create_time::timestamp) = '2006'
GROUP BY
t.create_by, u.first_name, u.last_name
--
Valkai Jozsef
+36 70 36 28 147
[EMAIL PROTECTED]
[EMAIL PROTECTED]
lat:N 47°
lon:E 19°
_______________________________________________
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/
