I want 1 column hidden and not manually searchable but programmatically searchable

mdrob

I have 6 columns. The first 3 are text and i want to search. the last one is a data value and i want to hide it. However, there are filters i've implemented via checkboxes that should be able to find based on the 6th column.
Let's say it looks like this:
john | doe | 33 | 123 main st | 1 | 2 | isValid
jane | doe | 23 | 223 main st | 1 | 2 | isNotValid

and so forth - i want to hide the valid/invalid column from view and i dont want users to be able to search on it via text box but i still want to be able to hit a checkbox that lets me view all valid and all invalid users.

how can i do this?

mdrob

sorry, didnt format the data:

john | doe | 33 | 123 main st | 1 | 2 | isValid

jane | doe | 23 | 223 main st | 1 | 2 | isNotValid

allan

Generally you can use columns.searchable to toggle the searchable option. However, that will toggle the searchable option for both individual columns and the global search.

If you want to remove it from the global search but be able to filter on it programmatically, set that option to false, and use a custom filter to perform the filter. That currently is the only way.

Allan