[rt-users] Custom SQL

Ruslan Zakirov ruz at bestpractical.com
Sat Sep 8 05:11:23 EDT 2012


Hi,

Take a look at SummaryByUser extension. It shows only active statuses,
but it's possible to change statuses.

On Thu, Sep 6, 2012 at 6:54 PM, 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)
>
>
> Can someone please help?
>
> Thanks
> Winn Johnston
>



-- 
Best regards, Ruslan.



More information about the rt-users mailing list