The variable pui.gridSort can be used to customize the client side grid column sort by defining a sort function.
The following parameters are passed to this function:
- value1 = first field value to compare
- value2 = second field value to compare
- fieldName = (version 5.6.0 and newer) name of the field that the grid is sorted by
- isDescending = (version 5.6.0 and newer) true if sorting in descending sequence, false otherwise
- fieldDateFormat= (version 5.14.1 and newer) date format of the field that the grid is sorted by, if the field is not a date null will be passed instead.
Example:
pui.gridSort = function(value1, value2, fieldName, isDescending, fieldDateFormat) { if (value1 > value2) return -1; else return 1; }
This function could be used to control the order numerals and characters are sorted.