jQuery Grid Plugin - jqGrid - Topic: Can't Sort Date Column with empty cells

Stu on Can't Sort Date Column with empty cells

Mon, 09 Jan 2012 16:48:20 +0200

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.

Stu on Can't Sort Date Column with empty cells

Fri, 06 Jan 2012 23:38:28 +0200

Has anyone looked at this? I have a bunch of data where some of the dates are blank so it does not sort correctly.

tjp on Can't Sort Date Column with empty cells

Mon, 25 Apr 2011 05:09:14 +0300

This is still not fixed. Any ETA on when it will be?

tony on Can't Sort Date Column with empty cells

Tue, 23 Feb 2010 10:53:32 +0200

Hello,

Thanks for this. Also fixed. Will be published soon.

Best Regards

Tony

Mue on Can't Sort Date Column with empty cells

Mon, 22 Feb 2010 17:00:41 +0200

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

tony on Can't Sort Date Column with empty cells

Wed, 09 Sep 2009 05:20:07 +0300

Hello,

Thanks. Will fix this.

Regards

Tony

Jay on Can't Sort Date Column with empty cells

Tue, 08 Sep 2009 17:27:40 +0300

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'},

...