Search

Solved. <style> [type="search"] {width: 70%;} </style>

See updated AlphabetSearch plug-in that allows to use numerical filtering and adds row grouping, ordering and localization support. See more articles about jQuery DataTables on gyrocode.com.

Yes - the demo script on this site will use a LIKE statement with wildcards. As tangerine highlights, you'd need to modify whatever server-side script you are using since you are using server-side processing. Allan

As a guess, I bet you are encountering a javascript error so the script stops executing. Open up your console (f12) and try reloading your page and see if any errors show up. Also, look at the raw html that your php is creating after the page is loaded and see if it looks right.

Hi, I'm new to datatables, I had a simular problem, the code below solved my problem. I call it before applying the filter, it updates the datatable based on the current html. if you are using ajax data try "table.ajax.reload();" instead. [code] table .rows() .invalidate() .draw(); [/code] Hope this helps, Cheers Patrick

Try configuring your DataTable with the following options: ajax, make sure and read the "Related" section deferRender

Also can I get the data of the currently selected row? Yes - see the select API integration documentation. Allan

thanks

I found a work around that worked for us. I just reused the column.search() function once the table was ready. Hope this helps var lastCat = 'the category'; var table = $('#Products').DataTable({ "iDisplayLength": 40, initComplete: function () { this.api().columns('3').every( function () { var column = this; var select = $('<select><option value="">All Categories</option></select>') .appendTo( $(column.footer()).empty() ) .on( 'change', function () { var val = $.fn.dataTable.util.escapeRegex( $(this).val() ); column.search( val ? '^'+val+'$' : '', true, false ).draw(); } ); column.data().unique().sort().each( function ( d, j ) { if(lastCat === d) { select.append( '<option SELECTED value="'+d+'">'+d+'</option>' ) } else { select.append( '<option value="'+d+'">'+d+'</option>' ) } } ); $(table).ready(function() { column.search( lastCat ? '^'+lastCat+'$' : '', true, false ).draw(); }); } ); } });

You would need to implement a custom filtering plug-in for this. The built in "smart" filtering won't do that I'm afraid. Allan