title: jQuery Datatables Search only one column
body: <p>I am using jQuery datatables and ColdFusion. I am trying to have search field that will search only the first column (ITEM ID) so when you start typing into ITEM ID it will only search the table for the ITEM ID section and not all columns since due_date and QTY will also have similar numbers.</p>
  
  <p>jQuery</p>
  
  <pre><code>var oTable = $('#processing').DataTable( {
  $('#ItemID').on( 'keyup', function () {
        oTable.search($(this).val()).draw() ;
      });
  </code></pre>
  
  <p>HTML - CF</p>
  
  <pre><code>&lt;div class="col-xs-8"&gt;
       &lt;label for="ItemID"&gt;ITEM ID&lt;/label&gt;
           &lt;div class="input-group"&gt;
               &lt;input type="text" class="form-control" name="ItemID" id="ItemID" maxlength="15"&gt; &lt;span class="input-group-btn"&gt;
               &lt;button type="button" class="btn btn-default" id="Search"&gt;SEARCH&lt;/button&gt;
          &lt;/span&gt;
  
           &lt;/div&gt;
  &lt;/div&gt;
  
      &lt;table id="processing" class="table table-hover"&gt;
               &lt;thead&gt;
                      &lt;th&gt;&lt;b&gt;ITEM ID&lt;/b&gt;&lt;/th&gt;
                      &lt;th&gt;&lt;b&gt;DUE DATE&lt;/b&gt;&lt;/th&gt;
                      &lt;th&gt;&lt;b&gt;STATUS&lt;/b&gt;&lt;/th&gt;
                      &lt;th&gt;&lt;b&gt;QTY&lt;/b&gt;&lt;/th&gt;
              &lt;/thead&gt;
    &lt;tbody&gt;
      &lt;cfoutput query="processTable"&gt;
         &lt;cfif #Date_Complete# EQ ""&gt;
          &lt;tr&gt;
             &lt;td class="LAlign"&gt;#id#&lt;/td&gt;
             &lt;td&gt;#dateFormat(processTable.Date_Due, 'mm/dd/yyyy')#&lt;/td&gt;
             &lt;td&gt;PROCESSING&lt;/td&gt;
             &lt;td&gt;#Item_Count#&lt;/td&gt;
          &lt;/tr&gt;
       &lt;/cfif&gt;
     &lt;/cfoutput&gt;
   &lt;/tbody&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>cfc</p>
  
  <pre><code>&lt;cffunction name="displayTable" access="public" returntype="query"&gt;
      &lt;cfset var processTable = ''&gt;
      &lt;cfquery name="processTable"&gt;
          SELECT id, Date_Due, Date_Complete, Item_Count
          FROM dbo.Dealer_Track_Work      
      &lt;/cfquery&gt;
      &lt;cfreturn processTable&gt;
  &lt;/cffunction&gt;
  </code></pre>
  
  <p>What I tried (along with many other combinations):</p>
  
  <pre><code>"aoColumnDefs": [
              { "bSearchable": true},
              { "bSearchable": false},
              { "bSearchable": false},
              { "bSearchable": false}
          ],
  </code></pre>
  
  <p>So basically I just want to search only the ID column. Any help with this would be greatly appreciated!</p>