Guriddo » Topic: trouble sorting dates

trouble sorting dates

Guriddo
dates, Sorting
trouble sorting dates

Tagged: dates, Sorting

This topic has 7 replies, 2 voices, and was last updated 9 years, 10 months ago by Big Monty.

Creator

Topic
June 2, 2016 at 11:21 pm #125236

Big Monty
Participant

I’m having problems getting dates to sort correctly, here is my setup:

$(“#jqGrid”).jqGrid({
defaults : {
recordtext: “View {0} – {1} of {2}”,
emptyrecords: “No records to view”,
loadtext: “Loading…”,
pgtext : “Page {0} of {1}”
},
pager: “#jqGridPager”,
url: ‘./json/COrderStatus.asp?mode=load&g_AdminID=188&g_UserID=1817196&g_SiteID=841578&viewID=50′,
mtype: “GET”,
datatype: “json”,
ajaxGridOptions: { contentType: “application/json” },
page: 1,
colModel: [
{
label:’View Table’,
name:’null’,
hidden:true,
align:’center’
},
{
label:’Edit Order’,
name:”,
hidden:true,
align:’center’
},
{
label:’Copy Order’,
name:”,
hidden:true,
align:’center’
},
{
label:’Cancel Order’,
name:”,
hidden:true,
align:’center’
},
{
label:’DateSubmitted’,
name:’OrdersDateSubmitted’,
sorttype:’date’,
datefmt:’m/d/Y’,
align:’center’
},
{
label:’Fulfillment’,
name:’OrdersFFMethod’,
hidden:true,
align:’center’
},
{
label:’OrderID’,
name:’OrdersOrderID’,
align:’center’
},
{
label:’OrderState’,
name:’OrdersOrderState’,
hidden:true,
align:’center’
},
{
label:’Link Status’,
name:’null’,
align:’center’
},
{
label:’E-Mail’,
name:’OrdersRecipientEMail’,
align:’center’
},
{
label:’Name’,
name:’OrdersRecipientName’,
align:’center’
},
{
label:’UID’,
name:’UID’,
hidden:true
},
{
label:’OrdersDateProcessed’,
name:’OrdersDateProcessed’,
hidden:true
},
{
label:’OrdersLongField1′,
name:’OrdersLongField1′,
hidden:true
},
{
label:’OrdersLongField2′,
name:’OrdersLongField2′,
hidden:true
},
{
label:’OrdersLongField3′,
name:’OrdersLongField3′,
hidden:true
},
{
label:’OrdersLongField4′,
name:’OrdersLongField4′,
hidden:true
},
{
label:’OrdersDateSubmitted’,
name:’OrdersDateSubmitted’,
hidden:true
},
{
label:’OrdersOrderID’,
name:’OrdersOrderID’,
hidden:true
},
{
label:’OrdersUserID’,
name:’OrdersUserID’,
hidden:true
},
{
label:’OrdersOrderState’,
name:’OrdersOrderState’,
hidden:true
},
{
label:’OrdersFFMethod’,
name:’OrdersFFMethod’,
hidden:true
},
{
label:’OrdersRecipientName’,
name:’OrdersRecipientName’,
hidden:true
},
{
label:’OrdersRecipientEMail’,
name:’OrdersRecipientEMail’,
hidden:true
},
{
label:’OrdersCCEMail’,
name:’OrdersCCEMail’,
hidden:true
},
{
label:’OrdersRecipientPhone’,
name:’OrdersRecipientPhone’,
hidden:true
},
{
label:’OrdersCompany’,
name:’OrdersCompany’,
hidden:true
},
{
label:’OrdersAddress1′,
name:’OrdersAddress1′,
hidden:true
},
{
label:’OrdersAddress2′,
name:’OrdersAddress2′,
hidden:true
},
{
label:’OrdersCity’,
name:’OrdersCity’,
hidden:true
},
{
label:’OrdersStateProv’,
name:’OrdersStateProv’,
hidden:true
},
{
label:’OrdersCountry’,
name:’OrdersCountry’,
hidden:true
},
{
label:’OrdersPostalCode’,
name:’OrdersPostalCode’,
hidden:true
},
{
label:’OrdersCoverLetter’,
name:’OrdersCoverLetter’,
hidden:true
},
{
label:’OrdersInstructions’,
name:’OrdersInstructions’,
hidden:true
},
{
label:’OrdersNeedBy’,
name:’OrdersNeedBy’,
hidden:true
},
{
label:’OrdersAccountID’,
name:’OrdersAccountID’,
hidden:true
},
{
label:’OrdersSiteID’,
name:’OrdersSiteID’,
hidden:true
},
{
label:’OrdersSubmitEmail’,
name:’OrdersSubmitEmail’,
hidden:true
},
{
label:’OrdersCode1′,
name:’OrdersCode1′,
hidden:true
},
{
label:’OrdersCode2′,
name:’OrdersCode2′,
hidden:true
},
{
label:’AccountsUsername’,
name:’AccountsUsername’,
hidden:true
},
{
label:’AccountsEMail’,
name:’AccountsEMail’,
hidden:true
},
{
label:’UsersEMail’,
name:’UsersEMail’,
hidden:true
},
{
label:’ProfilesUserFirstName’,
name:’ProfilesUserFirstName’,
hidden:true
},
{
label:’ProfilesUserLastName’,
name:’ProfilesUserLastName’,
hidden:true
},
{
label:’ProfilesOrganization’,
name:’ProfilesOrganization’,
hidden:true
},
{
label:’ProfilesPhone’,
name:’ProfilesPhone’,
hidden:true
},
{
label:’ProfilesFax’,
name:’ProfilesFax’,
hidden:true
},
{
label:’ProfilesAddress1′,
name:’ProfilesAddress1′,
hidden:true
},
{
label:’ProfilesAddress2′,
name:’ProfilesAddress2′,
hidden:true
},
{
label:’ProfilesCity’,
name:’ProfilesCity’,
hidden:true
},
{
label:’ProfilesStateProv’,
name:’ProfilesStateProv’,
hidden:true
},
{
label:’ProfilesCountry’,
name:’ProfilesCountry’,
hidden:true
},
{
label:’ProfilesPostalCode’,
name:’ProfilesPostalCode’,
hidden:true
},
{
label:’OrdersWelcomeText’,
name:’OrdersWelcomeText’,
hidden:true
},
{
label:’PageLink’,
name:’PageLink’,
hidden:true
},
].
loadonce: true,
viewrecords: true,
width: 780,
height: 250,
rowNum: 10
});

the field is question is OrdersDateSubmitted, no matter what kind of format I use, it treats it like a string. Here is a sample of the data coming through:

[
{
“UID”: 1164550,
“OrdersDateProcessed”: null,
“OrdersLongField1”: null,
“OrdersLongField2”: null,
“OrdersLongField3”: null,
“OrdersLongField4”: null,
“OrdersDateSubmitted”: “5/18/2016”,
“OrdersOrderID”: 1164550,
“OrdersUserID”: 1817196,
…….

Any help you can provide is greatly appreciated!

Cheers
Josh
Creator

Topic

Viewing 7 replies - 1 through 7 (of 7 total)

Author

Replies

June 3, 2016 at 9:55 am #125237

guriddo.support

Participant

Hello,

The problem here is that all the data retrieving paging sorting are done server side.

For this purpose you will need to write your server side logic to sort and paging the data. You will have the same problem with paging – i.e you will get only the first page.

In order to do the right logic to the server jqGrid send some parameters when it sorts and paging the data.

We have PHP example where you can get idea how to construct your code. The demo code is here

Kind Regards,

Will

Guriddo Support Team

June 3, 2016 at 5:22 pm #125238

Big Monty

Participant

thanks for the quick response!

so if I load my data into a local variable (via ajax), then set up my grid to use local storage, it should work, right? I changed my code to the following yet sorting still doesn’t work:

$.getJSON( url, { format: “json” }).success(function( data ) {
$(“#jqGrid”).jqGrid({
data: data,
datatype: “local”,
jsonReader: {
repeatitems: false
},
………..

June 6, 2016 at 8:54 am #125240

guriddo.support

Participant

Hello,

You may set loadonce parameter to true to load all the data from the server at once and use it then locally.

In order to work sorting when local data you will need to set formatoptions srcformat and newformat.

If these options are not set they are read from the localization file used.

Kind Regards,

Will

Guriddo Support Team

June 6, 2016 at 5:10 pm #125242

Big Monty

Participant

this still doesn’t work, it still treats the column as a bunch of strings when I click the column header to sort. I’m changed my column definition to:

{ label: ‘DateSubmitted’, name: ‘OrdersDateSubmitted’, formatoptions: { srcformat: ‘m/d/Y’, newformat: ‘m/d/y’ }, align: ‘center’ }

June 6, 2016 at 6:07 pm #125243

guriddo.support

Participant

Hello,

Can you please send us a sample server json response (as text file – zip-ed) to support at guriddo dot net?

Also which version of jqGrid is used? and which version of jQuery is used?

Thank you

Kind Regards,
Will

Guriddo Support Team

June 7, 2016 at 10:39 am #125244

guriddo.support

Participant

Hello,

First of all thank you for sending the test case with the data.

Having this for us was possible to find the problem. Actually you have a lot of worg setting in the code.

You have definition in colModel without names. This is not allowed. Moreover the names must be unique.
formatter date is missed to be set.
the definition of the datefield in colModel is wrong
You have one more field with the same name – In your mode search for a “OrdersDateSubmitted” field you will find two one which actually the problem.

In order to work your code

In colModel give unique names of the empty fields something like this:


		{ label: &#039;View Table&#039;, name: &#039;null&#039;, hidden: true, align: &#039;center&#039; }, 
		{ label: &#039;Edit Order&#039;, name: &#039;view&#039;, hidden: true, align: &#039;center&#039; }, 
		{ label: &#039;Copy Order&#039;, name: &#039;copy&#039;, hidden: true, align: &#039;center&#039; }, 
		{ label: &#039;Cancel Order&#039;, name: &#039;cancel&#039;, hidden: true, align: &#039;center&#039; },

{ label: 'View Table', name: 'null', hidden: true, align: 'center' },

{ label: 'Edit Order', name: 'view', hidden: true, align: 'center' },

{ label: 'Copy Order', name: 'copy', hidden: true, align: 'center' },

{ label: 'Cancel Order', name: 'cancel', hidden: true, align: 'center' },

Change the name of the field


...
{ label: &#039;OrdersDateSubmitted&#039;, name: &#039;OrdersDateSubmitted&#039;, hidden: true }, 
...

...

{ label: 'OrdersDateSubmitted', name: 'OrdersDateSubmitted', hidden: true },

...

to something other like


...
{ label: &#039;OrdersDateSubmitted&#039;, name: &#039;DateSubmitted&#039;, hidden: true }, 
...

...

{ label: 'OrdersDateSubmitted', name: 'DateSubmitted', hidden: true },

...

and finally define the field OrdersDateSubmitted like this:

...
{  
   label: &#039;DateSubmitted&#039;, 
   name: &#039;OrdersDateSubmitted&#039;, 
   sorttype: &quot;date&quot;, 
   formatter:&quot;date&quot;, 
   formatoptions: { srcformat: &#039;n/j/Y&#039;, newformat: &#039;m/d/Y&#039; }, 
   align: &#039;center&#039; 
}, 
...

...

{

label: 'DateSubmitted',

name: 'OrdersDateSubmitted',

sorttype: "date",

formatter:"date",

formatoptions: { srcformat: 'n/j/Y', newformat: 'm/d/Y' },

align: 'center'

...

With these settings your code work as expected at our end. If you have trouble, please let us know we will send you the fixed code.

Kind Regards,
Will

Guriddo Support Team

June 7, 2016 at 5:32 pm #125245

trouble sorting dates

Search Forum

Recent Replies

Forum Statistics

UserOnline