
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

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

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

Also http://forums.otterhub.org/viewtopic.php?f=60&t=17056
On Thu, Apr 17, 2014 at 9:48 AM, André Cavalcante
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
: 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
participants (4)
-
André Cavalcante
-
Florian Edlhuber
-
Gerald Young
-
KalyanaChakravarthy MP