jQuery Grid Plugin

jqGrid version 3.1 is out. This is bug fix release, but include a lot of improvements and new methods. There is a first user module add-on provided by Paul Tiseo. For full list of changes please refer to Relese notes in documentation page.

Enjoy

I’m happy that at end the 3.0 version of jqGrid is out. The good news is that the full documentation is ready. It was a hard work for me since my English is not very good. I apologize if there are some errors and hope to correct them with a help of community.

Enjoy.

Hi all. After a lot of work and help of community I have done the final release of jqGrid. The changes of the final release are big. First of all jqGrid have modular structure. The grid is divided in four modules - basic grid, inline editing module, subgrid module and the new form editing module. This way it is easy to do something into the module without changing the basic of the grid. The new form editing module uses two external plugins (I do not want to reinvert the wheel) jqModal and jqDnR from Brice Burgess.
The second news is that the grid has a lot of new themes. I hope you will enjoy them.
Of course there are a lot of bug fixes.
The preview release can be found here

This is not official release. It will be official when the documentation is done. I’m working hard on this.

I hope you will Enjoy

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).

Continue reading »

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.
Continue reading »

jQuery Grid is my first jQuery plugin. It is based on grid developed by makoomba. I have rewrite the code (and add a lot of new features), so that the grid can work with jQuery 1.1.2. The grid is a Ajax-enabled JavaScript control that provides solution for representing tabular data on the web. Since the grid is client-side solution and loading data dynamically through Ajax callbacks, it can be integrated with any server side technology.
Continue reading »