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 -----Oorspronkelijk bericht----- Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Jozsef Valkai Verzonden: woensdag 10 januari 2007 13:55 Aan: User questions and discussions about OTRS.org Onderwerp: Re: [otrs] Reporting Work Units
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
Error: ERROR: function year(timestamp without time zone) does not exist -- Valkai Jozsef +36 70 36 28 147 valkaij@externet.hu jvalkai@gmail.com 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/