Grid Sort Function

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 = (Available in Version 5, Fix Pack 6.0 and later) name of the field that the grid is sorted by
• isDescending = (Available in Version 5, Fix Pack 6.0 and later) true if sorting in descending sequence, false otherwise
• fieldDateFormat = (Available in Version 5, Fix Pack 14.0 and later) 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.