<html><body><div style="color:#000; background-color:#fff; 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; "><span><br></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; "> <div style="font-family: 'times new roman', 'new york', times, serif; "> <div dir="ltr" style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Winn Johnston <winn_johnston@yahoo.com><br> <b><span style="font-weight: bold;">To:</span></b> "rt-devel@lists.bestpractical.com" <rt-devel@lists.bestpractical.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, September 11, 2012 9:03 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><div id="yiv1093239463"><div><div style="background-color: rgb(255, 255, 255); font-family: 'times new roman', 'new york', times, serif; "><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span>All,</span></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; background-color: transparent; font-style: normal; "><span><br></span></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; background-color: transparent; font-style: normal; "><span>After following what Andy said, i put my query into the advanced query window. I ran it and it spit out this error</span></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times,
serif; font-size: 16px; background-color: transparent; font-style: normal; "><span><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; line-height: 16px; "> 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;'</span> <br></span></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; background-color: transparent; font-style: normal; " class="yui_3_2_0_19_134737931761483"><span><br></span></div><div style="background-color: transparent; " class="yui_3_2_0_19_134737931761483">Here is the original query. </div><div style="background-color: transparent; " class="yui_3_2_0_19_134737931761483"><blockquote type="cite"><div class="yui_3_2_0_19_1347379317614105"><div style="color: rgb(0, 0, 0);
font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; font-style: normal; ">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;</div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; font-style: normal; "><br></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; font-style: normal; background-color: transparent; ">Thanks again</div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px; font-style: normal; background-color: transparent; "><br></div><div style="background-color: transparent; ">winn Johnston </div></div></blockquote></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 16px;
background-color: transparent; font-style: normal; " class="yui_3_2_0_19_134737931761483"><br></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div> <div style="color: rgb(0, 0, 0); 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> Andy Jewell <Andy.Jewell@sysmicro.co.uk><br> <b><span style="font-weight:bold;">To:</span></b> Winn Johnston <winn_johnston@yahoo.com> <br> <b><span style="font-weight:bold;">Sent:</span></b> Thursday, September 6, 2012 2:09 PM<br> <b><span style="font-weight:bold;">Subject:</span></b> Re: [rt-devel] Trying to create a custom dashboard screen<br> </font> </div> <br><div id="yiv1093239463">
<div>
<div>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.</div>
<div><br>
<br>
Sent from my iPhone</div>
<div><br>
On 6 Sep 2012, at 22:01, "Winn Johnston" <<a rel="nofollow" ymailto="mailto:winn_johnston@yahoo.com" target="_blank" href="mailto:winn_johnston@yahoo.com">winn_johnston@yahoo.com</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">
<div>
<div style="font-size:12pt;">All,</div>
<div style="font-size:12pt;"><br>
</div>
<div style="background-color:transparent;">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.</div>
<div style="background-color:transparent;"><br>
</div>
<div style="background-color:transparent;">
<div style="background-color:transparent;">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;</div>
<div style="background-color:transparent;"><br>
</div>
<div style="background-color:transparent;">
<div style="background-color:transparent;">*************************** 1. row ***************************</div>
<div style="background-color:transparent;"> User: winnj</div>
<div style="background-color:transparent;">TotalClosedTix: 6</div>
<div style="background-color:transparent;">*************************** 2. row ***************************</div>
<div style="background-color:transparent;"> User: dennisc</div>
<div style="background-color:transparent;">TotalClosedTix: 3</div>
<div style="background-color:transparent;">*************************** 3. row ***************************</div>
<div style="background-color:transparent;"> User: royced</div>
<div style="background-color:transparent;">TotalClosedTix: 1</div>
<div style="background-color:transparent;">3 rows in set (0.00 sec)</div>
<div><br>
</div>
<div style="background-color:transparent;"><br>
</div>
<div style="background-color:transparent;">What should i be reading to make this happen?</div>
<div style="background-color:transparent;"><br>
</div>
<div style="background-color:transparent;">Thanks</div>
<div style="background-color:transparent;">Winn Johnston</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div><span>--------</span><br>
<span>List info: <a rel="nofollow" target="_blank" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel">
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel</a></span><br>
</div>
</blockquote>
</div>
</div><br><br> </div> </div> </div></div></div><br><br> </div> </div> </div></body></html>