jQuery Grid Plugin - jqGrid - Topic: JSONString vs. URL

CaptainPalapa on JSONString vs. URL

Tue, 11 May 2010 00:43:56 +0300

macbuoy said:

...

Is there some reason I should use the setTimeout() instead?

In my testing, I never needed it. I just used one of the callback functions (can't remember them now) that after my load, I just flipped it back. Wasn't any need for the timeout.

macbuoy on JSONString vs. URL

Tue, 11 May 2010 00:04:09 +0300

In Tony's solution, will setting the datatype back to "json" work via the gridComplete event like this:

$("#mygrid").jqGrid({

url:'url_to_the_server_json_data',

datatype:'jsonstring'

datastr: actual_string_data_here,

gridComplete: function(){$("#mygrid").jqGrid('setGridParam',{datatype:'json'}); }

…

});

Is there some reason I should use the setTimeout() instead?

CaptainPalapa on JSONString vs. URL

Wed, 11 Nov 2009 09:29:09 +0200

Thanks, Tony. I had dome quite a bit of searching, but didn't stumble across the answer.

I had actually tried this same concept, unsuccessfully. I didn't utilize correct format, though, for:

$(”#mygrid”).jqGrid('setGridParam',{datatype:'json'});

But definitely working now. Exactly what I needed!

tony on JSONString vs. URL

Wed, 11 Nov 2009 03:48:48 +0200

Hello,

IMHO There is a easy way and the solution is posted here many times

$("#mygrid").jqGrid({

url:'url_to_the_server_json_data',

datatype:'jsonstring'

datastr: actual_string_data_here,

...

})

// If your string data is relative big, make a settimeout to ensure that the new option will work

setTimeout(function() {$("#mygrid").jqGrid('setGridParam',{datatype:'json'}); },50);

// now you are ready to accept server requests

Regards

Tony

montag on JSONString vs. URL

Tue, 10 Nov 2009 16:53:42 +0200

I was thinking through the same problem last week and i solved it like this. Start out with your datatype set to a function, that loads your initial data via "$table[0].addJSONData(initialResults)", and then make that same function overwrite the datatype property [itself].

var url = "/researchCatalog/Search/ProviderGridData/";
var gridData = getGridData(url, searchParams)
var colModel = gridData.colModel;
var initialResults = gridData.initialResults;
var datatype = function() {
            //there's a little bit of trickery going on in this function
            //so that we can create a jqGrid with initial results,
            //and also hook into all of the auto AJAXy stuff built into the grid
            //when initially creating the grid we use a function as the datatype,
            //but in the function we reset the grids datatype to json
            $table[0].addJSONData(initialResults)
            //reset the datatype variable to json so it will make calls on its own
            $table.setGridParam({ datatype: "json" });

}

        $table.jqGrid({
            url: url,
            datatype: datatype,
            colModel: colModel,
            pagerpos: 'left',
            pager: $("#" + pagerID),
            pgbuttons: true,
            gridComplete: function() {
                RSCat.ContentManager.resizeGrid($table);
            },
        });

CaptainPalapa on JSONString vs. URL

Tue, 10 Nov 2009 14:43:28 +0200

I see the note:

"If you use a jsonstring to obtain the data - after the data is retrieved the datatype option automatically is set to local - i.e. (currently) the paging will not work!"

I had been hoping, when doing our test setup with jqGrid, that I'd be able to "preload" the first, say, 10 records of a dataset to avoid the inital Ajax call. Then, using the pager, you'd go to page 2, and the Ajax call would occur.

Is this possible? Even based on that note, is there a way to override that functionality in some format? Direct hit to the object, anything?

- WB