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