Yes, and it is broken in 3.6.1 too :-(<br><br>Torsten<br><br><div><span class="gmail_quote">2006/10/5, Ruslan Zakirov <<a href="mailto:ruslan.zakirov@gmail.com">ruslan.zakirov@gmail.com</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
sorry, I didn't test now I see that it's broken on mysql too :(<br><br>On 10/5/06, Ole Craig <<a href="mailto:ocraig@stillsecure.com">ocraig@stillsecure.com</a>> wrote:<br>> On Thu, 2006-10-05 at 01:40 +0400, Ruslan Zakirov wrote:
<br>> > On 10/4/06, Ole Craig <<a href="mailto:ocraig@stillsecure.com">ocraig@stillsecure.com</a>> wrote:<br>> > > On Thu, 2006-09-28 at 14:46 -0400, Jesse Vincent wrote:<br>> > > > > >> So i came back to
3.6.0 and paradoxically the problem still exists!<br>> > > > > ><br>> > > > > > I'm betting that this is due to an upgraded DBIx::SearchBuilder. Just<br>> > > > > > out of curiosity, what database are you on?
<br>> > > > ><br>> > > > > Our RT Installation uses PostgreSQL 8.0.3.<br>> > > > ><br>> > > [...]<br>> > > > Ok. Yes, this is a known bug (and one that it turns out is going to be a
<br>> > > > real pain to fix)<br>> > ><br>> > > Jesse -<br>> > > Is that the case for all combinations? I'm running into a<br>> > > similar CF sort problem with MySQL
4.1 and 3.6.0.<br>> > > (DBIx-SearchBuilder-1.43).<br>> > CF sorting in MySQL should work.<br>><br>> Guess I'm just lucky... I've got a select-one-value Ticket CF named<br>> "Severity" which currently has the following possible name values:
<br>><br>> '1 - CRITICAL'<br>> '2 - Major'<br>> '3 - Minor'<br>> '4 - Informational'<br>><br>> (sort ordering is 1234 and the value name begins with the appropriate<br>
> digit as well.)<br>><br>> If I sort my "N" highest priority tickets at-a-glance page on that CF<br>> (and that CF alone, all other sort bars are set to "none") I get a<br>> random list. At the moment, it looks like this:
<br>><br>> 3 - Minor<br>> 3 - Minor<br>> 1 - CRITICAL<br>> 2 - Major<br>> 2 - Major<br>> 4 - Informational<br>> 2 - Major<br>> 3 - Minor<br>> [...]<br>><br>> No other order is apparent in the ticket list.
<br>><br>> Thoughts?<br>><br>><br>> --<br>> /Ole Craig<br>> Security Engineer<br>> Team lead, customer support<br>><br>> 303-381-3802 (main support hotline)<br>> 303-381-3824 (my direct line)
<br>> 303-381-3801 (fax)<br>><br>> <a href="http://www.stillsecure.com">www.stillsecure.com</a><br>> . . .<br>><br><br><br>--<br>Best regards, Ruslan.<br>_______________________________________________<br><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br><br>Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>Commercial support: <a href="mailto:sales@bestpractical.com">
sales@bestpractical.com</a><br><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br></blockquote></div>
<br><br clear="all"><br>-- <br>MFG<br><br>Torsten Brumm<br><br><a href="http://www.torsten-brumm.de">http://www.torsten-brumm.de</a>