<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812"></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Thats what I figured.</DIV>
<DIV> </DIV>
<DIV>Thanks!</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>
<DIV>Mike Johnson<BR>Datatel Programmer/Analyst<BR>Northern Ontario School of Medicine<BR>955 Oliver Road<BR>Thunder Bay, ON P7B 5E1<BR>Phone: 807.766.7331<BR>Email: <A href="mailto:mike.johnson@normed.ca">mike.johnson@normed.ca</A></DIV>
<DIV>Technology assistance: email <A href="mailto:nosmhelpdesk@normed.ca">nosmhelpdesk@normed.ca</A> <BR>Technology Emergency Contact (TEC) Mon-Fri, 8am to 5pm excluding stat holidays: <BR>Off campus toll free 1-800-461-8777, option 8, or locally either <BR>(705)-662-7120 or (807)-766-7500<BR></DIV><BR><BR>>>> Kevin Falcone <falcone@bestpractical.com> 01/10/2009 11:39 am >>><BR>On Thu, Oct 01, 2009 at 10:55:10AM -0400, Mike Johnson wrote:<BR>> I'm trying to find how to sort on 2 columns in Query Builder output.<BR>> <BR>> Is there a key word you can put in the TicketSQL to sort?<BR>> <BR>> Or is there some way to do this?<BR>> <BR>> we are using RT 3.2.1, does the newer version support multi-field sorting?<BR><BR>Take a look at the query builder on a 3.8 instance such as<BR><A href="http://rt3.fsck.com/Search/Build.html">http://rt3.fsck.com/Search/Build.html</A> (guest / guest)<BR>There are 4 sort columns available<BR><BR>-kevin<BR></DIV></BODY></HTML>