[rt-users] Sorting by the value of a custom field in search results *numerically*

[Parish, Brent]

This is because the custom field values are stored as varchar or text in the database.
I added a feature request (http://issues.bestpractical.com/Ticket/Display.html?id=29638) for it.

- Brent


-----Original Message-----
From: rt-users [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Emmanuel Lacour
Sent: Monday, May 05, 2014 8:23 AM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Sorting by the value of a custom field in search results *numerically*

On Mon, May 05, 2014 at 02:21:28PM +0200, Emmanuel Lacour wrote:
> On Fri, May 02, 2014 at 01:52:06PM -0700, Landon Stewart wrote:
> >    Hello,
> >    It seems that the sorting by custom field in search results is always done
> >    alphabetically.  
> >    For example sorting by CF that contains only integers in descending order:
> >    4
> >    3
> >    2
> >    11
> >    1
> >    Is there a way to sort search results by custom field numerically?
> >
> 
> 
> I use the attached patch for 4.2.3 (not very efficient, but it works).
> 


I misread your email, my patch just fix sorting on CF edit pages, not in search results.


-- 
Easter-eggs                              Spécialiste GNU/Linux
44-46 rue de l'Ouest  -  75014 Paris  -  France -  Métro Gaité
Phone: +33 (0) 1 43 35 00 37    -   Fax: +33 (0) 1 43 35 00 76
mailto:elacour at easter-eggs.com  -   http://www.easter-eggs.com
--
RT Training - Dallas May 20-21
http://bestpractical.com/training