jQuery Grid Plugin – jqGrid

Update: I checked with 3.4.4 and now IE8 has the following message:
Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.2; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET CLR 4.0.20506)
Timestamp: Mon, 22 Jun 2009 16:57:20 UTC

Message: ‘undefined’ is null or not an object
Line: 90718037
Char: 21341
Code: 0
URI: http://localhost:6922/Subscriber/Edit/2

The first correct post is in the discussion for 3.4.3. As I checked it affects 3.4.5, the discussion spans both releases.

I found the problem. It was in the format of the data I was sending.

Issue with setPostDataItem:

To start with, jqGrid plugin has been really helpful in my project. It has loads of features and makes development a quick and enjoyable task. Keep up the good work.

Coming to the issue, in my project, I have added a dropdown list control to the jqgrid toolbar. The dropdown list maps to a column in the database table that is enumerable. The value selected from the dropdown list must be added to the search criteria.

In order to implement this, I used the appendPostData function to add the criteria to the query string. Also, I used to setPostData function to reset the page number to 1 whenever the value of the dropdown list changed.

This is where I ran into the issue. The setPostData in grid.postext.js function sets the value of p.postdata[“page”] to 1 where as the populate function in grid.base.js uses the p.page value to construct the query string.

In order to fix this issue I added a line of code in setPostDataItem to set the value of p.page to 1. This is not a perfect fix but I could get my code working after this.

setPostDataItem: function(key, val) {
var $t = this[0];
if (!$t.grid) { return; }
$t.p.postData[key] = val;
//This is done here because, originally, the function posted the
//new value to p.postData[“page”] but populate function in
//grid.base.js took value from p.page.
//So I have here put the value in p.page as well.
if (key == “page”) {
$t.p.page = val;
}
},

It would be great to see this bug fixed in the next release of jqGrid.

Thanks

Hi,Tony
I found a bug delRowData() will change array getGridParam(“selarrrow”).

see:
$(‘#gridid’).jqGrid(
　　…..
　　…..
.navButtonAdd(‘#gridid’, {
　　title : ‘del’,
　　onClickButton : function() {
　　var gr = $(‘#’ + st.gridsave_id).getGridParam(“selarrrow”);
　　var len = gr.length;
　　for (var x=0; x ‘2888’
　　　　$(‘#gridid’).delRowData( ‘save_’ + rowid);
　　}
},

when delRowData() run once, this rowid will be del from array gr,so next for-look the value of gr[x] may ‘undefined’, whill this time x > the real length of gr.
Instead of gr[x], blow works good:
var saveid = gr.shift();
var rowid = saveid.substring(5);

edit:
above ‘var gr = $(’#’ + st.gridsave_id).getGridParam(”selarrrow”);’ should be
var gr = $(’#gridid’).getGridParam(”selarrrow”);

it’s strange code corrupt in #5.
post again:

$(‘#gridid’).jqGrid(
　　…..
　　…..
.navButtonAdd(‘#gridid’, {
　　title : ‘del’,
　　onClickButton : function() {
　　var gr = $(‘#gridid’).getGridParam(“selarrrow”);
　　var len = gr.length;

　　for (var x=0; x<len; x++)
{
　　　　// alert(gr.toString());
　　　　// alert(gr[x]);
　　　　var rowid = gr[x].substring(5);
　　　　$('#gridid').delRowData( 'save_' + rowid);
　　}
},

nice work.

just a small (but important) thing- i just noticed that in the sql to create the tutorial example table the primary key declaration should read:

PRIMARY KEY (invid)

as the column ‘id’ doesn’t exist.

rob ganly

ah, also, in the colModel

sortname: ‘id’

should be

sortname: ‘invid’

then the example will work!

rob ganly

is jsonReader taking the same selectors as xmlReader ?
I’ve got a json response that contains properly formatted grid data
as one of the elements of the response:

{…
griddata:{total:”2″,…},
…}

so mapping like:

jsonReader:{
root:”griddata>rows”,
page:”griddata>page”,
…
}

should work, correct ?

lukasz

After searching/filtering a grid I want to export data in a csv file. How do I retrive grid search options and send them to an ajax request?

BUG in jqGrid 3.4.4
100% height in FF 3.5.1 not work

First of all, I want to thank the jqGrid team for its EXCELLENT work. This grid is the best there is for jQuery.
Now, I needed to develop some modifications for some project I’m working on, and I wanted to share them with the community. It’s all related with jqGrid’s multiselect, and the combination of this and subgrids.
If you’re interested, take a look at
http://www.undisciplinedbytes.com/2009/11/jqgrid-multiselect-a-little-improvement/

@Sathya
.jqGrid(‘setGridParam’, {
postData: {
….
},
page: 1
}).trigger(‘reloadGrid’);

how TO populate a DROPDOWN in sjg:gridcolumn on change one dropdown other have to change

I have a jqgrid with dropdown list as one column. But when I sort the dropdown column the values in that column are not gettin displayed. Can someone help me with this? Thanks!!!