Checking if datatable is empty

Question

I try to build a table which is both a JQuery treeTable and a JQuery datatable at the same time. Attention please, my problem is not about how to use it both, i can view without problem if i fill the "table".

But when i send an empty array to my treetable building code, i am getting error.

Here are problem lines:

$('#table tbody tr').each(function(){
                        console.log(this);
                        if(mytable.fnGetData(mytable.fnGetPosition(this))[4]){
                            console.log('in set child before');
                            $(this).addClass('child-of-'+mytable.fnGetData(mytable.fnGetPosition(this))[4]);
                            console.log('in set child after');
                        }
                        $(this).attr('id', mytable.fnGetData(mytable.fnGetPosition(this))[0]);
                    });

When i do not populate the table, despite my wish, the process goes through to the above loop, and

console.log(this) prints out:

<tr class="odd"><td valign="top" colspan="4" class="dataTables_empty">No data available in table</td></tr>

So it generates error, because the row data is not an expected one.

I want to ask, what is the most elegant way to control if it is a populated "data", or an empty warning row? Is checking the "class" for "dataTables_empty" an appropriate method?

Or is there any other way to not to go through above loop if table is empty.

i want an empty message to appear when table is empty, but also want to check if it is empty or not. anyway i am using $(this).find(td:first).hasClass('dataTables_empty') thanks anyway — merveotesi
– merveotesi, Commented Dec 7, 2012 at 10:32

David Zambrano · Accepted Answer · 2017-07-25 22:57:49Z

13

How know if Datatable is empty

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

if ( ! table.data().any() ) {
    alert( 'Empty table' );
}

answered Jul 25, 2017 at 22:57

David Zambrano

6587 silver badges13 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:02:30Z

6

You can also check if dataTable is empty using page.info() as described in this stackoverflow post. eg.

    //gives the total number of filtered records
    var totalDisplayRecord = $(".dTable").DataTable().page.info().recordsDisplay
(totalDisplayRecord === 0)? alert("table is empty") : alert("table is not empty");

or

//gives the total number of records in table
var totalRecords =$(".dTable").DataTable().page.info().recordsTotal;
//test if dataTable is empty
(totalRecords === 0)? alert("table is empty") : alert("table is not empty");

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Jun 14, 2016 at 22:39

Dev

4514 silver badges7 bronze badges

Comments

Ulrich Dohou · Accepted Answer · 2018-06-12 13:44:20Z

3

Another way

var count = $("table.dTable").dataTable().fnSettings().aoData.length;
if (count == 0)
{
   alert("Please enter the Data");
}else{
   alert("Table contains " + count + ' rows');
}

<table class="dTable"></table>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/datatables/1.10.16/js/jquery.dataTables.min.js"></script>

edited Jun 12, 2018 at 13:44

answered Apr 6, 2017 at 15:03

Ulrich Dohou

1,55914 silver badges25 bronze badges

1 Comment

elad silver Over a year ago

you could have just edited @elad silver answer instead of posting a new one that is the same but with an editor, thoughts for next time ;)

elad silver · Accepted Answer · 2015-05-18 08:44:03Z

1

from the forum this might be what you're looking for:

table.fnSettings().aoData.length

gives You the length of data in table. So if it will be equal to 0 then there is no data.

    if(table.fnSettings().aoData.length===0) {
        alert('no data');
    } else {
        alert('data exists!');
    }

answered May 18, 2015 at 8:44

elad silver

9,7716 gold badges47 silver badges71 bronze badges

1 Comment

elad silver Over a year ago

pretty old answer so please comment if it doesn't work

Collectives™ on Stack Overflow

Checking if datatable is empty

4 Answers 4

Comments

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related