[rt-users] [bug report] sorting on owner not working as expected

[Grant Miller]

Bug Report:
------------------------------

Behaivor Expected:   sorting tickets by Owner should present a alphabetically
                     ordered list.
Behaivor Observed:   when sorting tickets by Owner, they are sorted by the
                     numeric id of that owner in the Users table.
Versions:	     fresh install of RT 2.0.15, Apache 1.3.26, Perl 5.6.1, 
                     mod_perl 1.27, Debian 3.0, MySQL 3.23.49.


Steps to reproduce problem:
----------------------------------

Fresh install of RT,
Create 4 users in this order: george, karl, charles, mark.
Set the users up with regular permissions to create and own tickets in the 
general queue.
Log in to RT with each account (in non-alphabetical order) and create one 
ticket as each user.
Go to the Search page, setup the search criteria with Queue = general and
sort on Owner with order ascending.
You should see the tickets ordered with george's ticket first, then karl's,
then charles's, then mark's.
Redo the search with the order descending and you'll see the list reversed.

It is clearly ordering the list by the id of the owner, not the Name.

mysql> select id,Name,RealName from Users;
+----+-----------+----------------------+
| id | Name      | RealName             |
+----+-----------+----------------------+
|  1 | RT_System | The RT System itself |
|  2 | Nobody    | Nobody in particular |
|  3 | root      | Enoch Root           |
|  4 | george    | George Smith         |
|  5 | karl      | Karl Smith           |
|  6 | charles   | Charles Smith        |
|  7 | mark      | Mark Smith           |
+----+-----------+----------------------+


I have also seen this behaivor observed on RT 2.0.14, Apache 1.3.26, Perl 
5.6.1, mod_perl 1.27, Solaris 2.6, MySQL 3.32.52.


-Grant Miller    grant at pico.apple.com

 Unix Systems Admin, Engineering Computer Services, Apple Computer