jQuery Grid Plugin - jqGrid - Topic: LiveGrid - Loop updateGridRows

jwinns on LiveGrid - Loop updateGridRows

Tue, 16 Nov 2010 17:18:12 +0200

I have already tried like that:

    complete: function(jsondata, stat) {
        if (stat == "success") {
            var thegrid = jQuery("#list")[0];
            thegrid.updateGridRows(JSON.parse(jsondata.responseText).d, "id", true);
        }
    },

but it does not work, only the last returned rows are in the Grid.

please help

JAY

jwinns on LiveGrid - Loop updateGridRows

Tue, 16 Nov 2010 16:59:40 +0200

Server-Side is ready.

the json url call first returns the full set of rows:

{"userdata": 1289918647843, "total": 2, "rows": [{"cell": ["1", "None", "8", "yes", "ddddddd", "ddddddddddddddddd", "dddddddddddddddd", "ddddddddddddddddddddd", "True", "True", "ddddddddddddddd", "9999999999999"], "id": 1}, {"cell": ["2", "", "0", "test", "jjjjjjjjjjjjj", "jjjjjjjjjjjjjjj", "jjjjjjjjjjjjjjjjj", "jjjjjjjjjjjjjjjjjjjjjjjjj", "True", "True", "jjjjjjjjjj", "None"], "id": 2}, {"cell": ["3", "", "3", "test", "", "", "", "", "False", "False", "", "None"], "id": 3}, {"cell": ["4", "", "None", "ddd", "", "", "", "", "False", "False", "", "None"], "id": 4}, {"cell": ["5", "", "None", "fffffffffffffffffffffffffffffffffffffffffffffffffffffffff", "", "", "", "", "False", "False", "", "None"], "id": 5}, {"cell": ["6", "", "None", "alt2", "", "", "", "", "False", "False", "", "None"], "id": 6}, {"cell": ["7", "", "None", "hure", "", "", "", "", "False", "False", "", "None"], "id": 7}, {"cell": ["8", "", "None", "8", "", "", "", "", "False", "False", "", "None"], "id": 8}, {"cell": ["9", "", "None", "8888", "", "", "", "", "False", "False", "", "None"], "id": 9}, {"cell": ["10", "", "None", "10", "", "", "", "", "False", "False", "", "None"], "id": 10}], "page": 1, "records": 13}

and after that it returns timestamp filtered results( To be updated in the Grid):

{"userdata": 1289919036281, "total": 1, "rows": [{"cell": ["1", "None", "newvalue", "newvalue", "ddddddd", "ddddddddddddddddd", "dddddddddddddddd", "ddddddddddddddddddddd", "True", "True", "ddddddddddddddd", "9999999999999"], "id": 1}, {"cell": ["13", "", "None", "newvalue", "", "", "", "", "False", "False", "", "9999999999999"], "id": 9}], "page": 1, "records": 2}

I need to know, how to update the Rows with every json url call, while keeping the first result. Is there any Solution for that?

Thanks.

JAY

jwinns on LiveGrid - Loop updateGridRows

Fri, 12 Nov 2010 19:12:40 +0200

Hi,
is there a way JqGrid (jsonreader) first get all records (of course) and then in a loop only get, on there server changed records and update them in the Grid? And how, with updateGridRows or addJSONData, ?
By now I do it like that, but this only reloads the Grid in a loop and every time loadComlpete it gets the full Dataset(and there is an Problem when Scroll is=true,then the Grid gets empty while new data is requested):

jQuery(document).ready(function(){jQuery("#list").jqGrid({
url:'test.html',
datatype: "json",
colNames: any,
colModel: any,
rowNum:10,
rowList:[20,50,100],
pager: '#pager',
scroll:true,
loadComplete: function () {

    setTimeout(function(){
     jQuery("#list").jqGrid().trigger("reloadGrid", [{current:true}]);
     return false;

}, 1000);

},
loadError: function () {

    setTimeout(function(){
     jQuery("#list").jqGrid().trigger("reloadGrid", [{current:true}]);
     return false;

}, 15000);

},
caption: "any",
viewrecords: true,
gridview: true,
height: any,
width: any,
loadui:"disabled",});
jQuery("#list").jqGrid('navGrid','#list_pager',{search:true,add:false,edit:false,del:false});
});

THX

JAY