Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to show all rows in the jqGrid?

jqGrid exposes a property rowNum where you can set the number of rows to display for each page. How do you set the grid to just display ALL rows?

Right now I'm just setting the rowNum to something really high like <%= int.MaxValue %> but I'm wondering if there is a better way.

like image 422
Jon Erickson Avatar asked Aug 06 '09 05:08

Jon Erickson


People also ask

What is rowNum in jqGrid?

jqGrid exposes a property rowNum where you can set the number of rows to display for each page.

How do I highlight a row in jqGrid?

If the row which you need highlight has the id 123 you can just use setSelection method for selecting: jQuery('#tab_Categorize'). jqGrid('setSelection', '123');

How do I add edit and delete button for jqGrid for every row?

Mention editLink and deleteLink in colModel name of edit and delete for display Edit and Delete button in jqgrid for each row. Show activity on this post. I got it, Just take additional column, and add formaater actions as model class. That's it.


1 Answers

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.

like image 89
Justin Ethier Avatar answered Sep 20 '22 22:09

Justin Ethier