How to count the entire number of rows in a datatable

Question

I am using a datatable for my application. How do I get the total count of the rows in the datatable onload? My code:

$(document).ready( function() {
  $('#jobSearchResultTable').dataTable({
    responsive: true,
    "scrollY": 500,
    "scrollCollapse": true,
    "jQueryUI": true,
    "aaSorting": []
  });
)};

How to get the total count of rows in the datatable onload

dataTable is not defined showing – lucifer May 20 '15 at 10:25 — lucifer, May 20 '15 at 10:25

score 28 · Answer 1 · answered Sep 19 '17 at 17:45

28

If you're using the new DataTables (v1.10+), you don't have access to some legacied functions such as fnGetData().

Instead, try this:

var table = $('#table_id').DataTable();
var table_length = table.data().count();

If you're using paging (which I was), and need the total count across all pages, try this:

var table = $('#table_id').DataTable({
    'paging': true
});

var length = table.page.info().recordsTotal;

Sources:

https://datatables.net/reference/api/count()

https://datatables.net/reference/api/page.info()

answered Sep 19 '17 at 17:45

jpaik

281
3
5

table.page.info().recordsTotal; this works perfectly – Sourav Sarkar Dec 07 '17 at 08:51
2

table.data().count() gives the total number of cells (tds) in data table. table.data().rows().count() gives you the count of rows. – Srinivas Jan 11 '18 at 07:29
perfect answer for paging, Thanks!! – KUNWOO MYUNG Jan 23 '19 at 04:53
I think this should be the accepted answer! I'm using server-side paging and don't have access to all of the rows. This does the trick. – Eldy Apr 07 '21 at 14:18

Ruchan · Accepted Answer · 2021-09-19T09:35:07.620

17

Update for New Versions

table.data().count()

Reference:https://datatables.net/reference/api/count()

For older versions:

$(document).ready(function() {
 //Initialize your table
 var table = $('#jobSearchResultTable').dataTable();
 //Get the total rows
 alert(table.fnGetData().length);
});

Source: https://stackoverflow.com/questions/3238047/jquery-datatables-row-count-across-pages

Another method:

table.fnSettings().fnRecordsTotal();

see which one works for you

Source: http://datatables.net/forums/discussion/2278/how-to-get-number-of-rows/

edited Sep 19 '21 at 09:35

answered May 20 '15 at 11:30

Ruchan

3,124
7
36
72

3

does not work for me, the table is dynamic populated. – Priyank Bolia Dec 21 '17 at 10:14
1

I just tried. `table.fnGetData().length` is not working. `table.fnSettings().fnRecordsTotal();` works – Dika Jun 24 '19 at 15:09
table['context'][0]['aiDisplay'].length work for me even after search .Check my answer https://stackoverflow.com/a/58746208/5803974 – Satish Nov 07 '19 at 12:00
This solution doesn't seem to be working for me. But i tried the following "$('#TableId').DataTable().rows().count();". Hope this helps – Parth Kinjal Shah Jun 28 '20 at 04:23

score 9 · Answer 3 · answered Jun 11 '19 at 14:57

Get response from serverside processing following way it works for me:

// tested with : DataTables 1.10.15
t1 = $('#item-list').DataTable({
    "processing": true,
    "serverSide": true,
    "ajax":'url',
    "drawCallback": function( settings, start, end, max, total, pre ) {  
        console.log(this.fnSettings().json); /* for json response you can use it also*/ 
        alert(this.fnSettings().fnRecordsTotal()); // total number of rows
    },
    ...
});

None of the solution worked for me except this one. Cheers!!! — SuKu, Dec 04 '19 at 11:19

score 3 · Answer 4 · answered Mar 27 '18 at 03:50

3

$('#jobSearchResultTable').dataTable().rows().count()

answered Mar 27 '18 at 03:50

Praveen Kumar Thalluri

1,137
10
13

While this code snippet may solve the question, [including an explanation](http://meta.stackexchange.com/questions/114762/explaining-entirely-code-based-answers) really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion. – Derek Brown Mar 27 '18 at 04:22
@Praveen Please check after filter (search) in table – Satish Nov 07 '19 at 09:28
This has at least 2 problems: (1) you have to use `.DataTable()` not `.dataTable()` in order to use `.rows()`, and (2) it returns the FILTERED number of rows, not the total number. – user9645 Mar 22 '21 at 18:04

score 2 · Answer 5 · answered Nov 07 '19 at 09:59

I tried most of the solution from the answers but not worked for me.

Some work but when we search,it shows same number instead number of rows after search.

 var tbl=$('#tbl_name').DataTable();
 console.log(tbl['context'][0]['aiDisplay'].length);

Its worked for me even after search,shows current number of rows after search.

wupendra · Answer 6 · 2015-05-20T10:49:50.440

1

According to your description I assume that you have table with id="jobSearchResultTable".

Try this it could work for you.

$(document).ready( function() {
   $('#jobSearchResultTable').dataTable({
    responsive: true,
    "scrollY":  500,
    "scrollCollapse": true,
    "jQueryUI":       true,
    "aaSorting": []

   });
   var count=0;
   $('#jobSearchResultTable tr').each(function(){
      count++;
   });
   alert(count);

)};

This will show the no of rows in the table.

edited May 20 '15 at 10:49

answered May 20 '15 at 10:43

wupendra

76
8

but i want the total row count i.e it is showing the current page row count i.e if the table has 50 rows then i want the count as 50 ,not as 10 perpage – lucifer May 20 '15 at 11:06
I think this is the correct answer for you (http://stackoverflow.com/questions/3238047/jquery-datatables-row-count-across-pages?lq=1) – wupendra May 20 '15 at 11:41

score 1 · Answer 7 · edited Jan 24 '19 at 05:20

1

Please check out the following code

var table = $('#example').DataTable(); 
alert(
    'Number of row entries: '+
    table
        .column( 0 )
        .data()
        .length
);

edited Jan 24 '19 at 05:20

Ali

2,702
3
32
54

answered Jan 24 '19 at 04:45

Abdul khader

67
13

score 1 · Answer 8 · answered Oct 22 '21 at 11:14

1

October 2021 for Yajra Datatables

myTable.rows().count();

answered Oct 22 '21 at 11:14

CodeToLife

3,672
2
41
29

example : var table = $('#LGAllLegalCase').DataTable(); var oV = table.rows().count(); – udorb b Sep 14 '22 at 17:15

score 0 · Answer 9 · answered May 12 '17 at 16:23

0

//get number of entire rows
table.rows().eq(0).length;

answered May 12 '17 at 16:23

Abdo Bahhous

1

This should be a comment, not an answer. I know that you do not have the comment privilege, but you can get enough reputation in a single day... – Badacadabra May 12 '17 at 16:49

score 0 · Answer 10 · answered May 16 '18 at 12:30

0

I just read the table instance in console and got this in version 1.10.8

var table = $("#mytable").DataTable({})
var total = table.settings()[0].json.recordsTotal

Hope this helps

answered May 16 '18 at 12:30

jayson.centeno

835
11
15

How to count the entire number of rows in a datatable

10 Answers10