Hi sternr,

It seems to me it is very simple to implement your requirements. To be able to load local json you should define data: myData and datatype: 'local' or datastr: myJsonDataAsString and datatype: 'jsonstring' (depend on whether you have you JSON data alredy as an object myData or as a JSON string myJsonDataAsString). After the grid is created you can imediately change the grid datatype to 'json' with respect of setGridParam method (without calling of trigger('reloadGrid')):

jQuery(“#list”).jqGrid('setGridParam', { datatype: 'json' });

Next refresh of the grid (also sorting of a column or searching) will be send to the server. If you want that switching to the server data will be a little later, you can call setGridParam later.

Best regards
Oleg

Hi all,

I've just started to use this fantastic plugin and wish to thank everybody especially Tony.

This package is well integrated into DB, and even the sorting order works out-of-the-box !

However, it may be too much for a big application. A request would be for additional detail. A truely AJAX request would be to ask for the detail in addition to that already sent, so the grid needs to fill the new data into the required cells then show the additional column(s), somewhat similar to the goal of sternr to have local and ajax'ed data. I plan to have up to many tens' of additional columns.

To do this, I have to rewrite the populate / sortData methods in grid.base.js. Since this is deeply integrated into the grid's core, I may face heavy maintenance for every new version or well lock myself out of further changes in the trunk !

Is there any way out of this ?

OlegK, in my particular application where the grid is displaying lots of data in various rows and columns. When the user wants to have more detail on a specific cell (not row) by clicking it; the idea is to open up extra columns to show this extra detail. Something like a subgrid but in a vertical way. It would be wasteful to calculate and send all the existing data, including that of the extra detail; just send the extra detail would be sufficient. This reminds me of my previous applications where ajax updates only that part of the screen that needs updating.This helps to make applications that are fluid and responsive.

Why not update only that part of the grid that needs updating (where more detail requested by user). How would you use jqGrid to do this in a general way ? maybe using a complete MVC architecture where jqGrid is the visual component ?

And many thanks for discussing, OlegK.

Hi! I need to set total pages and record count in creation grid with “datatype: 'local'” for view pages info in pager after switch to “datatype:'json'”.

Set data by “datatype: 'jsonstring'” and “data:{'page':1,'total':2376,'records':'23754','rows':[10 rows]}” shows pages/record count from length of rows.

It is work if I use direct access to grid propertis, through “grid[0].p”:

Thanks! setGridparam works fine, but updatepager can use only through direct access.