# \[IGN-2758\] Perspective Alarm Status Table activeSortOrder - What is this for?

**URL:** <https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 9, 2021, 3:42am UTC](https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588 "2021-06-09T03:42:45Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [June 9, 2021, 3:42am UTC](https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588/1 "2021-06-09T03:42:45Z")

</div>

The user manual description doesn't make sense in describing what exactly this does and how to use it:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/4/340796fa87ca684cf3333336ce1cbf413eb15a1f.png)

I want to sort alarms by state (ActiveUnack, ActiveAcked, ClearUnacked, ClearAcked), time (latest to oldest), then by priority (highest to lowest) in this order.

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [June 9, 2021, 4:53am UTC](https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588/2 "2021-06-09T04:53:51Z")

</div>

`activeSortOrder` is a user-defined list of Alarm Status Table column names, where the lowest index within the list will be driving value to sort on, and then equal values will be sorted by the next index.

So for your use-case of sorting by state, time, and then priority, you should have something like this:

![Screen Shot 2021-06-08 at 9.51.29 PM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6bf05fd901c5c30c7c7cace2d523db0e30d4df07.png)

and you should make sure that the `sort` property for each of these columns is “descending”.

![Screen Shot 2021-06-08 at 9.52.57 PM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/6/a616ca8f57a78ab03cff801981933771e661139f.png)

---

<div class="post-metadata">

**Author:** ![Aiasa21](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Post date:** [April 5, 2024, 1:55pm UTC](https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588/3 "2024-04-05T13:55:27Z")

</div>

Hi @nminchin, I wonder if you are able to order the columns state as you wish (ActiveUnack, ActiveAcked, ClearUnacked, ClearAcked).

I would like to make the same but I'm struggling with it.

Thank you

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [April 5, 2024, 4:04pm UTC](https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588/4 "2024-04-05T16:04:16Z")

</div>

Unfortunately, the sorting of the state column is purely alphabetical instead of by relative importance. We have an open feature ticket to bring this sorting behavior in-line with the behavior experienced in Vision. No ETA on when that feature might begin development.

---

<div class="post-metadata">

**Author:** ![Aiasa21](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Post date:** [April 5, 2024, 7:12pm UTC](https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588/5 "2024-04-05T19:12:40Z")

</div>

Dear @cmallonee thanks for your answer, I'm sorry to read this.

We're using Vision and we would like to show the same exactly alarm status table (as order of alarms) in perspective.  
There's no other ways at all to fix this? Script or something else.

Thank you

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [April 5, 2024, 7:19pm UTC](https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588/6 "2024-04-05T19:19:21Z")

</div>

No, there is no custom scripting avenue for directly manipulating the displayed sort order of alarm entries.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 5, 2024, 7:41pm UTC](https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588/7 "2024-04-05T19:41:30Z")

</div>

One possible work-around would be to script retrieval of alarm status using [system.alarm.queryStatus()](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-alarm/system-alarm-queryStatus) and sorting the result yourself, then supplying the sorted result to a regular Perspective Table.

---

<div class="post-metadata">

**Author:** ![Aiasa21](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Post date:** [April 8, 2024, 2:12pm UTC](https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588/8 "2024-04-08T14:12:43Z")

</div>

Thank you all for the help, I'll figure out how to move on.

---

<div class="post-metadata">

**Author:** ![angus123](https://avatars.discourse-cdn.com/v4/letter/a/a88e4f/32.png) [@angus123](https://forum.inductiveautomation.com/u/angus123)\
**Post date:** [February 27, 2026, 9:22pm UTC](https://forum.inductiveautomation.com/t/ign-2758-perspective-alarm-status-table-activesortorder-what-is-this-for/47588/9 "2026-02-27T21:22:21Z")

</div>

Noting that a workaround solution for changing the sort order of the State column is provided in this post: [Sort Order for State in Alarm Status Table](https://forum.inductiveautomation.com/t/sort-order-for-state-in-alarm-status-table/106596)

The solution is to enable the isAcked and isActive columns, set their width to zero, and set the sort order of isAcked to ascending. Then set the activeSortOrder to 0:isActive, 1:isAcked, … etc. example 2: priority, 3: activeTime and so on.
