# Perspective Alarm Status Table - Dataset Filter

**URL:** <https://forum.inductiveautomation.com/t/perspective-alarm-status-table-dataset-filter/79812>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [September 28, 2023, 10:34pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-dataset-filter/79812 "2023-09-28T22:34:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jykl5](https://avatars.discourse-cdn.com/v4/letter/j/9de053/32.png) [@jykl5](https://forum.inductiveautomation.com/u/jykl5)\
**Post date:** [September 28, 2023, 10:34pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-dataset-filter/79812/1 "2023-09-28T22:34:57Z")

</div>

My scenario is I have 1000 tags that have alarms, and I want to filter out the alarm status table to show only a subset.

By user they are interested in a subset of those tags (like 200 out of the 1000). There's no naming convention to the tags that I can use as a wild card. But using a database query I can create a dataset of the respective subset.

Is there a way to filter the Alarm Status Table using a dataset?

---

<div class="post-metadata">

**Author:** ![Hayden\_Watson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/hayden_watson/32/48792_2.png) [@Hayden\_Watson](https://forum.inductiveautomation.com/u/Hayden_Watson)\
**Post date:** [September 29, 2023, 7:16am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-dataset-filter/79812/2 "2023-09-29T07:16:34Z")

</div>

You could use the `filterAlarm` extension function on the alarm status table scripts.

Each alarm will run that script, if you're using a dataset, you could loop through that dataset. If the tags is found in the dataset return `True` or if not `False`.

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [September 29, 2023, 11:20am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-dataset-filter/79812/3 "2023-09-29T11:20:01Z")

</div>

This information could be useful:

> [@Perspective alarm filtering - how to prefilter on display path and multiple conditions](https://forum.inductiveautomation.com/t/perspective-alarm-filtering-how-to-prefilter-on-display-path-and-multiple-conditions/74010):
>
> Hi I need to filter alarms on 2 conditions: 1 - first condition is "AlarmName" which is at the end part of the display path string eg. "TagFolder/TagName/AlarmName" - would using filterAlarm extension function be the right way? i was struggling with the syntax to get it right even in the simplest form. def filterAlarm(self, alarmEvent): AlarmDisplayPath = str(alarmEvent.get('displayPath')) return "TagFolder/TagName/AlarmName" == AlarmDisplayPath what about adding wildcards - is it allowe…

---

<div class="post-metadata">

**Author:** ![jykl5](https://avatars.discourse-cdn.com/v4/letter/j/9de053/32.png) [@jykl5](https://forum.inductiveautomation.com/u/jykl5)\
**Post date:** [September 29, 2023, 3:47pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-dataset-filter/79812/4 "2023-09-29T15:47:38Z")

</div>

I was able to figure it out using the filter / condition property. It takes comma separated values.

I had worried a long string would have performance issues, but no issues filtering out a subset of a few hundred.

Thanks for the inputs.
