title: DataTables: search all columns when server-side
body: <p>I'm using <a href="https://github.com/IgnitedDatatables/Ignited-Datatables/wiki" rel="nofollow">IgnitedDatatables</a> (CodeIgniter library) for <a href="http://datatables.net" rel="nofollow">DataTables</a>. The table gets generated without problems but if I search/filter it can only filter one column at a time. If I set "bServerSide" to false it works but then I lose the server-side functionality. </p>
  
  <p>In the examples, this one is working:
  <a href="http://datatables.net/release-datatables/examples/ajax/custom_data_property.html" rel="nofollow">http://datatables.net/release-datatables/examples/ajax/custom_data_property.html</a></p>
  
  <p>while this isn't (server-side):
  <a href="http://datatables.net/release-datatables/examples/data_sources/server_side.html" rel="nofollow">http://datatables.net/release-datatables/examples/data_sources/server_side.html</a></p>
  
  <p>Is this not possible to achieve when running server-side?</p>
  
  <p>This is my JSON response (shortened and with replaced data):</p>
  
  <pre><code>{"sEcho":0,"iTotalRecords":45438,"iTotalDisplayRecords":45438,"aaData":[["abc","12345","example@example.com","","","2010-01-27 22:31:10","Edit&lt;\/a&gt; Delete&lt;\/a&gt;"],["abc2"," test123","test@test.com","","","2008-06-15 22:09:33","Edit&lt;\/a&gt; Delete&lt;\/a&gt;"]],"sColumns":"fname,lname,email,phone,cellphone,created,edit"}
  </code></pre>
  
  <p>JavaScript code:</p>
  
  <pre><code>$("#members").dataTable( {
      "bProcessing": true,
      "bServerSide": true,
      'sAjaxSource': '&lt;?php echo base_url();?&gt;members/listener',
      "fnServerData": function ( sSource, aoData, fnCallback ) {
          $.ajax( {
              "dataType": 'json',
              "type": 'POST',
              "url": sSource,
              "data": aoData,
              "success": fnCallback
          } );
      },
      "bLengthChange": false,
      "aaSorting": [[ 0, "asc" ]],
      "iDisplayLength": 15,
      "sPaginationType": "full_numbers",
      "bAutoWidth": false,
      "aoColumnDefs": [ 
          { "sName": "fname", "aTargets": [ 0 ] },
          { "sName": "lname", "aTargets": [ 1 ] },
          { "sName": "email", "aTargets": [ 2 ] },
          { "sName": "phone", "sWidth": "80px", "aTargets": [ 3 ] },
          { "sName": "cellphone", "sWidth": "100px", "aTargets": [ 4 ] },
          { "sName": "created", "sWidth": "120px", "aTargets": [ 5 ] },
          { "bSortable": false, "sName": "edit", "sWidth": "115px",   "aTargets": [ 6 ] }
      ]
  });
  </code></pre>
  
  <p>Thank you!</p>