Forum
Log In
Home
Topic RSS
19:21
11/02/2010
Offline
I have a column that contains addresses which may or may not start with a number. So in some cases I want to sort the column numerically and in other cases sort it textually. In the documentation I see an onSortCol event, which says "If this event return 'stop' the sort processing is stopped and you can define your own custom sorting" which looks like exactly what I need. Question is how do I plug in my own sorting algorithm?
09:31
Moderators
30/10/2007
Offline
Hello,
Very interesting.
I never try this, but you can use the onSortCol event not to stop the sorting, but rather to change the sorttype of the column, something like this:
onSortCol : function(name, iCol, sortOrder) {
if(name=='myname') {
if(some_condition) {
$(this).jqGrid('setColProp','name',{sorttype:'int'});
} else {
$(this).jqGrid('setColProp','name',{sorttype:'text'});
}
}
}
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
10:02
11/02/2010
Offline
Thanks Tony, although that's not quite what I need. Say my column contains '12 High Street', '1 High Street', 'The House, High Street', 'Other Place, High Street', I want to sort the first two as numbers and sort the last two as strings. If I could define my own sort algorithm this would be possible. Time to have a hack around in the code I guess
13:49
Moderators
30/10/2007
Offline
Hello,
I'm thinking about custom defined sort function. Will see how to do this, but I do not promise if this will be in the next release.
Best Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
54 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66
