# Perspective-alarm status table:How to filter by date and time

**URL:** <https://forum.inductiveautomation.com/t/perspective-alarm-status-table-how-to-filter-by-date-and-time/39619>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [October 13, 2020, 9:15am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-how-to-filter-by-date-and-time/39619 "2020-10-13T09:15:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![huangbin](https://avatars.discourse-cdn.com/v4/letter/h/e9a140/32.png) [@huangbin](https://forum.inductiveautomation.com/u/huangbin)\
**Post date:** [October 13, 2020, 9:15am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-how-to-filter-by-date-and-time/39619/1 "2020-10-13T09:15:16Z")

</div>

**perspective-Alarm status table** :  
Hi,I’m a newcomer using ignition.I want to filter the alarm record by date and time, but I can’t find the corresponding property Settings

---

<div class="post-metadata">

**Author:** ![jcoffman](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jcoffman/32/6429_2.png) [@jcoffman](https://forum.inductiveautomation.com/u/jcoffman)\
**Post date:** [October 13, 2020, 3:09pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-how-to-filter-by-date-and-time/39619/2 "2020-10-13T15:09:28Z")

</div>

In 8.1.0 a `filterAlarm` extension function was added to the Alarm Status Table which should help you do what you want using the Alarms [Associated Data](https://docs.inductiveautomation.com/display/DOC80/Alarm+Associated+Data)

---

<div class="post-metadata">

**Author:** ![rodrigo.almeida](https://avatars.discourse-cdn.com/v4/letter/r/c77e96/32.png) [@rodrigo.almeida](https://forum.inductiveautomation.com/u/rodrigo.almeida)\
**Post date:** [January 25, 2022, 9:44am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-how-to-filter-by-date-and-time/39619/3 "2022-01-25T09:44:04Z")

</div>

On Perspective AlarmStatusTable Property “PROPS-\>columns-\>active-\>activeTime-\>sort” you have the options descending, ascending and none.