jQuery Datatables refresh view

Question

I'm using jQuery DataTables and adding rows after a successful insert to a DB. How can I force a refresh of the table? I have checked on docs but found only how to refresh if data is loaded with Ajax. I'm adding to the tbody client side.

I guess it depends upon how you're adding your new row? If you're adding it by adding the data via markup (adding a <tr> and one or more <td>s) then it should show but won't be registered with DataTables and thus won't be searchable, orderable and what have you. If you're adding it using the table.row.add(...row data...), method then all is good, just add draw() to the end so: table.row.add(...row data...).draw(). Hope that helps. — annoyingmouse
– annoyingmouse, Commented May 3, 2017 at 6:42

Rohith K P · Accepted Answer · 2017-05-03 05:54:10Z

1

If you are using legacy datatable

      tableObj.fnClearTable();
      tableObj.fnAddData(data);
      tableObj.fnDraw();

also fnRedraw(), If you want to redraw the table

If you are using new Datatable then this may help you.

    var table = $('#example').DataTable();
    $('#myFilter').on( 'keyup', function () {
        table
            .search( this.value )
            .draw();
    } );


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

// Sort by column 1 and then re-draw
table
    .order( [[ 1, 'asc' ]] )
    .draw( false );

edited May 3, 2017 at 5:54

answered May 3, 2017 at 5:48

Rohith K P

3,5831 gold badge24 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

jQuery Datatables refresh view

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related