jQuery Grid Plugin – jqGrid

I’m a big fan of jqGrid. using on my many projects. Thank you very much for all of it.

Hi,

Is this version jquery 1.5.x compatible ?

Regards,
Gonzalo.

THANKS. WIll check the demo out asap. Is in this release the bug (prev, next,) navigation fixed with each unique id?

I installed version upgraded from 3.8.2 to 4.0 and got a jQuery(“#listSales”).getPostData is not a function

Doing a search on the 4.0 source file shows no result for ‘getPostData’ as a search term. Has this function been replaced (and if so by what) or is this a bug?
Please advise

Why don’t you guys implement minimum column width parameter for colmodel instead of having hard-coded value of 33px? 🙂 i have to do it by myself with every update. It’s quite easy to do, and usefull. Looking forward for that feature.
And thanks for your work again. Really best js tables component. Love it.

Oh and i forgot one thing. When we have lot of columns, 20 for example, and 100 rows at page – we see very slow perfomance on horizontal scrolling. Column headers and cells become unsynchronized for a short time (and after short time they get back to normal align)

Hi jqGrid DEV!

Best free JS grid ever! Keep on good work, and please implement column freezing first 🙂 Implementing PDF, XLS export can be done without jqGrid. I did export (in one of my projects) to PDF via tcpdf class, and Excel export by PHPExcel class – so it’s not so necessary to implement directly in jqGrid 😉

Hi Wooya,
I think the same as you that JQGrid should not further implement invest much effort into Excel export. PHPExcel is the better working and more professional choice. Since I use ZEND as datamodel there is even no chance to get the jqgrid run with excel export.
One question: can you provide an example how you mastered to export the _full_ grid content into excel? There are only two examples out there:
a) the one from qjGrid-Team. This approach can export the all data but needs to build db-select statements (which is not a good approach if one has OR-mappers in use)
b) the one from stackoverflow. This approach only exports the visible data that are present currently at the client.
I understood that you have some other solution?

Hello,

I am Jason and I represent the most trusted low-cost web hosting reviews in the market.
I am really amused with the way you present your ideas/concepts on your site.

Would you be open in discussing a sensible business proposal or some sort of sponsorship?

Thanks,

Jason Nash

Since the forum seems somewhat unreadable currently (lines are just trailing off the side of the screen), I’m posting this here as well:

It appears there has been in a change in handling for column width in the new version. In past versions, jqGrid used the defined width to set the column width *including* any margin/padding. Now, the column itself is given the full width assigned in the colModel, with the margin and padding added on. Would it be possible to add a setting to toggle it back to the old behavior? It’s much easier to get the grid to align with other fields on-screen when the column sizes include the extra spaces, and I would prefer not to have to update the colModel for every grid just to get them back to displaying as they used to.

Thanks for all of your continued work on this project.

Hi,

May i know when will the updated documentation and the examples will be released for 4.0? And if its being released, where can i search for it?

Thanks a lot.

Wooya :
Hi jqGrid DEV!
Best free JS grid ever!..

It’s confusing to me. On site there is section Licencing/Pricing. You say that it is free. I don’t understand. Is jqGrid free?

@Иван
Иван, сам грид бесплатен, платным является его серверная реализация для PHP, ASP – Ñ‚.е. компоненты.

http://www.trirand.com/blog/?page_id=154 – вот собственно о свободе в 1 пункте и сказано

Could we also get the update on demo page for the new features? We need to learn from good examples. Thanks!

When i upgraded to 4.0.0 the add button in the grid is functional for 1 time. When the button is clicked for the second time, the application gives a error.

What is the reason for that error?

Typo on demo page > grouping > simple grouping with array data

The html portion says

When it should be

based on jquery

Otherwise fantastic my friend thank you!

list47 plist47
instead of
list48 plist48

I work with tapestry1.5
How can I use jqGrid4 with tapestry.
If you have a exemple, please send to me.

You folks are doing some amazing work. It would be good if you’ll can separate JqGrid plugin from the commercial product.

andreas591 :
One question: can you provide an example how you mastered to export the _full_ grid content into excel? There are only two examples out there:
a) the one from qjGrid-Team. This approach can export the all data but needs to build db-select statements (which is not a good approach if one has OR-mappers in use)
I understood that you have some other solution?

I’m using SELECT based approach. I’m building a dynamic query based on filters used at current grid and then exporting to XSLX file via PHPExcell class.

Hello when i can find and download free jqgrid for php 5 ?
thanks

@omar
here

http://jquery4php.sourceforge.net/index.php?section=components&module=jqGrid&method=basic

Hi.
There is a bug in a function fillData(). There is a fragment:
if(fld && fld[0] !== null) {
…
}
, where even if fld is an empty array, fld[0] !== null returns true and first of the “fld[0]….” calls inside that if block fails. You should use different comparison.
Sorry I posted it here instead of forum, but I’m just lazy to register.

@Hanno Schupp

Similar issue. After an upgrade to 4.0, the function setPostDataItem() is not recognized.

Does anyone actually monitor and respond here?

@pt
Please read here:
http://www.trirand.com/jqgridwiki/doku.php?id=wiki:upgrade_from_3.8_to_4.0.0

Regards
Tony

hi,tony.
Recently i met a problem in my project。
The problem is：
I use multiple search in my project,but it doesn’t work well in ie8.
In order to reappear the problem。
first，you can open website http://www.trirand.com/blog/jqgrid/jqgrid.html
second,click New in version 3.7 and choose muliple search.
third,click search button in the grid.
forth,choose Name in the search dialogue,then you cann’t select begins with option.
I want to know how to solve this problem?

Recently i met a problem in my project。
The problem is：
I use multiple search in my project,but it doesn’t work well in ie8.
In order to reappear the problem。
first，you can open website http://www.trirand.com/blog/jqgrid/jqgrid.html
second,click New in version 3.7 and choose muliple search.
third,click search button in the grid.
forth,choose Name in the search dialogue,then you cann’t select begins with option.
I want to know how to solve this problem?

jQuery(”#grid_id”).jqGrid(‘setPostData’, newdata)
jQuery(”#grid_id”).jqGrid(‘appendPostData’, newdata)

are both replaced by

jQuery(”#grid_id”).jqGrid(‘setGridParam’,{postData:newdata})

Both can not be replaced by exactly the same function???? As a matter of fact, the replacement is only the equivalent to appendPostData, but where is the right syntax for the setPostData ?

Are there any java demo ?

Awesome will check it out…thanks for the loads of features in the earlier version too..

Using jqGrid since 2009 🙂
Thanks for the fantastic job you’re doing here!!

Hello Tony,

The multiple language support doesn’t work in the new search module, i.e. select options and button’s titles… This is sure quite easy to fix. It would help if you define the variables with default values and update the locale files later. When can the community expect the first bug fix (4.1) and the documentation update?
Thanks for the grate plugin!

I had a problem with jqGrid4 in FF with jQuery 1.6. I had an edit form with “checkbox” field and I wasn’t able to save “on” value if it was checked. It saved “off” regardless of if it was checked in or out. I found out that the problem was in function getFormData, in the fragment:
——————–
case “checkbox”:
if($(this).attr(“checked”)) {
postdata[this.name]= $(this).val();
}else {
var ofv = $(this).attr(“offval”);
postdata[this.name]= ofv;
}
break;
—————-
Problem is, that $(this).attr(“checked”) returns “undefined” even if checkbox is checked. I have replaced it with $(this).is(“:checked”) to get a correct results. $(this).val() returns “on”, as expected.

Very nice, but can you do a real example with jsp on google app engine? Would be very nice to see this technology working togheter.

amazing grid solution . . when will documentation be updated ?

I am trying to use the Formatter plugin to support desired date format, like “Y-m-d H:i:s”, with the inline editor. But the checkDate function inside grid.common.js will not take it. How should I handle the date invalidation? It looks to me that I can only display the date in a specific format, but input.

@teto
Hi, I think you need to use jquery 1.6.1 because 1.6.0 removed some of “checked” events. But 1.6.1 I hear they made the events back like they used to be.

But also, jqgrid 4.0 is compatible with 1.5.2, but not officially with 1.6+ yet I think.

@superchen
Have same issue. Search dialog operator dropdown gets disabled in IE8

Hey Guys. i am learning JQGrid. as it´s very great plugin. i have one question. i hope any of you can help me out. i want to export the grid to excel or PDF using JAVA as Server technology can somebody help me out. i have seen a lot of example using PHP. thanks a lot.

sorry by my poor english by the way.
thanks a lot

by the way i am Oracle Certified Professional if you need help with Java. let me know i will try to help. thanks a lot.

hey guys i am here once again. i want to change the headers of the grid and columns width and column names dynamically…
loaded from the server. i am doing this $(“#list10”).setGridParam({‘colNames’:myArray2}); but the headers is not getting refresh. thanks a lot.

Hi,
Recently I upgraded my JQGrid version from 3.8 to 4.3. In this upgrade am facing date format issue, because I have used the below mentioned format functions
$.jgrid.formatter.date.srcformat=’d/m/y’;
$.jgrid.formatter.date.newformat=’m/d/Y’;
After upgrade I am getting the resultant format as NaN/NaN/NaN. Can you please let me know what needs to be done to resolve this issue?

Thanks in advance 🙂

I have few queries, Please help me in it:-

#1. How can i achieve insert new row in between 2 rows and saving its state in jQGrid
#2. How can i save the state of dragged row/ column in jQGrid

Best free grid i want to know 4.0 version of jqGrid is free open source or not please guide me.

hi,
i develop small application using java spring MVC and implement jQgrid but problem is i am not able to fill data in jQgrid it becomes blank,
what is do??

i submit my code here

DemoController.java

public ModelAndView getDemoData(HttpServletRequest req, HttpServletResponse res, DemoFormBean frmb) {
ModelAndView mv = new ModelAndView();
Map param = new HashMap();

param.put(“FORMBEAN”, frmb);
try {
String rpt = serv.getDemoData(param);
System.out.println(“Final Data Come=” + rpt);
mv.addObject(“rpt”, rpt);
} catch (Exception e) {
System.out.println(e.toString());
}
mv.setViewName(“./report”);
return mv;
}
—————————
DemoService.java

public String getDemoData(Map param) throws ClassNotFoundException, SQLException, IOException, JsonGenerationException {
String json = “”;
List rs = null;
javautill jsonParser = new javautill();
DemoFormBean objFormBean = (DemoFormBean) param.get(“FORMBEAN”);
String sidx = objFormBean.getSidx();
int page = objFormBean.getPage();
int rows = objFormBean.getRows();
rs = (List) manag.getDemoData(convertentitytoform(param));
json = jsonParser.parse(rs, sidx, page, rows);
return json;
}
————————
DemoDataManager.java

public List getDemoData(DemoEntityBean entb) throws ClassNotFoundException, SQLException {
List returnList = null;

Statement stmt;
Connection conn;
Class.forName(“oracle.jdbc.driver.OracleDriver”);

conn = DriverManager.getConnection(“jdbc:oracle:thin:newpay/newpay1@172.16.32.132:1522:eitldb”);

stmt = conn.createStatement();
String sql;
sql = “SELECT name,address FROM PAY.z_temp_201407”;
ResultSet rs = stmt.executeQuery(sql.toString());

returnList = new ArrayList();
while (rs.next()) {
Map mp = new HashMap();
mp.put(“name”, rs.getString(“name”));
mp.put(“address”, rs.getString(“address”));
returnList.add(mp);
}
rs.close();
conn.close();
return returnList;
}
—————————–
index.jsp

Please Fill Information
 

<!—->

———————–
report.jsp

${rpt}

————————-

any one can help me what i do???