I am trying to evaluate if Hands on Table will be a good fit for my requirements. I could not find this setting anywhere. What I want to do is have some specific set of consistent filter (contains, does not contain, begins with, ends with, greater than, less than, is empty, is not empty) across all columns regardless of what type of data those cells contain. My data fluctuates a lot so it might be alphanumeric at various points. Also I handle all my filter through my backend. So my question is how do I add/remove what sort of filters appear on a column not specific to the column type?
The set of filter_by_condition is not alterable. If you have different types of data you get different types of filters. If you set type: 'text' to all of the columns filter_by_condition would show the standard set of conditions to all the columns. You can still use a validator on a text cell type https://jsfiddle.net/AMBudnik/ehqdub5j/
Alternatively, you can create a custom dropdown menu with custom options, but that requires more coding than using type: 'text' for all of the columns.