Home > jQuery > jqGrid 4.0

jqGrid 4.0

Today we are happy to inform you that we have released the 4.0 version of jqGrid.
This release is a major with a lot of additions and bug fixes.

The full list of changes can be read here:
http://www.trirand.com/jqgridwiki/doku.php?id=wiki:change#jqgrid_4.4.0_changes_and_fixes

We have just begin to update the documentation and examples and they will be finished after some days.

Enjoy
Regards
jqGrid Team

Tags:
  1. April 10th, 2011 at 07:15 | #1

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

  2. Gonzalo
    April 11th, 2011 at 18:29 | #2

    Hi,

    Is this version jquery 1.5.x compatible ?

    Regards,
    Gonzalo.

  3. Pavel
    April 12th, 2011 at 20:42 | #3

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

  4. Hanno Schupp
    April 13th, 2011 at 06:49 | #4

    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

  5. Mikhail
    April 14th, 2011 at 12:35 | #5

    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.

  6. Mikhail
    April 14th, 2011 at 13:01 | #6

    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)

  7. Wooya
    April 14th, 2011 at 13:55 | #7

    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 😉

  8. andreas591
    April 18th, 2011 at 23:41 | #8

    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?

  9. April 19th, 2011 at 16:01 | #9

    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

  10. Inara
    April 22nd, 2011 at 09:34 | #10

    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.

  11. Swanand
    April 26th, 2011 at 07:18 | #11

    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.

  12. Иван
    April 26th, 2011 at 18:46 | #12

    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?

  13. Tigir
    April 27th, 2011 at 09:05 | #13

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

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

  14. Jerry
    April 27th, 2011 at 22:18 | #14

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

  15. ConCor
    May 1st, 2011 at 11:29 | #15

    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?

  16. Max
    May 3rd, 2011 at 07:16 | #16

    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!

  17. Max
    May 3rd, 2011 at 07:17 | #17

    list47 plist47
    instead of
    list48 plist48

  18. zizo
    May 3rd, 2011 at 12:06 | #18

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

  19. Vin
    May 3rd, 2011 at 23:30 | #19

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

  20. Wooya
    May 9th, 2011 at 08:39 | #20

    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.

  21. omar
    May 10th, 2011 at 14:28 | #21

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

  22. gbelmm
  23. teto
    May 16th, 2011 at 13:11 | #23

    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.

  24. pt
    May 17th, 2011 at 23:01 | #24

    @Hanno Schupp

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

    Does anyone actually monitor and respond here?

  25. May 19th, 2011 at 08:19 | #25
  26. superchen
    May 20th, 2011 at 20:52 | #26

    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?

  27. superchen
    May 23rd, 2011 at 07:04 | #27

    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?

  28. rekna
    May 23rd, 2011 at 16:33 | #28

    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 ?

  29. jayney
    May 24th, 2011 at 10:37 | #29

    Are there any java demo ?

  30. Nikhil
    May 24th, 2011 at 20:57 | #30

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

  31. pmendes
    May 25th, 2011 at 19:06 | #31

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

  32. db
    May 26th, 2011 at 14:36 | #32

    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!

  33. teto
    May 27th, 2011 at 12:40 | #33

    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.

  34. Andrea
    June 1st, 2011 at 02:58 | #34

    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.

  35. Adam K
    June 6th, 2011 at 15:14 | #35

    amazing grid solution . . when will documentation be updated ?

  36. QuinnZhuang
    June 7th, 2011 at 00:38 | #36

    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.

  37. A415Hz
    June 11th, 2011 at 20:01 | #37

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

  38. vami
    August 5th, 2011 at 18:24 | #38

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

  39. Cristian Ortiz
    August 23rd, 2011 at 15:38 | #39

    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

  40. Cristian Ortiz
    August 23rd, 2011 at 15:41 | #40

    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.

  41. Cristian Ortiz
    August 24th, 2011 at 03:50 | #41

    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.

  42. nagasurya
    March 15th, 2012 at 06:37 | #42

    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 🙂

  43. SeePar
    April 3rd, 2013 at 11:21 | #43

    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

  44. Ammar
    May 27th, 2014 at 13:48 | #44

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

  45. priyankmodi.20691
    July 30th, 2014 at 12:05 | #45

    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???

  1. June 2nd, 2011 at 16:05 | #1

Privacy Policy   Terms and Conditions   Contact Information