# How to filter table by values in hidden column **URL:** \ **Category:** Ignition\ **Tags:** ignition81, perspective\ **Created:** [December 6, 2021, 6:05pm UTC](https://forum.inductiveautomation.com/t/how-to-filter-table-by-values-in-hidden-column/53802 "2021-12-06T18:05:37Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![YF129701](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/yf129701/32/60498_2.png) [@YF129701](https://forum.inductiveautomation.com/u/YF129701)\ **Post date:** [December 6, 2021, 6:05pm UTC](https://forum.inductiveautomation.com/t/how-to-filter-table-by-values-in-hidden-column/53802/1 "2021-12-06T18:05:37Z")
As the title states, I want to filter a table by a column that has `visible` set to `False`. Currently, this doesn’t work like it should. If the column is set to `visible`, then the table is filtered by the value in `filter.text`. This would be great to cut down on repetitive fields. I have a column that holds tag values (description tags, not PLC tags) that are almost always one of two values currently and I don’t want to display them. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [December 6, 2021, 8:26pm UTC](https://forum.inductiveautomation.com/t/how-to-filter-table-by-values-in-hidden-column/53802/2 "2021-12-06T20:26:36Z")
Have you assigned each table column to a database column? e.g. `PROPS.columns.0.field`. If you’re just letting them find their own order it won’t work. I did this successfully with a table of IP addresses. I retrieved them in format 010.003.012.009 and in format 10.3.12.9, hid the first and displayed the second and they sort in order. Clicking on the column header switches between - 1, 2, 3 - 1, 10, 11, 2, 20, 21 - 99, 98, … ---
**Author:** ![YF129701](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/yf129701/32/60498_2.png) [@YF129701](https://forum.inductiveautomation.com/u/YF129701)\ **Post date:** [December 6, 2021, 8:31pm UTC](https://forum.inductiveautomation.com/t/how-to-filter-table-by-values-in-hidden-column/53802/3 "2021-12-06T20:31:21Z")
Yes, each column is associated with a database column. Also I should have been more clear that I’m using the built-in filter feature, not filtering through the query (although I probably will end up doing this because the filter searches for everything in the filter text field (AND) instead of searching for each word separately (OR)). Sigh… ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [December 6, 2021, 8:48pm UTC](https://forum.inductiveautomation.com/t/how-to-filter-table-by-values-in-hidden-column/53802/4 "2021-12-06T20:48:02Z")
Yes, I filtered through a named query. We’re still waiting for the _Table_ component to get Excel-like column filters.