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

[Winn Johnston]

All,

After following what Andy said, i put my query into the advanced query window. I ran it and it spit out this error



________________________________
 From: Andy Jewell <Andy.Jewell at sysmicro.co.uk>
To: Winn Johnston <winn_johnston at yahoo.com> 
Sent: Thursday, September 6, 2012 2:09 PM
Subject: Re: [rt-devel] Trying to create a custom dashboard screen
 

The easiest way is to put your search into the normal ticket search 'advanced' tab and then save the search. It then appears as an option in your RT-at-a-glance prefs screen.


Sent from my iPhone

On 6 Sep 2012, at 22:01, "Winn Johnston" <winn_johnston at yahoo.com> wrote:


All,
>
>
>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?
>
>
>Thanks
>Winn Johnston
--------
>List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-devel/attachments/20120911/ca7567f2/attachment.html>