# \[FEATURE-13927\] Filter by multiple columns on a Perspective Table?

**URL:** <https://forum.inductiveautomation.com/t/feature-13927-filter-by-multiple-columns-on-a-perspective-table/28040>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [September 5, 2019, 2:30pm UTC](https://forum.inductiveautomation.com/t/feature-13927-filter-by-multiple-columns-on-a-perspective-table/28040 "2019-09-05T14:30:07Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![azoraian](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@azoraian](https://forum.inductiveautomation.com/u/azoraian)\
**Post date:** [September 5, 2019, 2:30pm UTC](https://forum.inductiveautomation.com/t/feature-13927-filter-by-multiple-columns-on-a-perspective-table/28040/1 "2019-09-05T14:30:07Z")

</div>

Hi,

I have recently been exploring Perspective Tables, and was wondering if it was possible to filter by multiple column fields using the built in filter (i.e. filtering by item number, AND created date, etc.). Saw some posts more closely related to Alarm Tables, not sure if the same methodology applies. Thanks in advance!

---

<div class="post-metadata">

**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:** [September 5, 2019, 3:49pm UTC](https://forum.inductiveautomation.com/t/feature-13927-filter-by-multiple-columns-on-a-perspective-table/28040/2 "2019-09-05T15:49:01Z")

</div>

I agree, something like in the image below, where you can specify your column name in quotes, and string them together would be very useful.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/78749f40328dc1c34ca2c8e4e5bae54e20547700.png)

---

<div class="post-metadata">

**Author:** ![awalker](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/awalker/32/6874_2.png) [@awalker](https://forum.inductiveautomation.com/u/awalker)\
**Post date:** [September 11, 2019, 10:54pm UTC](https://forum.inductiveautomation.com/t/feature-13927-filter-by-multiple-columns-on-a-perspective-table/28040/3 "2019-09-11T22:54:08Z")

</div>

We have a ticket to add this functionality. I’ll link it above and let you know when its been implemented.

---

<div class="post-metadata">

**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:** [June 10, 2020, 5:06pm UTC](https://forum.inductiveautomation.com/t/feature-13927-filter-by-multiple-columns-on-a-perspective-table/28040/4 "2020-06-10T17:06:18Z")

</div>

Hi any update on this feature? Any timeline?

---

<div class="post-metadata">

**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:** [September 7, 2021, 11:21am UTC](https://forum.inductiveautomation.com/t/feature-13927-filter-by-multiple-columns-on-a-perspective-table/28040/5 "2021-09-07T11:21:09Z")

</div>

This function would also be very useful for us… any updates here?

---

<div class="post-metadata">

**Author:** ![Steve\_Laubach](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/steve_laubach/32/60900_2.png) [@Steve\_Laubach](https://forum.inductiveautomation.com/u/Steve_Laubach)\
**Post date:** [September 9, 2021, 2:19pm UTC](https://forum.inductiveautomation.com/t/feature-13927-filter-by-multiple-columns-on-a-perspective-table/28040/6 "2021-09-09T14:19:28Z")

</div>

You could probably build this functionality by populating your table using an Expression Structure binding and binding the inputs for the expression structure to whatever you want to filter by. One downside is that your filters have to be static.

You have to return your data using a script transform and use the parameters in the expression structure to filter that.

I’m finding this hard to explain. An expression structure binding works a lot like a subroutine call so you’re basically basically making a parameterized script that returns a dataset.

---

<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:** [July 20, 2023, 9:01am UTC](https://forum.inductiveautomation.com/t/feature-13927-filter-by-multiple-columns-on-a-perspective-table/28040/7 "2023-07-20T09:01:10Z")

</div>

Hi,Any update on this function ?