jQuery Grid Plugin – jqGrid

At end 3.0 (rc) version of jqGrid is out. This version is a major release, because I have totally rewrite the code for the methods without affecting the behavior of the plugin.
The grid is now compatible with jQuery 1.2.1, but in the example page I use 1.1.4 version of jQuery. The problem is that with 1.2.1 jqGrid has a little slowly behavior. I do not know why?
The example page is totally rewritten. Every example has a separate code for html and javascript. You can view this here.

This version fixes a lot of bugs relating to json data, formating, xml manipulation and add following features.

• The user can now manipulate the number of requested pages. This is done with adding a input box in the pager.
• I have added 4 methods – add, update, delete get row data. With these method we can manipulate the data at client side and of course a possibility to add local array data. See documentation for more information.
• Added is a method to load data only once from the server – loadonce flag in settings. After loading data we do all the manipulation at client side – sorting, scrolling ant etc. Note that in this case pager is disabled.
• Added is a new data type – local (against with xml and json). When this flag is set the grid expect data to be loaded locally via array.
• Now we can multi select rows. This can be done with only one flag multiselect. This feature can be used with server and local array data.
• For first time I introduce a sub grid. This feature can work only with xml data for now. The code and style for sub grid must be optimized and should be used with json too. See example page for more details.
• It is possible now to export the grid data to xml and json format. This is done with two new methods.
• A few new methods are added according to the new features – see documentation page for this.
• New theme of course

I have made a decision to go direct to version 2.0, since this release has a lot of new features and bug fixes. Thanks to all that helped me to make this better. I will begin with a fixed bugs.

• IE and Safari hanging when some values in the xml node are empty – i.e. <row></row>. Now I use a different approach – see the new features.
• IE does not format correct the table row if some data is empty – I analyze the data and add a space if it is empty.
• Sorting problem if we do not set sort property in the column model.
• Pager does not have correct navigation if we use a onSelectRow method and are on the first(last) page and clicking the first(last) or previous (next) page buttons.
• Now the Grid can read a xml file which is not returned from any server side language (thanks to Damian).

Read more…

I have updated the jqGrid to 1.1beta.
This version fixes a bug posted from Luca and add another feature – SubGrid.
Since I’m very busy with a project, I do not have time at the moment to describe all the new features (sorry). I hope that this will be done after some days.
The good news is that the grid is tested on IE6/7, FF1.05/2.0.0.x, Konqueror 3.5.6.
Only on Opera I have problems described from Luca.
Any comment and suggestion will welcome.

Searchdb is another jQuery plugin. The reason to write this plugin is that I’m a little be “lazy”. Imagine that you have a dynamic table (grid) or report in wich the user will search on many fields with diffrent criteria (equal, less, greater …). Constructing a form is a first problem. You must write so many tags and html code. The second and more importand problem is that I must analyze too much data passed to the server and construct it in a apropriate way in the WHERE clause of the SELECT statement. So, I think – will be possible to pass only one parameter (the search criteria) , which can be directly passed in the WHERE clause? My answer after little thik was – yes this can be done.
Read more…