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.
TorstenFrom: firstname.lastname@example.org email@example.com
To: Jeff Stark JStark@sumtotalsystems.com
CC: firstname.lastname@example.org email@example.com
Sent: Sun Apr 01 20:12:54 2007
Subject: Re: [rt-users] Sorting on Custom Fields
I have read in many places that there is a patch for the issue
sorting on custom fields. However, I am unable to find this patch.
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.
Team lead, customer support
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com