Textpattern CMS

#1 2011-03-30 17:56:08

element

Member

Registered: 2009-11-18

Posts: 99

Sorting a custom field

Hi,

I have a custom field I want to sort. The field contains numbers but they don’t get sorted properly.

Current sort (asc):
1000
1200
200
300
400
500

How it should be:
200
300
400
500
1000
1200

Can this be solved in any way?

#2 2011-03-30 18:05:36

maruchan

Member

From: Ukiah, California

Registered: 2010-06-12

Posts: 596

Website

Re: Sorting a custom field

Seen this before…does this answer help you?

#3 2011-03-31 08:52:35

element

Member

Registered: 2009-11-18

Posts: 99

Re: Sorting a custom field

maruchan wrote:

Seen this before…does this answer help you?

Yes. Solved, thanks. Weird solution though.

#4 2011-04-02 16:02:56

CeBe

Plugin Author

From: Caen - Fr

Registered: 2010-06-25

Posts: 345

Website

Re: Sorting a custom field

element a écrit:

Weird solution though.

Not that much.
With your first sort, it sorts in alphabetical order. When you add 0, you add the number 0 and it forces the result to be a number.