<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I can't find my original messages (they may be on
the list archives) regarding SearchBuilder versions > 0.88 where my front
list of tickets would change order due to the addition of a DISTINCT in the
SELECT clause. MySQL returns the list in a 'nonsensical' order when the
order is set to 'priority' and all the ticket priorities are the same.
I've gotten around this by changing the order statement in
share/html/Elements/MyTickets</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>from</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>$MyTickets->OrderBy(FIELD => 'Priority',
ORDER => 'DESC');</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>to</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>$MyTickets->OrderByCols({FIELD => 'Priority',
ORDER =>
'DESC'},<BR>
{FIELD => 'id', ORDER => 'ASC'
});<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Other Elements need touching up as needed,
too.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> -=| Ben</FONT></DIV>
<DIV><FONT face=Arial size=2> </DIV></FONT></BODY></HTML>