jQuery Grid Plugin - jqGrid - Topic: calling setRowData then sorting the table.

vrtinch on calling setRowData then sorting the table.

Wed, 27 Oct 2010 20:08:14 +0300

So I found a work around.

It appears the underlying issue was in the GridParam Data not being updated correctly.

So instead of calling the setRowData command I wrote a little function that updated the underlying data and reloaded the grid.

Seems to work fine so far.

console.log($('#435_ListingHistoryTable').jqGrid('getGridParam','data'));

var Data = $('#435_ListingHistoryTable').jqGrid('getGridParam','data');

var RowData = $('#435_ListingHistoryTable').jqGrid('getRowData',997);

for(var i in Data ){
if (Data[i].ID == RowData.ID){
Data[i].Notes = '1 Already Done';
break;
}
}

$('#435_ListingHistoryTable').jqGrid('setGridParam','data', Data).trigger("reloadGrid");
console.log($('#435_ListingHistoryTable').jqGrid('getGridParam','data'));

vrtinch on calling setRowData then sorting the table.

Wed, 27 Oct 2010 16:58:04 +0300

forgot to mention that in the above attempt the GUI looked as if everything was done correctly until I sorted which then revealed the bad underlying data.

vrtinch on calling setRowData then sorting the table.

Wed, 27 Oct 2010 16:49:00 +0300

I tried working around this issue by deleting and adding the edited row back to the table. The results were just as bad.

After running the following commands

/******Start Commands

console.log($('#435_ListingHistoryTable').jqGrid('getGridParam','data')); // Data Before editing

var Data = $('#435_ListingHistoryTable').jqGrid('getRowData',997);
$('#435_ListingHistoryTable').jqGrid('delRowData',997);

console.log($('#435_ListingHistoryTable').jqGrid('getGridParam','data'));// Data after delete

Data.Notes = 'YES DOIN FINE';

$('#435_ListingHistoryTable').jqGrid('addRowData',997, Data);

console.log($('#435_ListingHistoryTable').jqGrid('getGridParam','data'));// Data after add

/******End Commands

I get the following results in firebug

/*****Start results

// Data Before editing

[Object { ID="1000", more...}, Object { ID="1001", more...}, Object { ID="1002", more...}, Object { ID="994", more...}, Object { ID="996", more...}, Object { ID="997", more...}, Object { ID="998", more...}, Object { ID="999", more...}]//

//Data after delete

[Object { ID="1001", more...}, Object { ID="1002", more...}, Object { ID="994", more...}, Object { ID="996", more...}, Object { ID="997", more...}, Object { ID="998", more...}, Object { ID="999", more...}]//

//Data after add

/******End results

Notice that even though I asked it to delete ID=997 it decided to delete 1000 instead. So in the end I ended up with two rows with 997 as the ID and no row with 1000 as the ID.

Table definition is as follows:

jQuery('#435_ListingHistoryTable').jqGrid({
   datatype: 'local',
   colNames:[
       'ID'
       ,''
       ,'Date'
       ,'Price'
       ,'History type'
       ,'Notes'
   ],
   colModel :[
       {name:'ID',hidden:true, key:true}
       ,{name:'LoadIcon',hidden:true,width:16}
       ,{name:'Date',width:65,sorttype:'date',datefmt:'m/d/Y'}
       ,{name:'Price',width:80}
       ,{name:'Type',width:134}
       ,{name:'Notes',width:275}],
   gridComplete: function(){

   },
   ondblClickRow: function(selectedRow) {

   },
   rowNum: 999999,
   width: 554,
   height:'116',
   altRows: true,
   altclass: 'TableAlternate'
});

Any help is appreciated.

vrtinch on calling setRowData then sorting the table.

Mon, 25 Oct 2010 22:32:42 +0300

When using setRowData

The data is updated properly in the table until you sort.

THen the data goes back to what it was originally before setRowData was called.