Filtering number by exact match

janwidmer

Hi,

I am using DataTables for displaying Results of a athletic competition over several years. It works like a charm, thanks a lot!!

Now I would like one of the columns to be filtered by exact match. I read a lot of forum questions here and on stackoverflow and I tried several different ways, but non of them seem to work.. The column is the 7th column (zero based nr. 6).

Here is my code:

DataTable Initialization:

[code]

"oSettings":{
"aoPreSearchCols":[
null,
null,
null,
null,
null,
null,
{ "bSmart" : "false", "bRegex" : "false", "sSearch" : "^\\s*"+'1'+"\\s*$" },
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
]
},
"aoColumns": [
null,
null,
null,
null,
null,
null,
{ "type" : "number", "sType": "numeric" },
{ "sType": "time-milli" },
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[/code]

I also tried it with setting it after initialization, but it didn't work either.

What am I doing wrong?

THanks for your help.
Regards Jan