1.9 to 1.10 update conflict

schmolzp

Hi,
I have been using DataTables for years and think it's a great tool. I am wanting to update to version 1.10, but I have an issue. Currently we are using it on this page: http://sc.edu/study/majors_and_degrees/

On that page, I have set up the table to make the "Colleges" hidden column not searchable through the 'filter by keywords' input. However, on the 'filter by College or School' select dropdown I have used the fnFilter to then filter the table based on what the user chooses.

When I update to 1.10 and change the methods to use the new API, it will not let me filter through that select dropdown. I know it's because the 'columnDefs' searchable option is set to false on that hidden column.

In the previous version it allowed me to have a column not searchable through the filter input but still filterable in other ways. We really need that so that when a user searches 'arts' they don't get items that have 'College of Arts and Sciences' associated with it in the hidden column. If you try that in the page I posted above, you will get 6 results returned since we have the 'colleges' hidden column not searchable in that input. If we made it searchable, it would return a whole lot more results because they are several majors that belong to the 'College of Arts and Sciences' as you can see when you use the 'filter by colleges and schools' select dropdown. Is there another way to achieve this in version 1.10?

Let me know if you need more information on this. Thanks so much for any help you can provide!

allan

Thanks for the details - sorry to hear that the upgrade is causing issues.

Unfortunately, at the moment, if you mark a column as not searchable in 1.10, its not searchable, even via the API. So there isn't really a solution, other than to use custom filtering I'm afraid.

This, and a similar case with ordering is something that I plan to address in the API for the next major versions.

Allan

schmolzp

Ok, thanks for the quick response!

-Peter