Re: [otrs] Reporting Work Units

2007/1/10, Beugen, Peter van :

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 valkaij@externet.hu jvalkai@gmail.com lat:N 47° lon:E 19°