<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.28">
<TITLE>AW: RE: Re: [rt-users] Sorting on Custom Fields</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hi jeff,<BR>
<BR>
I didn't wrote a patch for oracle, we are using mysql.<BR>
<BR>
Torsten<BR>
<BR>
-----Original Message-----<BR>
From: rt-users-bounces@lists.bestpractical.com <rt-users-bounces@lists.bestpractical.com><BR>
To: Ham MI-ID, Torsten Brumm; ocraig@stillsecure.com <ocraig@stillsecure.com><BR>
CC: rt-users@lists.bestpractical.com <rt-users@lists.bestpractical.com><BR>
Sent: Mon Apr 02 18:06:12 2007<BR>
Subject: RE: Re: [rt-users] Sorting on Custom Fields<BR>
<BR>
I have searched everywhere for this patch, I have only come across a patch for sorting of the custom fields when being displayed on forms, not for sorting data in reports.<BR>
<BR>
I too am on MySQL now, but will be moving to Oracle. Torsten, can you provide your patch for Oracle? I am not able to find this anywhere.<BR>
<BR>
Thanks,<BR>
<BR>
<BR>
Jeff Stark, Sr Systems Administrator <BR>
SumTotal Systems, Inc. (Nasdaq; SUMT) <BR>
<BR>
<BR>
OFFICE +1 919 326 7548<BR>
MOBILE +1 919 622 0418<BR>
<BR>
EMAIL jstark@sumtotalsystems.com <blocked::<A HREF="mailto:jstark@sumtotalsystems.com">mailto:jstark@sumtotalsystems.com</A>><BR>
<BR>
<BR>
<BR>
<BR>
________________________________<BR>
<BR>
From: Ham MI-ID, Torsten Brumm [<A HREF="mailto:torsten.brumm@Kuehne-Nagel.com">mailto:torsten.brumm@Kuehne-Nagel.com</A>]<BR>
Sent: Sunday, April 01, 2007 10:34 PM<BR>
To: ocraig@stillsecure.com; Jeff Stark<BR>
Cc: rt-users@lists.bestpractical.com<BR>
Subject: AW: Re: [rt-users] Sorting on Custom Fields<BR>
<BR>
<BR>
<BR>
Hi jeff and ole,<BR>
<BR>
I had success with mysql, there was a path some months ago from jesse posted to the mailling list, search the mailling list it was for 3.61 and so far I remember, its in place since 3.62. But I'm not sure at this moment what the path has patched, can help you earliest end of the week, laying on the beach this week.<BR>
<BR>
Torsten<BR>
<BR>
-----Original Message-----<BR>
From: rt-users-bounces@lists.bestpractical.com <rt-users-bounces@lists.bestpractical.com><BR>
To: Jeff Stark <JStark@sumtotalsystems.com><BR>
CC: rt-users@lists.bestpractical.com <rt-users@lists.bestpractical.com><BR>
Sent: Sun Apr 01 20:12:54 2007<BR>
Subject: Re: [rt-users] Sorting on Custom Fields<BR>
<BR>
On Wed, 2007-03-28 at 10:30 -0700, Jeff Stark wrote:<BR>
> I have read in many places that there is a patch for the issue<BR>
> regarding<BR>
> sorting on custom fields. However, I am unable to find this patch.<BR>
> Can<BR>
> someone please point me in the right direction?<BR>
><BR>
<BR>
It's apparently a problem with DBIx::SearchBuilder, and as far as I know<BR>
there isn't a patch. (Torsten Brumm had some success with Oracle and/or<BR>
Postgres, but I wasn't able to replicate his results with MySQL.)<BR>
<BR>
I am also eagerly awaiting this fix, since right now I can't present<BR>
saved searches as a reporting solution for my execs.<BR>
<BR>
--<BR>
/Ole Craig<BR>
Security Engineer<BR>
Team lead, customer support<BR>
<BR>
ocraig@stillsecure.com<BR>
303-381-3824 direct<BR>
303-381-3802 support<BR>
303-381-3880 fax<BR>
<BR>
www.stillsecure.com<BR>
<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: sales@bestpractical.com<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>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>