You can use hideCol method instead.

Yes it is Advanced Searching

I recommend you to use jqGrid 3.7.2 or jqGrid 3.8 beta from http://github.com/tonytomov/jqGrid/tree/dev. Nobody (probably only Tony) have the version or will be test the retro version specially for you.

In the current version there there are nice parameter loadonce:true. It switch datatype: 'json' to datatype: 'local' for you. Moreover in the current version there are full local sorting, paging and searching support. So your server can just send back the whole data.

Moreover local sorting and server side paging is not logical, because sorting are means through all data and not inside a page only. If you already implemented server side paging, that server side sorting will be only some lines of cod (probably only one line).

If you will have problem with the usage of last version or find a bug you will be quickly receive help from developers and from

Try to include key: true in the declaration of the 'ID' column.

Best regards
Oleg

Hi stephen!

You make very simple error. jQuery objects are a wrapper over array of DOM objects and the DOM object itself. If you use

var x = $(“#blabal”);

then x will be a wrapper to the arrays of DOM objects found by selector #blabal. It x.length === 0 then no elements are found. If do some elements are found, then you can access the elements with x.

So to display the id of the form identified by the jQuery object form you should use not the syntax alert(form.id) but alert(form[0].id):

beforeSubmit : function(postdata, form) {

Look at my http://stackoverflow.com/questions/3311929/is-there-a-way-to-programatically-set-a-filter-in-jquery-jqgrid/3337327#3337327 and http://www.trirand.com/blog/?page_id=393/help/toolbar-search-case-insensitive/.

I hope after examin this examples you could impement what you want.

To your other question. Parameter postData is very usefull if you want send additional information from the client to the server. For example url: “http://my.com/Svc”, postData: {country: “Germany”, langage: “german”} in case of HTTP GET requests follow to usage of url like http://my.com/Svc?country=“Germany”&langage=”german”. In case of HTTP POST request the data from postData will be placed to the HTTP body.

Usage of userData is a standard way to send an additional information from the server to jqGrid (see /jqgridwiki/doku.php?id=wiki:retrieving_data#user_data). jqGrid knows the parameter and save tha data as a part of internaldata. To get the data later from the jqGrid you can use jQuery(“grid_id”).getGridParam('userData').

Best regards
Oleg

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!

New 3.8 version of jqGrid which will be soon released has additional defaultSearch