jQuery datatables - display row count on table

Question

I have a jQuery datatable on my view and i'm using pagination to display 10, 20, 50 or 100 rows on a single page. I would like to display somewhere on the table row count. So if i have say 400 rows displayed by 10 on each page message would be Showing 1 - 10 of 400 rows. I can't seem to find how to do it.

Solution:

(This event fires up when data is loaded into table, i can get data length and display it where ever i want)

table = $('#MyDataTable').dataTable({
            fnDrawCallback": function (oSettings, json) {
                console.log('Total row count on load - ', table.fnGetData().length);
            },

you want to show the message ` Showing 1 - 10 of 400 rows` in some other place in page , right ? — J Santosh
– J Santosh, Commented Aug 28, 2015 at 2:25
Yea, i had a problem since data comes with a little delay. I managed to find event that fires up when table is filled with data. it's table = $('#MyDataTable').dataTable({ //"fnDrawCallback": function (oSettings, json) { // //console.log('Total row count on load - ', table.fnGetData().length); //}, — azza idz
– azza idz, Commented Aug 28, 2015 at 8:30
it would help someone in future if post it as answer (as new post or as solution in your question itself) @azza idz — J Santosh
– J Santosh, Commented Aug 28, 2015 at 10:34

Gyrocode.com · Accepted Answer · 2015-08-28 01:52:36Z

11

You need to set info to true.

$(document).ready(function() {
    $('#example').DataTable( {
        'info': true
    } );
} );

Also if you have defined dom option, make sure there is character i present in the string, for example:

$(document).ready(function() {
    $('#example').DataTable( {
        'dom': 'lfrtip',
        'info': true
    } );
} );

answered Aug 28, 2015 at 1:52

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

Comments

double-beep · Accepted Answer · 2019-08-12 08:58:22Z

1

$(function() {
  $("#example").DataTable({
    "dom": '<lfip><t><ip>',
    "info": true
  });
});

edited Aug 12, 2019 at 8:58

double-beep

5,67019 gold badges43 silver badges50 bronze badges

answered Aug 12, 2019 at 7:17

Rajkishore Sahu

111 bronze badge

1 Comment

Cosmin Staicu Over a year ago

Please, add more details, to your answer, further explaining your code.

Jack Guy · Accepted Answer · 2015-08-27 20:35:39Z

0

You're going to want to take a look at this example. Use the option paginationType: 'full_numbers'

answered Aug 27, 2015 at 20:35

Jack Guy

8,5438 gold badges61 silver badges88 bronze badges

Comments

azza idz · Accepted Answer · 2015-09-24 12:32:41Z

0

Solution:

(This event fires up when data is loaded into table, i can get data length and display it where ever i want)

table = $('#MyDataTable').dataTable({
            fnDrawCallback": function (oSettings, json) {
                console.log('Total row count on load - ', table.fnGetData().length);
            },

answered Sep 24, 2015 at 12:32

azza idz

6633 gold badges13 silver badges28 bronze badges

1 Comment

azza idz Over a year ago

Why down vote it if i may know? This will give correct row number.

Collectives™ on Stack Overflow

jQuery datatables - display row count on table

4 Answers 4

Comments

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related