jqGrid Date column sort does not work with sorttype:'date' -
i using jqgrid in mvc 4 display data. having grids date/ datetime column in it. returning c# datetime
variable data grid date column; displaying fine formatoption: {srcformat: 'm/d/y', newformat: 'm/d/y'}
date column & formatoption: {srcformat: 'm/d/y h:i:s', newformat: 'm/d/y h:i:s a'}
datetime column. sorting of column not reflect when user clicks column header. here colmodel
date column
{ name: 'testorderdate', index: 'testorderdate', formatter: 'date', sorttype: 'date', width: 90, align: 'center', fixed: true, formatoptions: { srcformat: 'm/d/y', newformat: 'm/d/y' } },
& datetime column
{ name: 'testorderdate', index: 'testorderdate', formatter: 'date', sorttype: 'date', width: 90, align: 'center', fixed: true, formatoptions: { srcformat: 'm/d/y h:i:s', newformat: 'm/d/y h:i:s a' } },
can tell me wrong in colmodel
due sort behavior not working.
i recommend update 2.5 years old version 4.1.1 version 4.5.4. contains new implementation of date parsing. sort column having sorttype:'date'
option jqgrid first parse (unformat) string displayed in grid. formats 'm/d/y h:i:s a'
not supported parsing (and sorting) in old versions of jqgrid.
the versions of jqgrid starting 4.3.2 don't need file ellipsis-xbl.xml
. used in versions display ellipsis in old versions of mozilla/firefox browsers. the line of ui.jqgrid.css
replaced the line starting 4.3.2.
Comments
Post a Comment