Search

I'm not very familiar with using the dom option but that is probably what is causing it. Maybe try adding f to it, dom: "rtifS"? Just a guess. If that doesn't work, I bet removing that whole option would restore your filtering input.

You can use the filter_container_id property of my yadcf plugin, take a look http://yadcf-showcase.appspot.com/DOM_source.html notice that I moved the third column filter to the < div id="external_filter_container_wrapper" > , see examples on the showcase and code snippets below them (read docs)

The filtering options in DataTables are easily its weakest point at the moment and I plan to give it an overhaul in future. Currently there isn't really a workaround other than to modify the core code, so that it calls your function only once and you can do the loop, rather than DataTables doing the loop. Allan

Looks like i was looking for oSearch.

DataTables' column filtering is an AND operation - there is no option for OR filtering in the built in filtering. For that you would need a custom filtering plug-in: http://datatables.net/examples/plug-ins/range_filtering.html Alternatively, if you are only using 4 columns and two aren't filterable, you could just use the global filter? Allan

This seems to have done the trick - is this acceptable "aoColumns": [ { "bSearchable": false }, null, { "bSearchable": false } ],

See the FAQ.

@Allan. Thank you for the clue. Instead of changing the values using jQuery tags. I used fnUpdate to update the values.

Thanks very much. Its takes a while, but I get there :-) Yes, fnGetData and friends will work in 1.10. The 'New API' section of the upgrade notes mentions this: http://next.datatables.net/new/1.10 Allan

Problem solved, for anyone wondering, the solution was far simpler than i expected. I'm not saying this is the optimal solution, but atleast its a working one. In the server_processing.php file, there is lines for Filtering : [code] /* * Filtering * NOTE this does not match the built-in DataTables filtering which does it * word by word on any field. It's possible to do here, but concerned about efficiency * on very large tables, and MySQL's regex functionality is very limited */ $sWhere = ""; if ( isset($_GET['sSearch']) && $_GET['sSearch'] != "" ) { $sWhere = "WHERE ("; for ( $i=0 ; $i<count($aColumns) ; $i++ ) { $sWhere .= "".$aColumns[$i]." LIKE '".mysql_real_escape_string( $_GET['sSearch'] )."%' OR "; } $sWhere = substr_replace( $sWhere, "", -3 ); $sWhere .= ')'; } [/code] we are interested in the $sWhere variable, which contained previously [code] "".$aColumns[$i]." LIKE '%" [/code] Once the first % removed, it looks for the first characters an exact match as what you type in. (the second % ensure it still display all the "possible" results, not only exact matches.) Hope it helps other people, Flavio