[rt-users] Queue Sorting with PostgreSQL

Ruslan Zakirov ruslan.zakirov at gmail.com
Thu Jan 15 19:55:38 EST 2009


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
<cbrockett at 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:  cbrockett at 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: sales at 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.



More information about the rt-users mailing list