Forum
Log In
Home
Topic RSS
14:52
29/01/2009
Offline
Tony,
The sorting of my date columns is not working. The sorting is done at the db based on the columns passed. I've played with the formating and have removed the formating from the colModel and it still acts the same.
My source date is 14-NOV-06 00.00.00.
In php this would be: d-M-y H:i:s
Is this a know problem?
Thanks, Jim
07:06
Moderators
30/10/2007
Offline
Hello,
Local sorting is performed only on numeric date fields. It is a known limitation. Supporting a full range of date sorting including diffrent language setting requiere a code bigger than jqGrid. In order to resolve the problem add a hidden column with numbers or other acceptable date format and perform the sort on that column when you try to sort on the other one. Use onSortCol event for this purpose.
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:
98 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
