Search

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

Basically you can't - its a private function. What I would suggest is you create a custom feature plug-in which just calls fnFilter (which is basically all _fnFilterCreateSearch does after it has made the input box). See: http://datatables.net/blog/Creating_feature_plug-ins Allan

Thanks Allan! Looks good, and it looks like what I was looking for.

Oh wow :) That was simple. Thank you so much!

I was able to figure it out using $sGroup = "GROUP BY accounts.accountname"; Added $sGroup after $sWhere Thank you