Guriddo » Topic: text sorttype enhancement

text sorttype enhancement

Guriddo
text sorttype enhancement

This topic has 4 replies, 3 voices, and was last updated 14 years, 4 months ago by nolanlove.

Creator

Topic
April 11, 2011 at 9:40 pm #78345
McCulloch
Participant
Currently the sorttype property of a column defines the type of the column for appropriate sorting.

Possible values include int/integer – for sorting integer ; float/number/currency – for sorting decimal numbers ; date – for sorting date and text – for text sorting.

I have a need for case, punctuation and accent insensitive text sorting.

For example, currently jqGrid sorts a column in this order:
1. …
2. Cross-border reorganization
3. Crystallization of…
4. Cr
Creator

Topic

Viewing 4 replies - 1 through 4 (of 4 total)

Author

Replies
April 12, 2011 at 12:38 am #97763

OlegK
Participant

Hello McCulloch,

jqGrid have a nice posibility to define some properties as functions. For example the sorttype property of the colModel can be also defined as function with the prototype sorttype: function(cellValue, rowObject) {/* return some value which will be used in compare operations */}. I hope that the implementation of sorttype

April 12, 2011 at 4:45 pm #97766

McCulloch
Participant

Thank you Oleg, this approach worked but the specific function did not. It probably had something to do with character encoding. Here is the function that ended up working for me, after researching UTF-8 encoding:

sorttype: function(cellValue) { return removeDiacritics(cellValue); }
function removeDiacritics(s) {

April 12, 2011 at 5:46 pm #97767

OlegK
Participant

Hi,

if you save the file which contain the JavaScript code (JS or HTM file) in UTF-8 encoding all work. You can try the demo

December 9, 2011 at 1:29 am #99175

nolanlove
Participant

Hi Oleg,

I have had some good success with using sorttype: function(cellValue, rowObject) as you describe. The value which is returned from the function seems to be compared as a String however, and in some cases I would like it to be compared as an int, or date, or some other datatype without having to convert those to sortable String equivalents.

Do you have any idea how to do this, as in how to indicate in the sorttype function how the returned value should be interpreted in a sort?

Thanks,

Nolan
Author

Replies