Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to Change datatable default empty table message

Tags:

datatables

I am using datatable to list and sort the results.

This is how i initialized datatable

$('#example1').DataTable({bFilter: false, bInfo: false, paging: false});

It works fine. But i need to change the default table empty message No data available in table to No records found. Please help.

like image 480
drup Avatar asked Aug 13 '15 08:08

drup


2 Answers

$('#example').dataTable({
    "oLanguage": {
        "sEmptyTable": "My Custom Message On Empty Table"
    }
});

Reference: http://datatables.net/forums/discussion/2327/how-to-localize-the-string-no-data-available-in-table

like image 197
Ajinkya Avinash Aher Avatar answered Sep 16 '22 14:09

Ajinkya Avinash Aher


The answer by Ajinkya should still work because the library currently maintains backward compatibility with the old option format, but with more recent versions of the DataTables library (1.10+) you should use:

$('#example').dataTable( {
    "language": {
      "emptyTable": "No data available in table"
    }
} );

See: https://datatables.net/reference/option/language.emptyTable

Also, if you want to customize the info line when the table (or search results are empty):

$('#example').dataTable( {
  "language": {
    "infoEmpty": "No entries to show"
  }
} );

See: https://datatables.net/reference/option/language.infoEmpty

like image 30
Robert Groves Avatar answered Sep 17 '22 14:09

Robert Groves