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

[Winn Johnston]

Ahh got it thanks, I don't know how i missed that reply.

Thanks again
-winn


________________________________
 From: Thomas Sibley <trs at bestpractical.com>
To: rt-devel at lists.bestpractical.com 
Sent: Tuesday, September 11, 2012 10:17 AM
Subject: Re: [rt-devel] Trying to create a custom dashboard screen
 
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.


--------
Final RT training for 2012 in Atlanta, GA - October 23 & 24
  http://bestpractical.com/training

We're hiring! http://bestpractical.com/jobs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-devel/attachments/20120911/ca611500/attachment.html>