How to sort by prices ? (with "natural sorting" plugin for example)

Valky

Hello,

How can we sort prices columns ?

Prices are formed like following (in PHP with number_format() ):
2 150 000 €
4 500 000 €
225 000 €

The same for surfaces like :
80 m²
200 m²
150 m²

I've tried the "formattedNum" plugin but at this time it doesn't works, it sorts like some Varchar and not numeric.
I guess that those are not understood like numbers by DataTables...
So... or how to format numbers into prices with DataTables ?

Thanks in advance.

Valky

I've also tried with the "natural sorting" plugin, but it doesn't seems to work, and I'm not sure to insert it correctly.
You can see it here http://jsfiddle.net/DzaQe/1/

Thanks for your help

allan

> formattedNum

How did you use it? This should be the perfect plug-in for this use case. There is an example of how to do it here: http://datatables.net/release-datatables/examples/plug-ins/sorting_sType.html

Allan

Valky

Hi Allan,

Thanks for your answer.

My mistake was that : I thought sType will be automatic for each column, but we have to descibe each of them, like following :
[code]
"aoColumns": [{"sType": "formatted-num"},
{"sType": "formatted-num"},
{"sType": "formatted-num"},
{"sType": null},
{"sType": null},
....]
[/code]

Thanks a lot for your great work about DataTables, it's really useful !
A real simplification of SQL "ORDER BY" which is heavy and complicated with multiple entities and nested queries...

Sébastien