exact value search by select box
exact value search by select box
srimanta12
Posts: 12Questions: 0Answers: 0
Hi,
I am trying to filter a table by a select box having only two values "Active" and "Inactive". Whenever I am trying to filter through "Inactive" then the accurate list of records are fetching but when I am trying to filter through "Active" then all the records having "Active" as well as "Inactive" are showing. I can understand, this is happening for wild cards searching. So how to solve this issue? Is there any option I have to add in the following code:
[code]
$("#example").dataTable().columnFilter(
{ aoColumns: [
null,
null,
null,
null,
null,
null,
null,
{
type: "select",
values: [ 'Owner', 'Superadmin', 'Admin','Agent' ]
},
null,
null
]
}
);
[/code]
Please help me.
I am trying to filter a table by a select box having only two values "Active" and "Inactive". Whenever I am trying to filter through "Inactive" then the accurate list of records are fetching but when I am trying to filter through "Active" then all the records having "Active" as well as "Inactive" are showing. I can understand, this is happening for wild cards searching. So how to solve this issue? Is there any option I have to add in the following code:
[code]
$("#example").dataTable().columnFilter(
{ aoColumns: [
null,
null,
null,
null,
null,
null,
null,
{
type: "select",
values: [ 'Owner', 'Superadmin', 'Admin','Agent' ]
},
null,
null
]
}
);
[/code]
Please help me.
This discussion has been closed.
Replies
though i am not 100% sure but there is a property called "bCaseInsensitive" which by default is true why dont you make it as false and then try to filter.
Arjun