Javascript to count the number of selected rows in jquery data table

Question

I have a java script to written to check the number of selected rows in a jquery data table. But the count doesn't works. Can anyone help in identifying the bug i made.

I may be silly please excuse and help me out.

var table = $("#jobsTable").dataTable();

$('#jobsTable tbody').on( 'click', 'tr', function () {
    $(this).toggleClass('selected');
    alert( table.rows('.selected').data().length +' row(s) selected' );
});

$('#batchAction').click( function () {

    alert("button is clicked");
    alert( table.rows('.selected').data().length +' row(s) selected' );
    var selectedRows = table.rows('.selected').data().length ;

    if( selectedRows === 0){
        alert("Zero rows selected. Please select jobs to proceed with bulk Operation");
        alert( table.rows('.selected').data().length +' row(s) selected' );
    }

});

Your code isn't very clear. I think you don't need `data()` when counting the rows. There is also a similar question already answered: http://stackoverflow.com/questions/1149958/jquery-count-number-of-rows-in-a-table — cezar, Sep 04 '15 at 11:38

score 4 · Answer 1 · answered Sep 04 '15 at 11:39

4

why just not?

$('#jobsTable tbody').on( 'click', 'tr', function () {
  $(this).toggleClass('selected');
  alert( $('#jobsTable tbody tr.selected').length + ' row(s) selected' );
});

It have to works right. If it is not - call me.

answered Sep 04 '15 at 11:39

Legendary

2,243
16
26

What count it alert for u? @user3253099 – Legendary Sep 04 '15 at 14:57

score 1 · Answer 2 · answered Sep 04 '15 at 11:39

1

I think

alert( table.rows('.selected').data().length +' row(s) selected' );

should be

alert( table.rows('.selected').length +' row(s) selected' );

That selector would return the number of rows of class "selected"

answered Sep 04 '15 at 11:39

Velimir Tchatchevsky

2,812
1
16
21

score 0 · Answer 3 · answered Mar 04 '17 at 21:29

Here's a direct, simple way to do it. Use DT's count() function.

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

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

This comes from an example on the data tables website itself, found at https://datatables.net/reference/api/count()

Javascript to count the number of selected rows in jquery data table

3 Answers3