Forum
Log In
Home
Topic RSS
17:27
I've run across an issue where trying to sort a date column that has missing dates causes the sort to fail. It's mostly sorted, but the empty values are interspersed in the column and some of the dates before and after an empty value are out of order relative to other nearby dates. If I fill in these empty columns with data, then the code below works as expected.
jQuery("#list").jqGrid({
...
{name:'collected', index:'collected', width:102, formatter:'date', formatoptions:{srcformat:'d-M-Y',newformat:'d-M-Y'}, sorttype: 'date', datefmt: 'dd-M-Y', align:'right'},
...
05:20
Moderators
30/10/2007
Offline
Hello,
Thanks. Will fix this.
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.
17:00
22/02/2010
Offline
Hi all,
The bug as described in the mail from Jay still exist in the newest version. Every blank date field isn't touch in the sort algorithm. I've taste it with different format options, but the issue is always the same. The block with values in the date field is sorted correct, every other stays as it is. I think the sort algorithm needs only to extend to test for blank dates. It would be very nice if the bug could be eliminated.
Thanks and best regards
Mue
10:53
Moderators
30/10/2007
Offline
Hello,
Thanks for this. Also fixed. Will be published soon.
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.
05:09
11/02/2011
Offline
This is still not fixed. Any ETA on when it will be?
23:38
22/08/2011
Offline
Has anyone looked at this? I have a bunch of data where some of the dates are blank so it does not sort correctly.
16:48
22/08/2011
Offline
Stu said:Has anyone looked at this? I have a bunch of data where some of the dates are blank so it does not sort correctly.
Any suggestions? My data is all in the format "dd/mm/yyyy". I tried formatting empty values as " / / " but that fails as well.
The only hack that I could find to work was to have empty dates as "01/01/1901" which works, but it is a hack and confusing.
Most Users Ever Online: 715
Currently Online:
40 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
