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

[Winn Johnston]

________________________________
 From: Winn Johnston <winn_johnston at yahoo.com>
To: "rt-devel at lists.bestpractical.com" <rt-devel at lists.bestpractical.com> 
Sent: Tuesday, September 11, 2012 9:03 AM
Subject: Re: [rt-devel] Trying to create a custom dashboard screen
 

All,

After following what Andy said, i put my query into the advanced query window. I ran it and it spit out this error
 Wrong query, expecting a OPERATOR in ' select >u.Name<--here 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;' 


Here is the original query. 
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;
>
>
>Thanks again
>
>
>winn Johnston 



________________________________
 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/57a052d2/attachment.html>