tony on Pager Issues (with solutions)

Sat, 13 Sep 2014 13:12:23 +0300

Hello,

Thanks for posting this solution.

Best Regards

Tony

vital on Pager Issues (with solutions)

Tue, 26 Aug 2014 10:06:34 +0300

For those, who came here from google as i am, an updated solution for newer grid versions should look like:

onPaging: function(pgButton) {
Â Â Â Â Â Â Â Â Â Â Â  var newpage, last;
Â Â Â Â Â Â Â Â Â Â Â  if ("user" == pgButton) {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  newpage = parseInt($(this.p.pager).find('input:text').val());
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  last = parseInt($(this).getGridParam("lastpage"));
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  if (newpage > last) {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  return 'stop';
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }
Â Â Â Â Â Â Â Â Â Â Â  }
Â Â Â Â Â Â Â  },

davidelewis on Pager Issues (with solutions)

Wed, 29 Oct 2008 13:18:08 +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 should be incorporated into a future release of jqGrid.

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

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

tony on Pager Issues (with solutions)

vital on Pager Issues (with solutions)

davidelewis on Pager Issues (with solutions)