Filtering - an exact match

big-deal

Hey.

When filtering specific columns using a select - I don't want it to filter smartly.
If I filter by code for example, and I look for '1', I don't want it to find all the '1' as well as all of the '11'.
I wrote oSettings.aoPreSearchCols[ iColumn ].sSearch = '1'; oTable.fnDraw(); , and got '11' as well.
What can I do?

28.vivek.s

disable smart filtering and enable regex filtering by writing true as last argument in fnFilter();

Thanks,
Vivek

big-deal

I don't use fnFilter() but:
oSettings.aoPreSearchCols[ iCol ].sSearch = '1';
Hence, I do:
oSettings.aoPreSearchCols[ iCol ].bRegex = false;
oSettings.aoPreSearchCols[ iCol ].bSmart= false;

I also tryed:
oSettings.aoPreSearchCols[ iCol ].bRegex = true;
oSettings.aoPreSearchCols[ iCol ].bSmart= false;


Both didn't work out.
Any ideas?

28.vivek.s

disable both smart filtering and regx and use your own regular expression before passing the filter text ....try this..i have done this and got the exact result for which you are looking..

[code]
oSettings.aoPreSearchCols[ iCol ].sSearch = "^\\s*"+'1'+"\\s*$";
oSettings.aoPreSearchCols[ iCol ].bRegex = false;
oSettings.aoPreSearchCols[ iCol ].bSmart= false;
[/code]

let me know it works for you are not...

big-deal

Sorry - i forgot to update.
Worked like a charm - thanks.

chogger

Hello all, i have the same issue but i'm not shure were thislines of code belong to?

alanomaly

For anyone using fnFilter, to get an exact match you want something like this (assuming your table object is called oTable, like oTable = $('#some_id').dataTable(); ):

[code]oTable.fnFilter("^"+some_string+"$", some_column_id, true);[/code]

As for chogger's question, I couldn't find documentation on oSettings anywhere on this site, in the end I found it from stackoverflow... Looks like this:

[code]
// after creating the table and getting the table object...

var oTable = $('#some_id').dataTable();

// ...you can use it to get a settings object...

var oSettings = oTable.fnSettings();

// ...then you can do things with the settings object

oSettings.aoPreSearchCols[ iCol ].sSearch = "^\\s*"+'1'+"\\s*$";
oSettings.aoPreSearchCols[ iCol ].bRegex = false;
oSettings.aoPreSearchCols[ iCol ].bSmart= false;
[/code]

allan

> I couldn't find documentation on oSettings anywhere on this site

I feel that this is possibly the biggest weakness in DataTables at the moment... :-(. oSettings was never intended (way back when I started DataTables) to be publicly documented (it is however fully documented in the code, if you look in the file), but it has become increasingly important that this and all the other internals of DataTables are fully documented. When 2.0 happens I plan to restructure DataTables to have it make a lot more sense from this point of view and full automatic documentation as well

Until then, its a case of looking at the code if you want to mess around with the settings object.

Having said that, generally you shouldn't need to - for example all that you've done above can be done with the publicly documented fnFilter API method.

Regards,
Allan