We are using a Datatable widget bound on a DataAdapter and the data are updated using a Rest service returning a list of heterogeneous JSON objects.
We are experiencing problems when sorting a numeric column in the Datatable. The problem is that the compare function doesn’t handle the case when a value is “undefined”. When it compares a numeric value (such as 1.23) and an other that is “undefined”, it always return 0 (or equal – which is not the case).
After some tries, we have discovered that this same sorting functionality work as it’s supposed to when all the empty values are “null” (instead of undefined). However, our architecture doesn’t allows us to change/set all the undefined value to null…
So, is there a way to update this widget to care of undefined values?
A possible solution is to change all the undefined values received from the server to null values in the data adapter’s beforeLoadComplete callback function. You can find examples of its use in the jqxDataAdapter help topic.