jakemonO on sorting woes

Fri, 27 Aug 2010 20:14:40 +0300

I'm using jqGrid 3.7.2. to display data retrieved as JSON from a DWR call. The grid displays flawlessy, but I can't seeem to get it to do client-side sorting no matter what I try. Am I to understand that the grid doesn't sort on remote data? I'm returning a complete result set that is displayed in 1 page and all I want to do is sort what's being displayed in the grid when a user clicks on the column header. Here's my colModel:

colModelDef = [
        {name:'id',label:'id',hidden: true, key: true},
        {name:'nodeType',label:'Action',width:75, key: true, sortable: false},
        {name:'date',label:'Effective Date',width:100, sortable: true, sorttype: 'date', formatter:'date'},
        {name:'location',label:'Location',width:150, key: true, sortable: true, sorttype: 'text'},
        {name:'quantity',label:'Quantity',width:70, sorttype: 'int'},
        {name:'reason',label:'Reason',width:200},
        {name:'comment',label:'Comments',width:400}
];

with DWR, I essentially call make the remote call, retrieve the JSON and execute the callback which massages the retrieved data and executes

$(".tableName")[0].addJSONData(tableData)

My Grid function is:

$(".tableName").jqGrid({
            datatype: doFetch(postdata),
            colModel: colModelDef,
            jsonReader: {
                repeatitems: false
            },

            ondblClickRow: function() {
                row_id = $(".tableName").getGridParam('selrow');
                editNode(row_id)
            },
            sortname: 'date',
            sortorder: 'desc'
        })

Pray tell, what am I missing to get this to sort on the client?

Thanks in adv.

jQuery Grid Plugin - jqGrid - Topic: sorting woes

jakemonO on sorting woes