Oh, sorry, that isn't the question. I know it's sorting by Queue id's, the problem is that RT is using the word "Queue" as the OrderBy request, not "queue", case is important in this particular instance.
Regards, Cassandra Brockett Barracuda Networks Inc. Tel: +1-(408)342-5653 Fax: +1-(408)342-5653 Email: cbrock...@barracuda.com Web: http://www.barracudanetworks.com -----Original Message----- From: Ruslan Zakirov [mailto:ruslan.zaki...@gmail.com] Sent: Thursday, January 15, 2009 4:56 PM To: Cassandra L. Brockett Cc: RT-Users@lists.bestpractical.com Subject: Re: [rt-users] Queue Sorting with PostgreSQL As far as I know sorting by Queue always was sorting by queue ids. It's been changed in 3.8.1 or 3.8.2. On Fri, Jan 16, 2009 at 2:24 AM, Cassandra L. Brockett <cbrock...@barracuda.com> wrote: > So... After many headaches, we gave up trying to convert the databases > over for the ticket information from the old system, and started from > scratch. > > Now, I happen to prefer PostgreSQL as my database engine due to > historical issues I have had with MySQL... However the code appears to > have a bug with 3.6.7, in that while everything works, trying to "sort > by queue" doesn't. I can sort by everything but the Queue, and this > sort of throws things a little as it's something we set previously on > a whim and is now something we all seem to rely on... > > So.... Anyone know what I need to do to get the OrderBy line for > anytime someone wants to sort by Queue to use "queue" as the column > name, and not "Queue"? > > Regards, > Cassandra Brockett > Barracuda Networks Inc. > Email: cbrock...@barracuda.com > Web: http://www.barracudanetworks.com > > ---------------------------------- > Barracuda Networks makes the best spam firewalls and web filters. > www.barracudanetworks.com > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com Commercial support: > sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. ---------------------------------- Barracuda Networks makes the best spam firewalls and web filters. www.barracudanetworks.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com