Forum
17:19
16/09/2009
I have not been able to get the date sorting working correctly. I've tried a lot of combinations of the datefmt and formatoptions and formatoptions partially works, but nothing I've tried sorts the dates in the correct ascending & descending order. I've included a stripped down version of my code below to reproduce the problem. Thanks for your help.
Scott
<html xmlns="http://www.w3.org/1999/xhtml">
<body>
<script src="Scripts/jquery.jqGrid-4.1.2/js/jquery-1.5.2.min.js" type="text/javascript"></script>
<script src="Scripts/json.js" type="text/javascript"></script>
<link href="css/start/jquery-ui-1.8.14.custom.css" rel="stylesheet" type="text/css" />
<script src="Scripts/jquery-ui-1.8.14.custom.min.js" type="text/javascript"></script>
<script src="Scripts/jquery.bgiframe.min.js" type="text/javascript"></script>
<link href="Scripts/jquery.jqGrid-4.1.2/css/ui.jqgrid.css" rel="stylesheet" type="text/css" />
<script src="Scripts/jquery.jqGrid-4.1.2/js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="Scripts/jquery.jqGrid-4.1.2/js/jquery.jqGrid.min.js" type="text/javascript"></script>
<input id="CaseFlagsHistoryJson1" name="CaseFlagsHistoryJson1" type="hidden" value="{"TypeName":"Level","Data":[{"CaseFlagLevelID":16,"CaseFlagLevelTypeValueID":1,"CaseID":32413,"LevelDate":"\/Date(1282021200000-0500)\/","ClosedLevelDate":null,"CreateDate":"\/Date(1311280302187-0500)\/","CreateID":"scott.walters","CaseFlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":1,"CaseFlagLevelTypeID":1,"ValueText":"1","IsActive":true,"CaseFlagLevelTypeField":{"CaseFlagLevelTypeID":1,"TypeName":"Level","LevelDateDisplayText":"Date of Level","ClosedLevelDateDisplayText":"Closed Level Date","IsActive":true,"FlagLevelField":null,"FlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":1,"CaseFlagLevelTypeID":1,"ValueText":"1","IsActive":true,"CaseFlagLevelTypeField":null}}},"id":0,"LevelDateDisplay":"08/17/2010","ClosedLevelDateDisplay":""},{"CaseFlagLevelID":14,"CaseFlagLevelTypeValueID":1,"CaseID":32413,"LevelDate":"\/Date(1313557200000-0500)\/","ClosedLevelDate":"\/Date(1313643600000-0500)\/","CreateDate":"\/Date(1311279870813-0500)\/","CreateID":"scott.walters","CaseFlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":1,"CaseFlagLevelTypeID":1,"ValueText":"1","IsActive":true,"CaseFlagLevelTypeField":{"CaseFlagLevelTypeID":1,"TypeName":"Level","LevelDateDisplayText":"Date of Level","ClosedLevelDateDisplayText":"Closed Level Date","IsActive":true,"FlagLevelField":null,"FlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":1,"CaseFlagLevelTypeID":1,"ValueText":"1","IsActive":true,"CaseFlagLevelTypeField":null}}},"id":0,"LevelDateDisplay":"08/17/2011","ClosedLevelDateDisplay":"08/18/2011"},{"CaseFlagLevelID":13,"CaseFlagLevelTypeValueID":1,"CaseID":32413,"LevelDate":"\/Date(1313384400000-0500)\/","ClosedLevelDate":"\/Date(1313470800000-0500)\/","CreateDate":"\/Date(1311279858957-0500)\/","CreateID":"scott.walters","CaseFlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":1,"CaseFlagLevelTypeID":1,"ValueText":"1","IsActive":true,"CaseFlagLevelTypeField":{"CaseFlagLevelTypeID":1,"TypeName":"Level","LevelDateDisplayText":"Date of Level","ClosedLevelDateDisplayText":"Closed Level Date","IsActive":true,"FlagLevelField":null,"FlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":1,"CaseFlagLevelTypeID":1,"ValueText":"1","IsActive":true,"CaseFlagLevelTypeField":null}}},"id":0,"LevelDateDisplay":"08/15/2011","ClosedLevelDateDisplay":"08/16/2011"},{"CaseFlagLevelID":12,"CaseFlagLevelTypeValueID":1,"CaseID":32413,"LevelDate":"\/Date(1313125200000-0500)\/","ClosedLevelDate":"\/Date(1313211600000-0500)\/","CreateDate":"\/Date(1311279822447-0500)\/","CreateID":"scott.walters","CaseFlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":1,"CaseFlagLevelTypeID":1,"ValueText":"1","IsActive":true,"CaseFlagLevelTypeField":{"CaseFlagLevelTypeID":1,"TypeName":"Level","LevelDateDisplayText":"Date of Level","ClosedLevelDateDisplayText":"Closed Level Date","IsActive":true,"FlagLevelField":null,"FlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":1,"CaseFlagLevelTypeID":1,"ValueText":"1","IsActive":true,"CaseFlagLevelTypeField":null}}},"id":0,"LevelDateDisplay":"08/12/2011","ClosedLevelDateDisplay":"08/13/2011"},{"CaseFlagLevelID":11,"CaseFlagLevelTypeValueID":2,"CaseID":32413,"LevelDate":"\/Date(1310533200000-0500)\/","ClosedLevelDate":null,"CreateDate":"\/Date(1311279603107-0500)\/","CreateID":"scott.walters","CaseFlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":2,"CaseFlagLevelTypeID":1,"ValueText":"2","IsActive":true,"CaseFlagLevelTypeField":{"CaseFlagLevelTypeID":1,"TypeName":"Level","LevelDateDisplayText":"Date of Level","ClosedLevelDateDisplayText":"Closed Level Date","IsActive":true,"FlagLevelField":null,"FlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":2,"CaseFlagLevelTypeID":1,"ValueText":"2","IsActive":true,"CaseFlagLevelTypeField":null}}},"id":0,"LevelDateDisplay":"07/13/2011","ClosedLevelDateDisplay":""},{"CaseFlagLevelID":10,"CaseFlagLevelTypeValueID":1,"CaseID":32413,"LevelDate":"\/Date(1309928400000-0500)\/","ClosedLevelDate":"\/Date(1310446800000-0500)\/","CreateDate":"\/Date(1311279545737-0500)\/","CreateID":"scott.walters","CaseFlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":1,"CaseFlagLevelTypeID":1,"ValueText":"1","IsActive":true,"CaseFlagLevelTypeField":{"CaseFlagLevelTypeID":1,"TypeName":"Level","LevelDateDisplayText":"Date of Level","ClosedLevelDateDisplayText":"Closed Level Date","IsActive":true,"FlagLevelField":null,"FlagLevelTypeValueField":{"CaseFlagLevelTypeValueID":1,"CaseFlagLevelTypeID":1,"ValueText":"1","IsActive":true,"CaseFlagLevelTypeField":null}}},"id":0,"LevelDateDisplay":"07/06/2011","ClosedLevelDateDisplay":"07/12/2011"}]}" />
<table id="historyGrid_1"></table>
<script type="text/javascript">
$(document).ready(function() {
var histDataJson1 = $('#CaseFlagsHistoryJson1').val();
var histData1 = $.parseJSON(histDataJson1);
$.each(histData1.Data, function(ndx2, arrelem) {
var lvlText = arrelem.CaseFlagLevelTypeValueField.ValueText;
arrelem.ValueText = lvlText;
});
$('#historyGrid_1').jqGrid({
datatype: "local",
data: histData1.Data,
height: 300,
colNames: ['id', 'Level Name', 'Level Date', 'Closed Level Date'],
colModel: [
{ name: 'id', index: 'id', width: 60, sorttype: "int", hidden: true },
{ name: 'ValueText', index: 'ValueText', width: 150, sorttype: "text", sortable: true },
{ name: 'LevelDate', index: 'LevelDate', width: 180, sortable: true, sorttype: "date", formatter: 'date', formatoptions: { newformat: 'm/d/Y'} },
{ name: 'ClosedLevelDate', index: 'ClosedLevelDate', width: 180, sortable: true, sorttype: "date", formatter: 'date', formatoptions: { newformat: 'm/d/Y'} }
],
caption: histData1.TypeName
});
});
</script>
</body>
</html>
Most Users Ever Online: 715
Currently Online:
48 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