Pager resets to page one after table rebuild

[dandanknight]

Hi Mottie,

I've just updated to 2.15.12 from 2.13, the pager plugin I was using (jquery.tablesorter.pager.js) was dated 5/27/13.

I have a table with a large number of items, an ajax call refreshes the table every few seconds, and rebuilds the entire table in the fashion...

$.ajax({
    type:'GET',
    url: 'some/url',
    success:function(data){
         var tbl_body = "";
         $.each(data, function(){
               tbl_body += makeRow(this);
          }); 
          $("#dbTable tbody").html(tbl_body);
          $("table").trigger("update");
    }
});

With the new pager plugin, after this happens, the pager goes back to page one as soon as the trigger update is executed, whereas the old pager plugin maintained the page that it was previously on.

Is this something I am doing incorrectly, has a feature changed, or is it a bug?

I am initializing my table as follows....

    $("#dbTable").tablesorter({
    theme : "blackice",
    widthFixed: false,
    cssChildRow: "tablesorter-childRow",
    headerTemplate : '{content} {icon}',
    widgets : [ "uitheme", "filter", "resizable", "saveSort", "zebra"],
    widgetOptions : {
        filter_ignoreCase : true,
        filter_reset : ".reset",
        resizable : true,
        resizable_addlastcolumn : true
    }}).tablesorterPager({
        container: $(".pager"),
        size : 10,
        cssGoto  : ".pagenum",
        savePages : true,
        removeRows: false,
        updateArrows: true,
        output: '{startRow} to {endRow} of {filteredRows} ({totalRows} total)'
    }));

I'd very much appreciate your help/input.

Thanks.

[Mottie]

Hi @dandanknight!

Hmm, back in v2.14.4 , I added some code to always reset the pager to page zero when a table is filtered (see issue #456).

For now, you can bypass this code by changing this pager event listener (ref):

$('#dbTable')
    .unbind('filterStart.pager')
    .bind('filterStart.pager', function(e, filters) {
        this.config.pager.currentFilters = filters;
    });

In the next update, I'll add a pager option to reset the page to zero if desired.

[dandanknight]

Hi!
Works a treat, thanks very much.
Cheers

[Mottie]

I ended up adding a pager pageReset option which can either be set to a page number or false to disable the reset.

Thanks!