Me, I want to built a graphic dashboard for a BI App with the query results

2014-04-17 10:09 GMT-03:00 Florian Edlhuber <florian.edlhuber@gmx.de>:

Hi,

Perhaps I did not get it correctly, but why aren't you using the statistics module?

A open ticket monthly report is simple and can be displayed on the dashboard if you use
Firefox or chrome.

Florian

16.04.2014 15:40 - KalyanaChakravarthy MP schrieb:

Sql Query:
 
SELECT ticket.tn, ticket.id,ticket_history.state_id,ticket_state.name, max(ticket_history.change_time) AS change_time 
FROM ticket_history 
LEFT JOIN ticket ON (ticket.id = ticket_history.ticket_id) 
LEFT JOIN ticket_state ON (ticket_state.id = ticket_history.state_id)
 LEFT JOIN ticket_state_type ON (ticket_state_type.id = ticket_state.type_id)
 WHERE ticket_history.history_type_id = 27 AND 
ticket_state_type.name !="closed" 
GROUP BY ticket.tn;


At the moment it just groups the records and only gets the max date and not the row associated with the max date



Thank you & Regards,
Kalyana chakravarthy M .P,
Sr software Engineer
 

---------------------------------------------------------------------
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

--

André Luiz C. e Cavalcante

Coordenador de Eleições

TRE-BA / STI / COELE

---------------------------------------------------------------------
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