davidelewis on Pager Issues (with solutions)

Fri, 31 Oct 2008 12:09:16 +0200

Well ... perhaps it could be available as an option - something like:

jQuery("#grid_id").navGrid("#pager",{standard parameters}).validateParams(true);

tony on Pager Issues (with solutions)

Fri, 31 Oct 2008 01:22:28 +0200

Hello,

Thank you very much for this code.

I will think If I implement this - the reason is simple.

If you known that your table does not change the number of records for

long time this approach is OK, but in real world this is not true.

Imagine the user open a grid and stay for a long time to let say

page 3 (from 10 total). It is unknown how many pages we will have after

some time. It is possible to have 5 or 15 total pages.

So I prefer to check this server side.

Regards

Tony

davidelewis on Pager Issues (with solutions)

Wed, 29 Oct 2008 13:18:09 +0200

I've discovered two minor (but annoying!) issues with the pager component:

The interface allows a user to manually select a page number that is greater than the "current" last page.
The interface does not update the last page when the number of rows per pages is adjusted such that the last page will exceed the number of records.

Although both of these issues can be corrected with the server-side code that generates the row listing - this is not always possible (depends on how the server side implementation works). Therefore, I have added additional code to the "client" so that these issues are resolved before the request is made to the server:

$("#grid").jqGrid({
onPaging: function (pgButton) {
    // if user has entered page number
    if ("user" == pgButton) {
      // find out the requested and last page
      var requestedPage = $("#grid").getGridParam("page");
      var lastPage = $("#grid").getGridParam("lastpage");
      // if the requested page is higher than the last page value
      if (eval(requestedPage) > eval(lastPage)) {
        // set the requested page to the last page value
        $("#grid").setGridParam({page: lastPage});
      }
      // otherwise, if the number of records per page has changed
      } else if ("records" == pgButton) {
        // find out the requested page, totolal number of rows, and rows per page
        var requestedPage = $("#grid").getGridParam("page");
        var totalRows = $("#grid").getGridParam("records");
        var rowsPerPage = $("#grid").getGridParam("rowNum");
        // calculate what last page SHOULD be
        var lastPage = Math.ceil(eval(totalRows) / eval(rowsPerPage));
        // if the requested page is greater than what the last page should be
        if (eval(requestedPage) > lastPage) {
          // set the requested page to the last page value
          $("#grid").setGridParam({page: lastPage});
        }
      }
      ...
    }
}
});

I'd like to suggest that this solution be incorporated into a future release of jqGrid.

I've cross-posted this item in the "Discussion" forum ...

jQuery Grid Plugin - jqGrid - Topic: Pager Issues (with solutions)

davidelewis on Pager Issues (with solutions)

tony on Pager Issues (with solutions)

davidelewis on Pager Issues (with solutions)