Because the server software I’m using (coldfusion) uses a non-standard JSON format, I’m having to remap the columns.

Unfortunately, once I do this, when using the toolbar search boxes, the grid queries the server rather than doing so locally — I set the loadonce:true parameter so that it would not query the server after the initial load.

Can anyone help me with this?

var gridCols = {set:false};

$(document).ready(function(){
var grid = $(‘#gridTest’); // JQuery object reference of table used for our grid display

/*
* FUNCTION populateGrid
* Used as the ‘datatype’ attribute of the jqGrid config object, this method
* is used to handle the ajax calls and data manipulation needed to populate
* data within our jqGrid instance.
* @postdata (object) – this is the object passed as the ‘postData’ attribute
* of our jqGrid instance.
*/
var populateGrid = function (postdata) {
$.ajax({
url: ‘./cfc/Schools.cfc’,
data:postdata,
method:’GET’,
dataType:”json”,
success: function(d,r,o){
if(d.SUCCESS){
// If loading for the first time, let’s find out to which
// array positions our columns map.
if(!gridCols.set){
for(var i in d.DATA.COLUMNS){
gridCols[d.DATA.COLUMNS] = parseInt(i);
}
gridCols.set = true;
}
grid.jqGrid(‘setGridParam’,{remapColumns:[
gridCols,
gridCols,
gridCols,
gridCols,
gridCols,
gridCols,
gridCols
]});
grid[0].addJSONData(d);
} else {
alert(d.MESSAGE);
}
}
});
};

grid.jqGrid(‘navGrid’,’#ptoolbar’,{del:false,add:false,edit:false,search:false});
grid.jqGrid(‘filterToolbar’,{stringResult:true,searchOnEnter:false});
});