Also http://forums.otterhub.org/viewtopic.php?f=60&t=17056
On Thu, Apr 17, 2014 at 9:48 AM, André Cavalcante <treba.an...@gmail.com>wrote: > 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.edlhu...@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 >
--------------------------------------------------------------------- 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