[rt-users] Queue Sorting with PostgreSQL

[Cassandra L. Brockett]

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:  cbrockett at barracuda.com
Web:  http://www.barracudanetworks.com

-----Original Message-----
From: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com] 
Sent: Thursday, January 15, 2009 4:56 PM
To: Cassandra L. Brockett
Cc: RT-Users at 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
<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.

----------------------------------
Barracuda Networks makes the best spam firewalls and web filters. www.barracudanetworks.com