Search

Hi there, Thank you for your prompt answer. I have tried this {"targets":[2,7,8,9,10,11], visible:false }, as solution in shared example and it worked but it is not applied to filter row as you can see on the picture below Thank you

i would like to filter on it : My dataTable

for the sort and filter type. You would use

I have managed to achieve what I want by doing a editor.on('preAutoFill') to filter out the columns with the "publicholiday" class. $('#testtable').DataTable().on('preAutoFill', function(e, datatable, cells){ for(var i =0; i < cells[0].length; i++){ if(cells[0][i].cell.node().className.includes("weekend")){ cells[0][i].set = cells[0][i].data; }else if (cells[0][i].cell.node().className.includes("publicholiday")){ cells[0][i].set = cells[0][i].data; } } });

You can use Orthoganl Data for this. Simply return the seconds value for the sort and filter types. Then return the human readable for everything else. Kevin

input data on main filter trigger search for every filters, but it's just custom

http://live.datatables.net/lidequra/56/ Filter by 210214 Export to Excel Link Gone

for the sort and filter. If you strip the

all rendering types (display, filter, etc). We're happy to

though I wish to filter users based on permissions.