
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
participants (1)
-
Lars Jørgensen