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-boun...@lists.bestpractical.com] On Behalf Of Emmanuel Lacour Sent: Monday, May 05, 2014 8:23 AM To: rt-users@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:elac...@easter-eggs.com - http://www.easter-eggs.com -- RT Training - Dallas May 20-21 http://bestpractical.com/training -- RT Training - Dallas May 20-21 http://bestpractical.com/training