Datatable jump to specific page on load

Topic: Datatable jump to specific page on load

NitinMistry asked 6 years ago

Hi,

I would like to jump to a specific page when the DataTable is loaded, specifically the last page as after adding a new row to the bottom of the table list, I would like to navigate to that page to show the user that the newly added record is available in the list.

How do I achieve this?

Add comment

Mikołaj Smoleński staff answered 6 years ago

1 0 Best answer

Hi there,

The easiest way is to trigger click event just after initialization or data update. Here's the example code:

  $('#dtBasicExample').DataTable();
  $('.dataTables_length').addClass('bs-select');
  let pageItems = $('#dtBasicExample_wrapper').find('.page-item');
  pageItems.last().prev().click();

Best regards

Add comment

NitinMistry answered 6 years ago

0 0 Best answer

Thanks Mikołaj. This works perfectly fine.

On a side note, how do I remove sorting on specific columns? Right now the DataTable has sorting on all columns and I can't seem to figure out how to remove from specific ones on which I do not want any sorting.

Add comment

Mikołaj Smoleński staff answered 6 years ago

0 0 Best answer

Hi there again,

For this moment sorting works in the simplified way. You can only turn it on or off for the whole table.

Best regards

Add comment

NitinMistry answered 6 years ago

0 0 Best answer

Too bad. Anyway, thanks for the reply Mikołaj.

Add comment