Grid column sorting: mixed types

[andy8Participant]

Hi everybody,

I have a simple, but very annoying issue – cannot properly sort text type columns containing a mix of texts and numbers. The column data type cannot be changed to numbers, because it may also contain text strings. The possible text values are limited only to one string “false”.

Ideally, when sorting such a column, I would like to get all “false” strings grouped in one place (top or bottom) and all numeric values sorted in descending or ascending order.

Is it doable somehow?

Thanks!

[Peter StoevKeymaster]

Hello andy8,

The Grid sorts by your datafield’s type defined in the source object’s initialization. So if it is “string” it will sort by string, if it’s number, it will sort taking into account that the data is numbers. As we know someone may have additional requirements for sorting, we implemented in jqxGrid the option for custom sorting function. Example: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/customsorting.htm?arctic

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[andy8Participant]

Thanks, Peter. It helped a lot.

Cheers,
Andy

[Author]

Posts