Hello Vivaldi,

In my opinion you do can use jqGrid to implement dynamic table. But loading of current data from the server on every row select or cell select I find not good. The developer of jqGrid found this also not good and not implemented this kind of “dynamic tables” in the jqGrid. The reason is easy to explain. If you do so, and a some row before selected row is inserted then the selected row must be one row below after the data refresh. This behavior will make the user

Hi!

Now I understand you problem. It can be very easy implemented with respect of jqGrid. Look at my old answer on the stackoverflow.com.

You should define 'change' event handler on the select html element with contries and call trigger('reloadGrid') on your jqGrid to refresh the data on any select of net contry. Moreover, you can send in all requests to the server the curent value selected in the 'country' select element. To do this you can use postData with functions as the value of some properties. I recommend you also insert in all select lists like 'country' the option with the text 'All' and the empty value. This option could be default. This will allows to get unfiltered data.

You can also use filterToolbar to implement the same bevavior inside of jqGrid. I prefere to use stringResult:true option additionally to stay compatible with the advanced searching.

How you can see jqGrid is very flexible and allow you impelment different scenarios.

Best regards
Oleg

Hello Vivaldi!

1) If you use mtype: 'GET' the values from postData will be just concatinated to the value of url parameter of jqGrid. To be exactly the values will be encoded with respect of encodeURIComponent function. Before concatianting postData value to url will be verified whether url already contain '?' in not yet then the '?' will be inserten between url and converted postData. If '?' alreasdy exist, then '&' will be used like between on different properties of postData. For example if url:'/myDataProvider' and postData: {city:”New York”,regionId:2} then the destination url will be '/myDataProvider?city=New+York&regionId=2'. So it is very easy in use.

Morover if postData: {city:function() { return $(“#country option:selected”).val(); },regionId:2} then on every reload of data will be get the current selected value from the drop-down list with id=”contry” (# selector mean 'id' and not 'name' attribute): '…'

2) you should better never use event handle like “onchange” direct in HTML code: ''; It is every old style, it has many disadvantages. For example myReload() funtion must be global which is bad because of different reasons.

It seems to me that it is a new question. Nevertheless…

Nothing is impossible. But some things are a little tricky. What do you asked for can be realized outside of jqGrid (as external filters) very easy. The realisation of the same scenario inside of jqGrid is do possible but a little tricky. One can define use dataEvents property of editoptions and define 'change' custom event handle. In the handle you can make an ajax request to the server (I recommend you include caching of this ajax request, because information about coutries will be changed not so friquently) and then rebuild element of the secton column.

You can searach the forum for the corresponding examples. For example here you will find discussion and examples on the subject.

Best regards
Oleg