# Filter multiple columns in a table in perspective

**URL:** <https://forum.inductiveautomation.com/t/filter-multiple-columns-in-a-table-in-perspective/79547>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [September 23, 2023, 10:40am UTC](https://forum.inductiveautomation.com/t/filter-multiple-columns-in-a-table-in-perspective/79547 "2023-09-23T10:40:03Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [September 23, 2023, 10:40am UTC](https://forum.inductiveautomation.com/t/filter-multiple-columns-in-a-table-in-perspective/79547/1 "2023-09-23T10:40:03Z")

</div>

Dears,  
I want to filter multiple columns in my table using the built-in filter textbox.Now I just can filter in a one column only .  
Any suggestions ?

Regards,

---

<div class="post-metadata">

**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:** [September 23, 2023, 10:47am UTC](https://forum.inductiveautomation.com/t/filter-multiple-columns-in-a-table-in-perspective/79547/2 "2023-09-23T10:47:56Z")

</div>

From 8.1.22 the Perspective Table component features individual column filters.

- Make sure that `columns.x.field` (where 'x' is the column number) is filled in.
- `columns.x.filter.enabled : true`
- `columns.x.filter.visible : always | on-hover | never`

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [September 23, 2023, 10:53am UTC](https://forum.inductiveautomation.com/t/filter-multiple-columns-in-a-table-in-perspective/79547/3 "2023-09-23T10:53:56Z")

</div>

So It is not available to make multiple filters on different columns on the same time !!

---

<div class="post-metadata">

**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:** [September 23, 2023, 10:58am UTC](https://forum.inductiveautomation.com/t/filter-multiple-columns-in-a-table-in-perspective/79547/4 "2023-09-23T10:58:49Z")

</div>

You can run one filter on each column simultaneously.

For example, with the default Perspective Table you can filter on both "city contains 'San'" and "country contains 'United'".

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [September 23, 2023, 1:35pm UTC](https://forum.inductiveautomation.com/t/filter-multiple-columns-in-a-table-in-perspective/79547/5 "2023-09-23T13:35:28Z")

</div>

I’m not sure what exactly is your use case, but you should be able to apply filters on multiple columns.  
If you can’t find a built in way to do what you want:  
Bind the data to a custom prop instead.  
Then bind data to that custom prop.  
Add a transform and apply whatever custom filter you want.

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [September 24, 2023, 3:42pm UTC](https://forum.inductiveautomation.com/t/filter-multiple-columns-in-a-table-in-perspective/79547/6 "2023-09-24T15:42:25Z")

</div>

My ignition is 8.1.13 ,so filter could be done on only one column in my case? .  
I face challenges to update to latest ignition version now.

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [September 24, 2023, 3:43pm UTC](https://forum.inductiveautomation.com/t/filter-multiple-columns-in-a-table-in-perspective/79547/7 "2023-09-24T15:43:12Z")

</div>

thanks for your feedback but I am asking about the built in function in table component

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [September 24, 2023, 4:11pm UTC](https://forum.inductiveautomation.com/t/filter-multiple-columns-in-a-table-in-perspective/79547/8 "2023-09-24T16:11:47Z")

</div>

Yes, but if you can't find a way to make them work the way you want, there's the solution of custom filters.

Edit: Especially in 8.1.13, where there's no column-specific filters.  
I'm working mostly in 8.1.17 lately, and I had to make my own filters because the built-in one didn't fit my needs.