[rt-users] Sorting on Custom Fields

[Jeff Stark]

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.
 
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.
 
Thanks,
 
 
Jeff Stark, Sr Systems Administrator      
SumTotal Systems, Inc. (Nasdaq; SUMT)                       


OFFICE    +1 919 326 7548
MOBILE  +1 919 622 0418

EMAIL     jstark at sumtotalsystems.com
<blocked::mailto:jstark at sumtotalsystems.com> 

 
 

________________________________

From: Ham MI-ID, Torsten Brumm [mailto:torsten.brumm at Kuehne-Nagel.com] 
Sent: Sunday, April 01, 2007 10:34 PM
To: ocraig at stillsecure.com; Jeff Stark
Cc: rt-users at lists.bestpractical.com
Subject: AW: Re: [rt-users] Sorting on Custom Fields



Hi jeff and ole,

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.

Torsten

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
<rt-users-bounces at lists.bestpractical.com>
To: Jeff Stark <JStark at sumtotalsystems.com>
CC: rt-users at lists.bestpractical.com <rt-users at lists.bestpractical.com>
Sent: Sun Apr 01 20:12:54 2007
Subject: Re: [rt-users] Sorting on Custom Fields

On Wed, 2007-03-28 at 10:30 -0700, Jeff Stark wrote:
> I have read in many places that there is a patch for the issue
> regarding
> sorting on custom fields.  However, I am unable to find this patch.
> Can
> someone please point me in the right direction?
>

It's apparently a problem with DBIx::SearchBuilder, and as far as I know
there isn't a patch. (Torsten Brumm had some success with Oracle and/or
Postgres, but I wasn't able to replicate his results with MySQL.)

I am also eagerly awaiting this fix, since right now I can't present
saved searches as a reporting solution for my execs.

--
/Ole Craig
Security Engineer
Team lead, customer support

ocraig at stillsecure.com
303-381-3824 direct
303-381-3802 support
303-381-3880 fax

www.stillsecure.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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070402/e2ae3002/attachment.htm>