# \[Feature-13927\] Perspective - Table filter by column **URL:** \ **Category:** Ignition Early Access\ **Created:** [May 7, 2019, 4:02pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753 "2019-05-07T16:02:24Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![alan\_pereira](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alan_pereira/32/79668_2.png) [@alan\_pereira](https://forum.inductiveautomation.com/u/alan_pereira)\ **Post date:** [May 7, 2019, 4:02pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/1 "2019-05-07T16:02:24Z")
Our customer asked if we could filter a table by each column since we were able to do that previously in Ignition with power tables. Currently I believe it's only possible to filter over all of the data, right? Is there any way to do it individually? If so, please let me know. If not, I'd like to leave this as a feature suggestion. ---
**Author:** ![ynejati](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ynejati/32/6093_2.png) [@ynejati](https://forum.inductiveautomation.com/u/ynejati)\ **Post date:** [May 16, 2019, 7:17pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/2 "2019-05-16T19:17:19Z")
Hi, Correct, currently the table filter will filter all of the table data. We have had plans to add filtering for individual columns since day one, but haven’t got around to implementing it yet. Thanks for the reminder. -Yousuf ---
**Author:** ![steven.white](https://avatars.discourse-cdn.com/v4/letter/s/cab0a1/32.png) [@steven.white](https://forum.inductiveautomation.com/u/steven.white)\ **Post date:** [February 17, 2020, 3:35pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/3 "2020-02-17T15:35:01Z")
Has there been any update on filtering by column data yet? ---
**Author:** ![guganathan.r](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@guganathan.r](https://forum.inductiveautomation.com/u/guganathan.r)\ **Post date:** [May 30, 2020, 3:39am UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/4 "2020-05-30T03:39:56Z")
Hi, any updates on multiple filter option? ---
**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Post date:** [July 3, 2020, 2:23pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/5 "2020-07-03T14:23:42Z")
Hi, any update? ---
**Author:** ![bryanboudreau](https://avatars.discourse-cdn.com/v4/letter/b/aeb1de/32.png) [@bryanboudreau](https://forum.inductiveautomation.com/u/bryanboudreau)\ **Post date:** [December 22, 2020, 3:36am UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/6 "2020-12-22T03:36:43Z")
This has been a huge gap in perspective. Having to build a ton of custom filters that were built in before. ---
**Author:** ![johannes.B](https://avatars.discourse-cdn.com/v4/letter/j/94ad74/32.png) [@johannes.B](https://forum.inductiveautomation.com/u/johannes.B)\ **Post date:** [August 16, 2021, 11:37am UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/8 "2021-08-16T11:37:06Z")
is this implemented now? ---
**Author:** ![mike4](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@mike4](https://forum.inductiveautomation.com/u/mike4)\ **Post date:** [October 13, 2021, 4:52pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/9 "2021-10-13T16:52:55Z")
Has individual column filtering been implemented in Perspective yet?? ---
**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:01pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/10 "2021-12-06T20:01:06Z")
Is there any word on when we can expect this to be implemented? Its something I would use in every view of every project I’ve worked on in Perspective. Where I work, we have been asking for this feature for 2 years and so far haven’t heard back from anyone on an approximate timeline. Is it technically difficult to achieve? A hotfix would be to allow multiple values in the filter textbox and search the dataset `OR` wise ie any row containing any of the strings listed in the text field. Its pretty disappointing to see IA not addressing this very, very common issue developers have… Oh well. ---
**Author:** ![BluegelMarius](https://avatars.discourse-cdn.com/v4/letter/b/e9c0ed/32.png) [@BluegelMarius](https://forum.inductiveautomation.com/u/BluegelMarius)\ **Post date:** [February 23, 2022, 11:59am UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/11 "2022-02-23T11:59:25Z")
Is there any update on that feature request? ---
**Author:** ![David.Bell](https://avatars.discourse-cdn.com/v4/letter/d/34f0e0/32.png) [@David.Bell](https://forum.inductiveautomation.com/u/David.Bell)\ **Post date:** [May 27, 2022, 4:40am UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/12 "2022-05-27T04:40:44Z")
Hello, has there been any update on this? A lot of users request this functionality. Thanks! ---
**Author:** ![kgamble](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kgamble/32/8019_2.png) [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Post date:** [May 27, 2022, 1:41pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/13 "2022-05-27T13:41:51Z")
This would definitely be a huge step forward for data heavy reporting applications. I currently have a painfully custom abstract table that allows the users to customize column visibility, filtering, etc. but the way the filtering works is not scalable, and something like this would make it significantly cleaner. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [May 27, 2022, 3:12pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/14 "2022-05-27T15:12:34Z")
I kicked our internal ticket requesting an update in the prioritization of this, based on the persistent demand in this thread. ---
**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\ **Post date:** [May 31, 2022, 3:19pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/15 "2022-05-31T15:19:28Z")
Thanks @paul-griffith. ---
**Author:** ![amy.sudibyo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amy.sudibyo/32/38659_2.png) [@amy.sudibyo](https://forum.inductiveautomation.com/u/amy.sudibyo)\ **Post date:** [July 7, 2022, 4:44am UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/16 "2022-07-07T04:44:34Z")
Hi, just adding another vote for this request. Any indication of potential release date? ---
**Author:** ![ynejati](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ynejati/32/6093_2.png) [@ynejati](https://forum.inductiveautomation.com/u/ynejati)\ **Post date:** [July 29, 2022, 12:12am UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/17 "2022-07-29T00:12:23Z")
Hi all, Thank you for your patience. You will be happy to hear that this has been implemented and is currently undergoing QA. You will soon have the ability to filter individual columns either through component properties or as an end user via the Table component’s UI. The type of filters that are available are dependent on the determined data type of the column. I will provide more details once the feature has successfully made it into the product. Thanks again. ---
**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Post date:** [July 29, 2022, 11:39pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/18 "2022-07-29T23:39:32Z")
Hi Yusef What about column reordering? ---
**Author:** ![ynejati](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ynejati/32/6093_2.png) [@ynejati](https://forum.inductiveautomation.com/u/ynejati)\ **Post date:** [July 30, 2022, 1:44am UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/19 "2022-07-30T01:44:48Z")
Hey, Nader. That’s been available, on all tables, since about December 2021. Try dragging a column header and see what happens. ---
**Author:** ![ynejati](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ynejati/32/6093_2.png) [@ynejati](https://forum.inductiveautomation.com/u/ynejati)\ **Post date:** [October 12, 2022, 11:49pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/20 "2022-10-12T23:49:21Z")
Wow, turns out getting the date filtering portion to handle a wide range of conditions with and without timezones was very tricky. Thanks for your patience. This feature should be available in the next nightly build, and eventually in the 8.1.23 release. Some things worth mentioning. We do our best to determine the filter type of the column when the render mode is set to "auto". This is easy to do when the data is a dataset type, but a little trickier when it is an array of JSON objects. In this case, you may want to specify the render mode. If render mode is set to "view", we use the same method to detect the filter type, as if it were "auto" . We've included four filter types, number, date, boolean, and string. Each filter type has a condition and, all but the boolean type, a value. For the date and number column filter types, that value can either be a single date or number, or an object representing a range (min and max). Just something to keep in mind when binding to the value of these column filter types. Individual column filters are applied after the main text filter, if it happens to be configured and not empty. Individual column filters can be hidden from the end user, so that you can just run them behind the scenes. I think that's the bulk of what you need to know. We do have plans to add more conditions and filter types. If you have something in mind, feel free to let us know and we'll see if we can add it to the list. I'll leave you all with a few screenshots of the UI and some of the property structure. Not all of it though, wouldn't want to spoil it. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/e/deb611909ba5acfbb7e8efd889243640d22a31d2.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/9/3904234140ee8ab4c56544cc60254d1322c69452.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/0/707fc85043ec68a929bab0d47689062863f16f95.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/6/064352e39341470afe231b76c05c820f4c7e6033.png) ---
**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:** [October 13, 2022, 2:47pm UTC](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753/21 "2022-10-13T14:47:51Z")
This is amazing!!! Literally a feature I've been wanting since 8.0! Thank you to the IA team [Next page](https://forum.inductiveautomation.com/t/feature-13927-perspective-table-filter-by-column/24753.md?page=2)