Javascript to filter html table on column?

Question

I am trying to filter an html table on column values (vertically like MS Excel filter). I thought following code would work. It is failing, can someone help me understand why it is failing?

Error:

$("tr").each.find is not a function [Break On This Error]

$('tr').each.find('td').eq(coli)(function() {

the header row of the table has diff class applied to it, and body has diff class applied, if it matters...

        rowi = this.rowIndex;
        var coli = e.target.cellIndex;
        cellval = $('tr').eq(rowi).find('td').eq(coli).text();

    $("#filterbutton").click(function() {
        var row = new Array();
        $('tr').each.find('td').eq(coli)(function() {
                if ($(this).text() == cellval) {  //  you can add aditional filter criteria... || $(this).text() == 50) {
                    row.push($(this).index());
                }
            });
        $('th,td').each(function() {
            if (($.inArray($(this).index(), row)==-1) && ($(this).index() != '0')){$(this).hide();}
        });
    });

Blender · Accepted Answer · 2012-09-28 05:29:53Z

1

$('tr').each expects a function to call on each tr:

$('tr').each(function() {
    var $cell = $(this).find('td').eq(coli);

    if ($cell.text() == cellval) {
        row.push(this.rowIndex);
    }
});

edited Sep 28, 2012 at 5:29

answered Sep 28, 2012 at 0:57

Blender

300k55 gold badges462 silver badges512 bronze badges

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

Comments

ijse · Accepted Answer · 2012-09-28 00:58:02Z

0

$('tr').each.find('td').eq(coli)(function() {

should be:

$('tr td:eq(' + coli +')').each(function() { ...

answered Sep 28, 2012 at 0:58

ijse

3,0451 gold badge22 silver badges25 bronze badges

Comments

Sushanth -- · Accepted Answer · 2012-09-28 01:30:41Z

0

You are using the wrong syntax here.. Instead of

$('tr').each.find('td').eq(coli)(function() {
           if ($(this).text() == cellval) { 
              row.push($(this).index());
           }
   });

// Try this

$('tr').each.find('td').eq(coli)(function() {
      var $curr = $(this).find('td:eq('+ coli + ')') ; (OR) $(this).find('td').eq(coli) ; 

      if ($curr.text() == cellval) { 
          row.push($(this).index());
      }
   });

answered Sep 28, 2012 at 1:30

Sushanth --

55.8k9 gold badges70 silver badges109 bronze badges

Collectives™ on Stack Overflow

Javascript to filter html table on column?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related