[rt-devel] Trying to create a custom dashboard screen

Winn Johnston winn_johnston at yahoo.com
Thu Sep 6 17:01:28 EDT 2012


I am trying to create a top closers list on the default dashboard. I have the exact SQL statment i want to use, but i am lost after that.

select u.Name as User, count(1) as TotalClosedTix from Users u join Tickets t on u.id = t.owner where t.Status = "resolved" group by u.Name order by 2 desc limit 10 \G;

*************************** 1. row ***************************
          User: winnj
TotalClosedTix: 6
*************************** 2. row ***************************
          User: dennisc
TotalClosedTix: 3
*************************** 3. row ***************************
          User: royced
TotalClosedTix: 1
3 rows in set (0.00 sec)

What should i be reading to make this happen?

Winn Johnston
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-devel/attachments/20120906/da91e1b0/attachment.html>

More information about the rt-devel mailing list