Hi. Our supervisor is responsible for assigning tickets to agents. She would like to see a quick overview of how many tickets are currently assigned to each agent. I have enabled StatusView but that doesn't really give her the overview she needs.
I looked a little at the database backend and constructed a query that will give me the correct information: select system_user.login as agent, count(ticket.user_id) as tickets from ticket left join system_user on ticket.user_id=system_user.id group by ticket.user_id; +-------+---------+ | agent | tickets | +-------+---------+ | Adam | 5 | | Eve | 1 | +-------+---------+ 2 rows in set (0.00 sec) Now, how do I create a button in the navbar to run this query on the database and present the results to the supervisor? -- Lars Jørgensen Netværksadministrator Gyldendal A/S Tlf. 33 75 57 95 _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
