jQuery Grid Plugin - jqGrid - Topic: Column Sorting http://www.trirand.com/blog/?page_id=393/help/column-sorting Simple:Press Version 5.7.5.3 RobGMiller on Column Sorting http://www.trirand.com/blog/?page_id=393/help/column-sorting#p4256 Help http://www.trirand.com/blog/?page_id=393/help/column-sorting#p4256

Bingo!

Definetly need to pay more attention to case sensitivity of javascript.

Thanks again Tony,

]]> Fri, 30 Jan 2009 11:09:52 +0200 tony on Column Sorting http://www.trirand.com/blog/?page_id=393/help/column-sorting#p4245 Help http://www.trirand.com/blog/?page_id=393/help/column-sorting#p4245 Hello,

Try with

sortorder: "asc"

and not with

sortorder: “Asc”

Regards

Tony

]]> Fri, 30 Jan 2009 09:21:20 +0200 RobGMiller on Column Sorting http://www.trirand.com/blog/?page_id=393/help/column-sorting#p4244 Help http://www.trirand.com/blog/?page_id=393/help/column-sorting#p4244

Hi Tony,

The following is how the grid is configured: (truncated as much as possible)

(”#ETSMonth”).jqGrid({

   url: 'WSGridGetDFSA.aspx',

   datatype: “json”, 

   mtype: 'POST',

   colModel: [

     {label: 'Date', name: 'Day', index: 'DayDate', width: 50, align: 'center' }, 

     {label: 'UWI', name: 'UWI', index: 'UWI', width: 200 },

      ...........40 other columns.........

     {label: 'GRID', name: 'GRID', index: 'GRID', width: 1}        

   ],

   imgpath: 'themes/coffee/images',

   sortname: 'Day',

   sortorder: “Asc”,

   viewrecords: true,

   height: '100%',

   hidegrid: false, 

   cellEdit: true,

   cellsubmit: 'clientArray', 

   cellurl: “WSGridSetDFSA.aspx”,

   afterSaveCell: function(rowid, celname, value, iRow, iCol) { 

        setAssociatedCellValues(rowid, celname, value, iRow, iCol) },

   onSelectCell: function(id, name, val, iRow, iCol) { 

        setStaticCellValues(id, name, val, iRow, iCol); },

   loadComplete: function() { setInitialCaption(); },

        subGrid: true,

   subGridRowExpanded: function(subgrid_id, row_id) {….Working grid as subgrid…},

   caption: “Title bar caption”

 }); //End #ETSMonth

as you can see there is no paging information. The server always returns all the records. Each row represents 1 day in the current month. sidx and page are not used by the server to return records. 
The post looks like the following:
page=1&rows=20&sidx=Day&sord=Asc&nd=1233322639562&_search=false
When the “Day” column header is clicked the grid will post back and “sord” is always whatever the sortorder: option is set to.
Some columns are hidden using the following statement after the Grid Declaration:
            $("#ETSMonth").hideCol(["UWI~Project", "APR", "SubmitDate", "Total", "KMRate", "HQty", "HRate", "LQty", "LRate", "CQty", "CRate", "Other", "MQty", "MRate", "FQty", "FRate", "TQty", "TRate", "MHQty", "MHRate", "HSQty", "HSRate", "NQty", "NRate", "Customer", "Labour", "Month", "Year", "DRID", "WOID", "GRID"]);
 
Thanks again for your help.
Rob…

]]> Fri, 30 Jan 2009 07:33:23 +0200 tony on Column Sorting http://www.trirand.com/blog/?page_id=393/help/column-sorting#p4215 Help http://www.trirand.com/blog/?page_id=393/help/column-sorting#p4215 Hello,

I'm not sure what you try to do but this work well in the demo page. You can check. Also do you have some events defind - by example onPaging.

Also if you click on column1 and then on column2 the first order is asc and the second is again asc

Regards

Tony

]]> Thu, 29 Jan 2009 06:32:00 +0200 RobGMiller on Column Sorting http://www.trirand.com/blog/?page_id=393/help/column-sorting#p4204 Help http://www.trirand.com/blog/?page_id=393/help/column-sorting#p4204 Hello, 

I would imagine that clicking on a column header that is set for sortable:true should toggle the sort order from asc to desc for that column and include it in the POST "sord" parameter when the grid is reloaded from the server. 

In this case, the POST is made when the column header is clicked but the "sord" parameter does not change from Asc to desc. 

Is  there something else that needs to be done to activate this feature?

Rob..

]]> Thu, 29 Jan 2009 04:44:21 +0200