jQuery Grid Plugin - jqGrid

I've updated the code as follows but I'm still having trouble with the 'GradeLevel' field sort. It's still sorting like text even though I set it to sort as int.

jQuery("#list").jqGrid({
    url: '/Home/StudentGridData/',
    datatype: 'json',
    loadComplete: function () {
        jQuery("#gridid").jqGrid('setGridParam', { datatype: 'local' });
    },
    onPaging: function (which_button) {
        jQuery("#gridid").jqGrid('setGridParam', { datatype: 'json' });
    },
    mtype: 'POST',
    colNames: ['ID','First Name','Last Name', 'Status','Grade Level','Enroll Date'],
    colModel: [
                        { name:ID',index:'ID',width:60,align:'left',sorttype:'int'},
                        { name:'FirstName',index:'FirstName',width:150,sorttype:'text',align:'left'},
                        { name:'LastName',index:'LastName',width:150,sorttype:'text',align:'left'},
                        { name:'Status',index:'Status',width:200,sorttype:'text',align:'left'},
                        { name:'GradeLevel',index:'GradeLevel',width:100,sorttype:'int',align:'left'},
                        { name:'EnrollmentDate',index:'EnrollmentDate',width:150,sorttype:'date',datefmt:'d/m/Y',align:'left'}],
    rowNum: 25,
    rowList: [5, 10, 20, 50],
    height: 'auto',
    pager: jQuery('#pager'),
                sortname: 'ID',
    viewrecords: true,
    sortorder: "desc",
    caption: 'Student',
    width: '70%',
    postData: {'ID':" ",'firstName':"ALL", 'lastName':"ALL"}

   } );

OlegK said:

I recommend you to use jqGrid 3.7.2 or jqGrid 3.8 beta from http://github.com/tonytomov/jq.....d/tree/dev. Nobody (probably only Tony) have the version or will be test the retro version specially for you.

---

Understood, I updated the code to jqGrid 3.7.2

I tried the loadonce: true setting you mentioned and it seemed to break, displaying only one record (I'm not sure where it's from yet).

As for the other issues I described above, the upgrade alone didn't resolve them.

I have misgivings at returning all rows because this could amount to tens of thousands of results.

OlegK said:

To be able to help you you should post the JSON data which makes the problem: 2-3 line of data wold be OK (if you want test local paging you can send 6 rows and set rowNum: 5).

The data returned validatates as "Valid JSON" in JSONLint.  Here is a sample with 3 rows of data:

{
    "total": 33,
    "page": 1,
    "records": 805,
    "rows": [
        {
            "i": 123456,
            "cell": [
                "\u003ca href="\\Home\\SelectTest?studentId=123456&gradeLevel=KG      "\u003e123456\u003c/a\u003e",
                "Thomas",
                "Jefferson",
                "PENDING ",
                "KG",
                ""
            ]
        },
        {
            "i": 234567,
            "cell": [
                "\u003ca href="\\Home\\SelectTest?studentId=234567&gradeLevel=9       "\u003e234567\u003c/a\u003e",
                "Benjamin",
                "Franklin",
                "ENROLLED",
                "1",
                "02/25/2010"
            ]
        },
        {
            "i": 345678,
            "cell": [
                "\u003ca href="\\Home\\SelectTest?studentId=345678&gradeLevel=11      "\u003e345678\u003c/a\u003e",
                "George",
                "Washington",
                "ENROLLED",
                "11",
                "04/01/2010"
            ]
        }
    ]
}

The JSON is generated as a System.Web.Mvc.JsonResult object as part of a .NET MVC project so it seems that the formatting is valid.

The main issue I'm trying to resolve is to ensure that the grade level fields sort as integers instead of text (values KG, 1, and 11) in the data above.  I have another jqGrid with values ranging from KG to 2 and it seems to be sorting properly in local mode.

As a secondary issue I'd like the date to sort properly as well.  It's also sorting as text at the moment.

OlegK said:

Your JSON data has "i" instead of "id" (for example "i": 123456).

I've corrected this in the code, it is now "id".

OlegK said:

The first row which you has in your "JSON" data has the value "KG" as integer GradeLevel and "" as a date in format 'd/m/Y'. I understand that jqGrid has a problem to read the data.

Best regards
Oleg 

I could replace the "KG" with "0" and use a formatter to address that issue.  What do you reccomend in cases where the data contains an empty date to avoid confusing jqGrid?