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

[Thomas Sibley]

On 09/11/2012 10:10 AM, Winn Johnston wrote:
> All,
> 
> I just verified that i am using the patched 4.0.6 RT version.
> 
> I have also verified that this bug fix was in
> Tree.pm https://github.com/bestpractical/rt/commit/a3b9b97

This commit has nothing to do with your problem.

> Still getting the 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;' "
> 
> When i create an advanced query like
> "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;"

As I said in my original response
<http://lists.bestpractical.com/pipermail/rt-users/2012-September/077837.html>
you can't run raw SQL from RT.  You only get to use TicketSQL.

My coworker Ruslan also offered you another suggested solution.