title: searching a jquery datatables
body: <p>I am using jquery datatables 1.10 and trying to search and filter a table. I would like to use a search text box that searches two columns and a check box to filter the results of a third column. Here is my datatable:</p>
  
  <pre><code>var url = '@Url.Action("SupportClass1Search", "SupportClass1")';
  $('#SupportClass1DataTable').DataTable({
      "serverSide": true,
      "processing": true,
      "ajax": url,
      "ordering": true,
      "dom": '&lt;"top"prl&lt;"clear"&gt;&gt;t&lt;"bottom"&gt;pi&lt;"clear"&gt;',
      "pageLength": 10,
      "autoWidth": false,
      "columns": [
          { // create a link column using the value of the column as the link text
              "data": "SupportClass1Id",
              "width": "20%",
              "render": function (oObj) { return "&lt;a href='#' onclick='editItem(\"" + oObj + "\")'&gt;" + oObj + "&lt;/a&gt;"; },
          },
          { "data": "SupportClass1Name", "sWidth": "70%" },
          { // convert boolean values to Yes/No
              "data": "Active",
              "width": "7%",
              "render": function (data, type, full) {
                  if (data == true)
                  { return 'Yes'; }
                  else
                  { return 'No'; }
              }
          }
      ]
  })
  </code></pre>
  
  <p>I want to filter the 3rd column (Active) based on a checkbox value. The JS below works to filter the table but is not picking up the Active column when I enter "Yes" or "No":</p>
  
  <pre><code>// use an outside search input
  oTable = $('#SupportClass1DataTable').DataTable();
  
  $('#btnSearch').click(function () {
      oTable.search($('#txtSearch').val()).draw();
  })
  </code></pre>
  
  <p>Also, I would prefer to search the Active column separately, kind of like this:</p>
  
  <pre><code>oTable
      .column(2).search('Yes')
      .columns([0,1]).search($('#txtSearch').val())
      .draw();
  </code></pre>
  
  <p>but this doesn't work. Any help is appreciated</p>