Datatables: Count rows with specific text

Question

I have a table with various columns and many rows. To simplify this, I just need to know how many rows are billable (in this case, column 2). In other words, how many rows in column 2 have the text "y"? Anyways, this is what I've tried so far:

jQuery

var billable = 0;

// attempt 1
table.rows().eq(1)( function () {
    if(table.data() === 'y'){
       //priceTotal+=parseInt(table.cell(row,0).data());
        alert('This is the billable column, now count which equal "y".')
        billable++;
    }
});  

// attempt 2
column(2).data() === "y"){
    alert('This is the billable column, now count which equal "y".')
    billable++;
}

http://jsfiddle.net/s827x/3/

have you considered using angularjs?

Dalorzo
– Dalorzo

2014-08-04 19:48:40 +00:00
Commented Aug 4, 2014 at 19:48 — Dalorzo
– Dalorzo, Commented Aug 4, 2014 at 19:48

meni181818 · Accepted Answer · 2014-08-04 20:35:21Z

2

with jquery we can select element by the index in the parent Element: :nth-child(), so simply:

$( ".our-table td:nth-child(2):contains('y')" ).length;

Just added to HTML (just in case):

<tbody class="our-table">

and using the :contains() Selector, we selecting all the <td> in column 2, that :contains('y')

demo: http://jsfiddle.net/s827x/6/

answered Aug 4, 2014 at 20:35

meni181818

1,1011 gold badge7 silver badges11 bronze badges

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

3 Comments

triplethreat77 Over a year ago

This works nicely for currently shown rows, but doesn't count the entire datatable. I have 197 rows.

meni181818 Over a year ago

@triplethreat77, can you please Give an example of your large table?, I tried with a large table and it seems to work. jsbin.com/porosoyu/1/edit

davidkonrad Over a year ago

also, datatables removes / injects <tr>'s / <td>'s when it filter rows / show/hide columns, so you could easily get a wrong result.

davidkonrad · Accepted Answer · 2014-08-05 07:31:08Z

1

Use the dataTables API to cycle through all the rows :

var rowCount = table.rows()[0].length;
for (var row=0;row<rowCount;row++) {
    if (table.cells(row, 1).data().indexOf('y')>-1) {
        billable++;
    }
}
alert(billable+' total');

forked fiddle -> http://jsfiddle.net/3C9Rk/

Note : Cells is zerobased, and the number of rows can be found multiple ways, the above is just an API example.

answered Aug 5, 2014 at 7:31

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

Comments

BenR · Accepted Answer · 2014-08-04 20:15:16Z

0

isherwood's example would work for an exact match, but this would also work if you're only looking for matches that contain a search term:

function countContaining(table, search) {
  var count = 0;
  $(table).find('td').each(function(e) {
    if (e.innerHTML.indexOf(search) > 0) {
      count++;
    }
  });
  return count;
}

answered Aug 4, 2014 at 20:15

BenR

2,9453 gold badges29 silver badges39 bronze badges

1 Comment

davidkonrad Over a year ago

table is a datatables API object, not a jQuery object.

Collectives™ on Stack Overflow

Datatables: Count rows with specific text

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related