Question

38

How to count the entire number of rows in a datatable

rated 0 times [ 39] [ 1] / answers: 1 / hits: 104535 / 9 Years ago, wed, may 20, 2015, 12:00:00

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

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

taylert

Add To Favorites

Follow

Total Points: 627

Total Questions: 91

Total Answers: 108

Location: Mayotte

Member since Mon, Sep 12, 2022

2 Years ago

taylert questions

1 How to format date in v-Calendar?

Tue, Jul 28, 20, 00:00, 4 Years ago

1 Check if at least two elements in an array are greater than zero - JavaScript/Typescript

Mon, Feb 17, 20, 00:00, 4 Years ago

1 How do a date range validation with vue/Quasar

Tue, Dec 10, 19, 00:00, 5 Years ago

1 JavaScript: When to use a Class vs. a prototype?

Fri, Sep 13, 19, 00:00, 5 Years ago

1 Is there a generic way to set state in React Hooks? How to manage multiple states?

Tue, Jul 9, 19, 00:00, 5 Years ago

View All

answered 9 Years ago xavier · Accepted Answer

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/