jQuery Grid Plugin – jqGrid

@Riv,
Be a sure that you load the right css file (The problem of Thimoty). The currently name of the css file is ui.jqgrid.css and not grid.css. Ensure that this file is loaded – you can use FireBug for this purpose.

@tony

Thanks Tony, I just checked and it is using the correct stylesheet. I will post screenshots on the forum as soon as registration is working again.

Upgraded to the latest jqgrid. 3.5beta. I love the added features and functions. And also love the new min format. I’m using the latest css from github.

In the pager, the “page” input field, is about half the height it should be.

The HTML/Javascript code for the grid:

http://pastie.org/494831

The problem:
http://i631.photobucket.com/albums/uu32/glennswest/Picture1.png

I think the problem is, that the pg_input style is off a few points.
Playing in firebug, this seems to fix it up.
What is funny, is it looks fine in the demos, so the question is,
where is this getting changed. Or do I just have a bad css file?

The “bad” one, which is the one I supplied above, hs
the following for ui_pg_input
.ui-jqgrid .ui-pg-input {ui.jqgrid.css (line 38)
font-size:0.8em;
height:13px;
}

To get it right, needs to be I would think 21.

.ui-jqgrid .ui-pg-input {ui.jqgrid.css (line 38)
font-size:0.8em;
height:21px;
}
@glennswest

@glennswest

I updated my css, and it looks alot better.
Now the only cosmetic issue I see is the dialog boxes appear a bit small
on edit and view.

glennswest,
You should not update the grid css. You just need to add style element to your page and set these newvalues after the jqGird css file is loaded. The problem here is the jqGrid follow the concept of jQuery UI theming (I do not like so much this concept) – Setting the font size to percentage about 65%. If we do not have set this like you do, we really will have a problems.

@Riv
Could you please try a to have only jqGrid on the page, whitout to use any other plugins and CSS.
Best Regards
Tony

Hello All,
I have released a build 4 of jqGrid. A lot of bugs has been fixed. Also a new very usefull features are added too. Download the build and read the Changes.txt. We are close to the final.
Enjoy
Best Regards
Tony

Tony

I have noticed that in the 3.5 beta, the simple search module assigns the column model “name” value to the sField parameter whereas in previous versions it assigned the “index” value. Is this new behaviour?

Hi Tony,

I have formatted one of my date columns as ‘d M Y’. The data displays perfectly, but when I sort the column, it sorts it as a string, and not a date, e.g. 01 Apr 2009 appears before 01 Mar 2009. I have set the sorttype:’date’ on this column.

Any ideas?

Thanks!

Hi Tony,

I’m using XML as the data source for my one grid. The id column is of type GUID. Now, for some reason the multiselect functionality does not work. When I click on a row, the row is highlighted, but the checkbox is not checked.

For my grids where the id is of type int, it works perfectly. Any ideas?

Thanks!

@maj
Thanks. It is a bug. Fixed in GitHub.
@casperd (dates bug)
Thanks fixed. I added local sorting to support month names.
@casperd (GUID)
Sorry – the id can contain charatcters that are allowed for the id’s accordeing to WC3 recommendations
Regards
Tony

Good day!

I added my search button

….navButtonAdd
(
“#xxx”
, {
caption: “”
, title: “Search!”
, buttonicon: “ui-icon-search”
, onClickButton: function()
{
$(“#xxx”).trigger(“reloadGrid”);
}
}
).filterToolbar();

but when i pressed button, my search filter did not commit, why?

Thanks for help!

@tony
thanks _a lot_ for the new feature (footer), I was secretly dreaming for it … 🙂

Hey Tony

I get a syntax error if no data is returned to the grid. I followed the upgrade notes, but can’t seem to fix this. Firebug identifies the line to be 43 inside http://www.trirand.com/blog/wp-includes/js/tw-sack.js?ver=1.6.1. Which is bogus i think. Debugging in IE lead me to gridbase.js at line 744. This function:
$.parse = function(jsonString) {
var js = jsonString;
if (js.substr(0,9) == “while(1);”) { js = js.substr(9); }
if (js.substr(0,2) == “/*”) { js = js.substr(2,js.length-4); }
with(window) {
return eval(‘(‘+js+’)’);
}
};

This makes more sense as the json string is indeed blank. What would the proper fix for this be?

Thanks alot,
Roger

I found the issue around my “ghost” return false mentioned previously, inside the grid.base.js file there is a function as follows that was causing my checkbox to return false. I simply added a conditional to check for my class and if so, return true.

$(ts).before(grid.hDiv).click(function(e) {
td = (e.target || e.srcElement);
if (td.href) { return true; }
var scb = $(td).hasClass(“cbox”);
ptr = $(td, ts.rows).parents(“tr.jqgrow”);
if ($(ptr).length === 0) {
return false;
}

hi! great plugin!
i’m just having one (little) problem: i’m using autowidth: true which is a great feature btw, but it enables a horizontal scrollbar, which is kind of annoying 😀
would be great if you could fix this!

Hi Tony,

In 3.5 beta, Cell Edits in IE8 don’t work. Works perfectly fine in FF, IE 7, Safari but NOT in IE8. Are you aware of this problem?

Hi Tony,

The new search method is exceptional. Do you know the advanced filter builder from SmartGWT?? (http://www.smartclient.com/smartgwt/showcase/#featured_filter_builder_grid)

It’s the next step for you???

Thanks!!!

Hi Tony,
3.5 beta (4) is really a great step. I really enjoy working with it and it does exactly hoped for. One observation:
Hiding a column leaves ugly space on the right side, in 3.4 the Grid width was adapted. Is this wanted this way.

Thanks for the great work!

@Black
See the availbale event for triggering the toolbar search, triggering the grid will not work.
@RoJoBa
Thanks. Will check if the string is empty and if it is return empty object
@stefan
Try to play with the new scrollOffset option. See Changes.
@Nima
Thanks, but what you mean not work. Please be a more detail. To be a honest my I test hard onl;y in IE6 and IE7, but not so hard in IE8. Will definitley make tests
@Miguel
Thanks. Will speak with Kasey Speakman – which do this great plugin what they thing about this.

Regards
Tony

Thank you for this great code!!!

Tony, why does the 3.5 beta package include only the .min version of jqGrid?

I’m getting persistent errors that I can’t feedback to you other than to say, obvious typo, $.jgrid is undefined somewhere on long-line 9 of the jQuery.jqGrid.min.js.

Reverting back to 3.4.4 for the time being….

Hello Steven
In the download package there is a src directory where all the available code is. You can use the grid.loader.js in the same directory to load all the needed plugins.
Regards
Tony

Concerning the checkbox disabled looks and style in the grid, i’ve made a small change to the formatter to make the checkbox looks ok.


$.fn.fmatter.checkbox =function(cval, opts) {
var op = $.extend({},opts.checkbox), ds;
if(!isUndefined(opts.colModel.formatoptions)) {
op = $.extend({},op,opts.colModel.formatoptions);
}
//if(op.disabled===true) {ds = "disabled";} else {ds="";}
if(op.disabled===true) {ds = "";} else {ds="";}
cval=cval+""; cval=cval.toLowerCase();
var bchk = cval.search(/(false|0|no|off)/i)<0 ? " checked='checked' " : "";
return "";
},


@Basdub
Well it didn’t worked!!

Basically, i’ve set the ds to be “” or “”;

then, in the return string i’ve added onclick=’false;’

Hi Tony,

I love the plugin and was wondering if you had any plans to do a Fixed column feature so a column can stay fixed while all others scroll left and right. Please let me know if that is on the agenda of features.

Thanks
Peter

Hello, Tony! Thanks for your work! I am the beginner in your theme and I have some question about a demo-page http://www.trirand.com/jqgrid35/jqgrid.html: the Opera9.2x does not load json data into the table, only xml.

@Tony, thanks for answer, now my search button work!

$(“#mygrid”)[0].triggerToolbar();

Any word on when documentation is going to be updated or how long it takes after a release?

Looking at the documents/demos page, I was trying to do the multiselect, but the referenced script “cmultiex.js” isn’t anywhere in the downloaded files. Is the name of the script changed?

Where should we place the custom formatter functions? In the language file, or the jgGris js file?

The software is good. But it would be better if

a) Provide options for navigation during celledit. When Users can press up/down/left/right arrow key, it will automatically save and change to the next cell.
b) Allow users to specify “Select All” text in the header of multiselect checkbox.
c) Provide a “cell-editable” features. Users can decide specific cell are editable or not.
d) Allow Sortable in celledit.

Hey Tony, thanks for your constant work. Guess I’ve found a strange bug.
If value in row containts space or html tag, it will not be “deselected” after you “select” another row, so they will look like multiselect rows.

For example when I switch between rows with “Brunei”, “Bulgaria” and “Burundi” everything works fine, but if you click on row with “Burkina Faso” , “British Indian Ocean Territory” or any other row containgin space, or tag (e.g. France) then they will remain “selected” and will not be redrawn unless you switch to another grid page/refresh web page. At first I thought i’m doing smth wrong with “onSelectRow” but it’s absolutely same without it. I’m getting this behaviour in both 3.5 beta build 3 and 4.
Any ideas? I’ll be glad to provide any additional info.

maj :
Tony
I have noticed that in the 3.5 beta, the simple search module assigns the column model “name” value to the sField parameter whereas in previous versions it assigned the “index” value. Is this new behaviour?

Sorry to take this up again, I am using the new FilterToolbar, which is indeed a big enhancement. But I am geting the same behaviour as maj. Instead of the index value the colName is passed to the server.
Of course this is not a big problem, but I think it should be consistent for all search possibilities. By the way I use the newest downloads from gitHub.

hpoe :

Sorry to take this up again, I am using the new FilterToolbar, which is indeed a big enhancement. But I am geting the same behaviour as maj. Instead of the index value the colName is passed to the server.
Of course this is not a big problem, but I think it should be consistent for all search possibilities. By the way I use the newest downloads from gitHub.

Sorry, found my error in the colModel.
It’s working ok now.

Anyone reported issues around IE6 “forever loading” the png images for the theme applied? Will this issue be resolved before the RTW?

Thanks – a great piece of work.

Hi,

Formidable component, great new features!

In previous versions a little red corner appeared in the search button whenever a search filter was applied. Will the red corner be available in this new version?

Thanks

@Toran Billups
I have the same issue!

@Basdub
Look at what is new in the formatter in order to enable the checkbox

@tikanya
In my Opera 9.6 all work ok. Sorry, but I do not have Opera 9.2 and maybe will not try to fix the issues with it.

@Mark
The documentation will go on when we have final 3.5 You understand that some things can be changed during the last releases.

@Xelgen
Could you please provide a link to the problem. It is very strange.

@hpoe
Thanks. There was a bug in all search modules. With build 5 (or last download from GitHub) these issues are resolved. Also all search methods now use the index and if the index is not found we use the name.

@joe
Thanks I will consider your recommendations.

@Toran
@Jeff
Yes there is problem in IE6. This behaviour is on my testing machine too. I consider this to be problem with IE6 and png rendering instead that from UI Team say that the rendering should work in IE6. I have success with this if I load the scripts at end of the page

Hi,

Great to see the ThemeRoller-esque release, looking good!

Noticing a couple of possible issues on a ui.tab that has a split container (floating left & right divs)

1) The ‘editmod*’ and ‘alertmod’ need CSS of “position:absolute”
2) The pager needs to take into account the possible horizontal scroll bar – seems fine on other ui.tabs that have simpler layouts (quick fix for this was “margin-top: -15px”

Keep up the good work, thanks =)

@tony what scripts need to be loaded at the end of the page to correct this issue in IE6?

@tony

I moved the scripts to the bottom of a small test page.
I have the the “forever loading” issue with both IE6 AND IE7!!

Thanks,it’s good job.

Can you add a boolean param for onCellSelect-Method to prevent default click(and set Chkbox selected) action. pls see blow:

multiselect : true,
//multiboxonly : true,

onCellSelect : function(rowid, iCol, cellcontent) {
switch (iCol) {
case 1 :
show_card(grid_id, rowid);
break;
}
}

When i click on cell-1 (cell-0 is checkbox) ,do the func show_card(),then this row IS selected. so i hope i can control whether the defalut click action(select) is triggered or not.

thanks again~

ps: i use 3.4x

Tony, thanks for your efforts.
I try to set the grid font size but it doesn’t work. When I change .ui-widget font-size it is only active for the title. Any idea ?

Thank you

@Jeff
I investigate this problem
@waiting
onCellSelect can return true or false. If false the row is not selected. See docs.
@Dominique
You can open the ui.jqgrid.css file and set the fontsze here, but I recommend you to do this in your page by example
.ui-jqgrid {font-size:12px;}

Dear Tony,

Thanks your great effort. It really help.

By the way, I have found that in JQGrid 3.5 Beta, you have fixed the scroll bar problems in MS IE 6 and 7 (In 3.4.x, when the vertical and horizontal scroll bar are used, when clicking to the last column, the header and detail will not be matched).

Thanks. But If I want to fix the bugs in 3.4.x (which I am currently use), how can I do ?

Thank you

Hi,

When loading all data in one go but still providing paging args, grids only load first 20 results – workaround seems to be adding “rowNum”:100000000000 to constructor params (this is using unchanged code that worked with 3.4.4, so guessing regression).

Experiencing a couple of things; tried to implement cellFormatter but it hangs (FireFox/FireBug don’t spot infinite loop or anything, but do stop script) – might be my implementation but the parameter order appears to have changed: formatter:function(el, cellval, opts){…} seems to be formatter:function(cellval, el, opts){…} but script still hangs.

cheers,
Caspar (earcam)