<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Ahh got it thanks, I don't know how i missed that reply.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal; "><span><br>Thanks again</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal; "><span>-winn</span></div><div><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Thomas Sibley <trs@bestpractical.com><br> <b><span
style="font-weight: bold;">To:</span></b> rt-devel@lists.bestpractical.com <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, September 11, 2012 10:17 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [rt-devel] Trying to create a custom dashboard screen<br> </font> </div> <br>On 09/11/2012 10:10 AM, Winn Johnston wrote:<br>> All,<br>> <br>> I just verified that i am using the patched 4.0.6 RT version.<br>> <br>> I have also verified that this bug fix was in<br>> Tree.pm <a href="https://github.com/bestpractical/rt/commit/a3b9b97" target="_blank">https://github.com/bestpractical/rt/commit/a3b9b97</a><br><br>This commit has nothing to do with your problem.<br><br>> Still getting the error " Wrong query, expecting a OPERATOR in ' select<br>>>u.Name<--here as User, count(1) as TotalClosedTix from Users u join<br>> Tickets t on u.id = t.owner where t.Status = "resolved" group by
u.Name<br>> order by 2 desc limit 10;' "<br>> <br>> When i create an advanced query like<br>> "select u.Name as User, count(1) as TotalClosedTix from Users u join<br>> Tickets t on u.id = t.owner where t.Status = "resolved" group by u.Name<br>> order by 2 desc limit 10;"<br><br>As I said in my original response<br><<a href="http://lists.bestpractical.com/pipermail/rt-users/2012-September/077837.html" target="_blank">http://lists.bestpractical.com/pipermail/rt-users/2012-September/077837.html</a>><br>you can't run raw SQL from RT. You only get to use TicketSQL.<br><br>My coworker Ruslan also offered you another suggested solution.<br><br><br>--------<br>Final RT training for 2012 in Atlanta, GA - October 23 & 24<br> <a href="http://bestpractical.com/training" target="_blank">http://bestpractical.com/training</a><br><br>We're hiring! <a href="http://bestpractical.com/jobs"
target="_blank">http://bestpractical.com/jobs</a><br><br><br> </div> </div> </div></body></html>