Overload sorting in jqxDataTable(or jqxGrid)

[DaveHightowerParticipant]

Greetings–

I have data being loaded into a DataTable of type string; however, it is actually human-readable data values: (“4.02Gb”, “3.15Mb”, etc).
When trying to sort this, jqXDataTable sorts on the number…which does not give me the right sort order.

Similarly, I have another field which is a number — but the actual cell contents are “NUMBER“. When sorting on this, it puts numbers in L->R order, rather than natural sort — for example, sorting into the order 5,503,50430,508,51…).

I imagine I need to overload/override the sorting function for these fields…how do I do that?

[DimitarParticipant]

Hello DaveHightower,

The jqxGrid demo Custom Sorting shows how to override the default sorting of the widget. The same approach can be applied to jqxDataTable, too.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[DaveHightowerParticipant]

Excellent — I knew it was somewhere, but wasn’t looking under grid.

Thanks!

[Author]

Posts