How to show all rows in the jqGrid?

by


In the latest version of jqGrid, you can set rowNum to -1 to instruct the grid to always display all rows:

rowNum: -1

See the latest jqGrid documentation here.

Specifically:

Sets how many records we want to view in the grid. This parameter is passed to the url for use by the server routine retrieving the data. Note that if you set this parameter to 10 (i.e. retrieve 10 records) and your server return 15 then only 10 records will be loaded. Set this parameter to -1 (unlimited) to disable this checking.

Update

Unfortunately this behavior was broken in jqGrid 3.6.3. According to this post from Tony:

Yes, this is true. The reason is the new introduced scroll:1. In the future we will correct this behavior.

So the jqGrid developers are aware of this problem and apparently are planning to fix it in a future release. Unfortunately this post was from over a year ago…

At this time, all I can recommend is that you set rowNum to a very large number to simulate the behavior of -1.

You can also try whatispunk’s solution below of using rowNum: ''. However, I tried this on a grid containing local data (loadonce: true). When attemping to sort the rows all of the grid’s local data would disappear. So this solution does not seem to work for grids with local data, unless this defect has been fixed in a later version of jqGrid (I tested it on jqGrid 3.8.2). If you have feedback, please post a comment below!

Update – April 16, 2014

According to the jqGrid team this is now fixed:

I have added support to set different display values on pager select box including -1 for all.

I have not had a chance to test to confirm the fix, though. Presumably this change will be in the next release after jqGrid 4.6.0.

More Related Contents:

  1. jqgrid server side error message/validation handling
  2. jqgrid incorrect select drop down option values in edit box
  3. jqGrid does not render correctly in Chrome/Chrome Frame
  4. How to replace remapColums with remapColumnsByName in free jqgrid
  5. jqGrid add new column
  6. jQGrid, how to make a column editable in the add dialog but not during (inline) edits
  7. Resize jqGrid when browser is resized?
  8. jQuery jqGrid Show message when an edit row is complete
  9. jQGrid Column Chooser Modal Overlay
  10. jqGrid access cell data while it is being edited
  11. JQGrid Custom Sorting
  12. How can I preserve the search filters in jqGrid on page reload?
  13. Is there a full working example for a jqGrid ColumnChooser? [closed]
  14. Is JQGrid free?
  15. Customizing the Add/Edit Dialog in jqGrid
  16. Enabling Save button on JQ Grid with InlineEditing and CellEdit
  17. Sorting of jqGrid (v4.1.2) treegrid not working with Ajacency Model
  18. jQuery .animate function not responding properly
  19. Assign click handlers in for loop
  20. Reload an iframe with jQuery
  21. How to build simple jQuery image slider with sliding or opacity effect?
  22. How to check if the URL contains a given string?
  23. keycode and charcode
  24. Get the visible height of a div with jQuery
  25. Count the number of integers in a string
  26. Bootstrap 4: Uncaught ReferenceError: Popper is not defined
  27. How to tell which row number is clicked in a table?
  28. Consider marking event handler as ‘passive’ to make the page more responsive
  29. How to change URL in browser without navigating away from page?
  30. object, param, jquery

Leave a Comment