[otrs] SQL you use in reports

[Andreas.Plaul at jpn.tuv.com]

Dear Bas,

the only sophisticated SQL report sequence I have and use is:

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

This gives you the total time units for each user. 
I am very much interesting in using JasperReports with OTRS, but I have 
trouble to create useful template. The connection to the database is 
working, but I can't get
the templates to show the things I need (e.g. amount of request by 
customers or by customerID and so)

If somebody already has knowledge in this field, please share. I think 
many people want to expand the usage of the stats modul by using Jasper or 
other Reporting engines.

Best Regards,
Andreas Plaul





-- 
This message has been scanned for viruses and malicious content by 
TUV Rheinland Japan's perimeter scanner, and is believed to be clean. 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.otrs.org/pipermail/otrs/attachments/20070308/94699380/attachment.html