Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to count the number of rows in a jqGrid?

People also ask

How to get row count in jqGrid?

Note also that, as Mike commented, you need to use the getGridParam method with the records option to retrieve a count of all the rows if you are using pagination. Note that if you have paging turned on in your jqGrid, this function will just return the number of rows shown on this page.


jQuery("#myGrid").jqGrid('getGridParam', 'records');

Update

Note there are two parameters to determine record count:

records

integer

Readonly property. Gives the number of records returned as a result of a query to the server.


reccount

integer

Readonly property. Determines the exact number of rows in the grid. Do not confuse this with records parameter. Although in many cases they may be equal, there are cases where they are not. For example, if you define rowNum to be 15, but the request to the server returns 20 records, the records parameter will be 20, but the reccount parameter will be 15 (the grid you will have 15 records and not 20).


$("#grid").getGridParam("reccount");

Readonly property. Returns integer. Determines the exact number of rows in the grid. (And not the number of records fetched).

More information here.


Here is the code I have so far. It seems like there should be a better way:

jQuery("#myGrid").getDataIDs().length;

How about this?

jQuery("#myGrid tr").length;

Actually, you can take that a step further with the optional context parameter.

jQuery("tr", "#myGrid").length;

Either one will search for every "tr" inside of "#myGrid". However, from my own testing, specifying the context parameter is usually faster.