Tutorial :Jquery plugin DataTables, custom filtering



Question:

How can I set a custom filter in my code to ignore accents and special character from the table before filtering?

I am using DataTables plugin (http://www.datatables.net/)


Solution:1

Include a version of the data that is missing the accents as a column in the datatable. You hide that column by adding an entry in the aoColumns array in the configuration literal.

Let's say you start with 4 columns. One of these has accents. Add a fifth column with non-accented data, and add a configuration literal with { "bVisible": false } so that it will not be displayed.

It's invisible, but it's still searchable / filterable:

$(document).ready(function() {      $('#example').dataTable( {          "aoColumns": [               null,              null,              null,              null,              { "bVisible": false }          ] } );  });  

See the column documentation for more on configuration. DataTables with hidden columns is an example in use.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »