JQGrid: Loading data into the footer row

by

Look at demo http://trirand.com/blog/jqgrid/jqgrid.html

and choose on the left tree “New in Version 3.5” and then “Summary Footer Row“.

In the example one set footerrow : true, userDataOnFooter : true option of the jqGrid. Then server add userdata block to the data sent back to jqGrid. You can read about userdata in http://www.trirand.com/jqgridwiki/doku.php?id=wiki:retrieving_data. If userdata block hat properties corresponds to the column names of the jqGrid, the data will be seen in the footer row.

If you need more information you should write which kind of data you use in jqGrid (JSON, XML, xmlstring, jsonstring, local and so on) and what kind of server do you use (PHP, ASP.NET MVC, WCF end so on).

UPDATED: If you use standard json mapping your data (no jsonReader option of jqGrid) from server look like

{ 
  total: "xxx", 
  page: "yyy", 
  records: "zzz",
  rows : [
    {id:"1", cell:["cell11", "cell12", "cell13"]},
    {id:"2", cell:["cell21", "cell22", "cell23"]},
      ...
  ]
}

So the data has no name of columns from colModel. If you have, for example, one column {name:’price’, …} inside of colModel and want to show total price in the last row of jqGid you should define footerrow: true, userDataOnFooter: true inside of the jqGrid options and your server should produce data like

{ 
  total: "xxx", 
  page: "yyy", 
  records: "zzz",
  rows : [
    {id:"1", cell:["cell11", "cell12", "cell13"]},
    {id:"2", cell:["cell21", "cell22", "cell23"]},
      ...
  ],
  userdata: {price:1240.00} 
}

If you use another jsonReader all stat unchanged. The only which you can define is to change “userdata” name to another name, but the value must be an object with the field name like you defined in colModel. Only values of this fields will be shown fat on the last row of jqGrid.

More Related Contents:

  1. jqGrid paging question
  2. How to fire loadComplete after new row is added in jqgrid?
  3. Linking from a column value in jqGrid to a new page using GET
  4. jqgrid reloadGrid with loadonce set to true
  5. How to adjust the column width of jqgrid AFTER the data is loaded?
  6. How to use free jqgrid properties to conditionally add actions buttons
  7. can jqgrid support dropdowns in the toolbar filter fields
  8. jqGrid resolve the grid pager ID dynamically?
  9. jqGrid data stored in browser cache?
  10. Jqgrid – grouping row level data
  11. How can i get jqgrid frozen columns to work with word wrap on
  12. How do I change selected value of select2 dropdown with JqGrid?
  13. jqGrid iterate over the grid Data in a subgrid
  14. Multiple search with multiplefields by default
  15. jqGrid : issue loading nested sub grid with local datatype
  16. JQGrid: How can I refresh a dropdown after edit?
  17. How to make Jqgrid frozen column word-wrap
  18. Jquery JQGrid – How to set alignment of grid header cells?
  19. jqGrid auto filter highlighting search result
  20. How to edit the selected cell on jqGrid
  21. jquery with ASP.NET MVC – calling ajax enabled web service
  22. jQuery modal dialog and jqGrid
  23. In JQGrid, Is it possible to use different formatter on grouping summary cell other than column formatter?
  24. why doesn’t Jqgrid frozen column seem to work with filter rows and filter heading?
  25. JqGrid Filter Rules – Can we filter based on an Array?
  26. How can I change the background color of a cell in a jqgrid custom formatter?
  27. Using bootstrap select2 with JqGrid form
  28. In-cell data bars in jqGrid – possible or not?
  29. Remove vertical lines in jqGrid
  30. jqGrid with automatic height; but has a max height & scrollbars

Leave a Comment