[rt-users] Newer SearchBuilders & sort order - FYI

[Ben Goodwin]

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

from

$MyTickets->OrderBy(FIELD => 'Priority', ORDER => 'DESC');

to

$MyTickets->OrderByCols({FIELD => 'Priority', ORDER => 'DESC'},
                        {FIELD => 'id',       ORDER => 'ASC' });

Other Elements need touching up as needed, too.

    -=| Ben
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040106/e135a09f/attachment.htm>