OR Filter by multiple columns
OR Filter by multiple columns
[code]
var $datatable = $('table').dataTable();
$datatable.fnFilter( 'field0string', 0, true);
$datatable.fnFilter( 'field1string', 1, true);
[/code]
I think this will filter the first field, and then treat the second field as a sub-filter (eg 'and'-filtering). What's the proper way to 'or'-filter, which would return records where field0 contains 'field0string' OR field1 contains 'field1string'.
Browsing [older] forum posts, it looks like it was suggested to abuse the sSearch, but that is especially problematic if the same values may exist in other fields.
----
Please let me know if this is confusing. I didn't think an example was necessary as it doesn't show the problem.
var $datatable = $('table').dataTable();
$datatable.fnFilter( 'field0string', 0, true);
$datatable.fnFilter( 'field1string', 1, true);
[/code]
I think this will filter the first field, and then treat the second field as a sub-filter (eg 'and'-filtering). What's the proper way to 'or'-filter, which would return records where field0 contains 'field0string' OR field1 contains 'field1string'.
Browsing [older] forum posts, it looks like it was suggested to abuse the sSearch, but that is especially problematic if the same values may exist in other fields.
----
Please let me know if this is confusing. I didn't think an example was necessary as it doesn't show the problem.
This discussion has been closed.