jQuery DataTables - adding rows resets pagination and filtering

Question

I'm using jQuery DataTables in a console app.

The following code adds a row to the DataTable:

$('#datatable-table').dataTable().fnAddData([
    '<h1>test</h1>',
    'test',
    'test',
    'test',
    'test',
    'test',
    'test',
    'test',
    'test',
    'test',
    'test'
]);

The problem is, when you programmatically add a row, it resets the user's pagination and filtering. So if a user is on page 3, when I update the table, he will go back to page 1. Which doesn't really work for me considering I'm constantly needing to add/remove/update rows.

Any suggestions?

I guess I'm looking for something similar to this that isn't deprecated: datatables.net/plug-ins/api/fnStandingRedraw — Joel
– Joel, Commented Aug 2, 2015 at 4:27

Ash · Accepted Answer · 2015-08-02 09:36:20Z

4

Version 1.10 of jQuery DataTables has a page() method which allows you to get or set the current page of your table.

For example:

    var table = $('#myTable').DataTable();

    $('#btn').click(function() {
       table.row.add( [
           'new 1',
           'new 2'
        ]);

        var currentPage = table.page();  
        table.page(currentPage).draw(false);        
    });

After adding a new row, the code gets the current page, and then sets the table to that page when it is re-drawn.

jsfiddle demo here. Hope it helps.

edited Aug 2, 2015 at 9:36

answered Aug 2, 2015 at 9:26

Ash

2,1082 gold badges19 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gyrocode.com Over a year ago

There is no need to set a page, calling draw(false) is enough, see this jsFiddle.

Ash Over a year ago

Yes true but setting the page object gives you more options, such as moving to the next / previous page for example. I was just trying to demonstrate this.

Collectives™ on Stack Overflow

jQuery DataTables - adding rows resets pagination and filtering

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related