CODEWITHSUNDEEP
jquerydatatables
stefun
stefun

Reputation: 1551

Show button if data table rows are empty

We want to show ADD User button or link in place of "No matching records found" message if we get 0 records. Also we need pass searched id with the link

How we can implement this.

Ex:

------------------------------------------------
                    ADD User link
------------------------------------------------

I was trying with :

"fnDrawCallback": function(retObj) {
        if(userTable.rows().data().length==0){

        }
 },

Edited:

 var userTable=$('#allUsers').DataTable({
    "processing": true,
    "serverSide": true,
    'responsive': true,"stripeClasses": [ 'odd-row', 'even-row' ],
    "aoColumnDefs": [
      { 'bSortable': false, 'aTargets': [1,2,3,4,5] }
    ],
    "ajax": {
                url: "users_list.php",
                type: 'GET',
                data: userData
    },
    "fnDrawCallback": function(retObj) {
        if(userTable.rows().data().length==0){
            console.log("0 records");
        }
    },
    "language": {
        "infoFiltered": "",
        search: "_INPUT_",
        searchPlaceholder: "Search...",
        "emptyTable": '<a href="/path/' + 1 + '">BOOK THIS COURSE</a>'
    },
    "pageLength": 10
    });

still getting "No matching records found" message.

Upvotes: 0

Views: 2168

Answers (1)

Gyrocode.com
Gyrocode.com

Reputation: 58880

Use language.emptyTable option to define a message when there are no records in the table.

For example:

var table = $('#example').DataTable({
   'language': {
      'emptyTable': '<a href="/path/' + 1 + '">Add new user</a>'
   }
});

See this example for code and demonstration.

Use can also use language.zeroRecords option to define a message when the table is empty due to filtering.

Upvotes: 2

Related Questions