# Alarm Status Table - Event value sorting

**URL:** <https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 11, 2024, 8:19am UTC](https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673 "2024-06-11T08:19:23Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![THauptman](https://avatars.discourse-cdn.com/v4/letter/t/a88e57/32.png) [@THauptman](https://forum.inductiveautomation.com/u/THauptman)\
**Post date:** [June 11, 2024, 8:19am UTC](https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673/1 "2024-06-11T08:19:23Z")

</div>

Hello everyone,

While using alarm status table using perspective, the event value sorting is not working as it should. It seems that it is sorting values as string not as float or integer. Is this a bug or am I missing something?  
Thank you.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/3/43fbf998e0bf1c1950fafeb3508885ad7832f0b7.png)

---

<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 11, 2024, 3:03pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673/2 "2024-06-11T15:03:46Z")

</div>

What is the `render` mode for the column in question? (`Table.props.columns[x].render`) Make sure the `render` value is set to "number".

---

<div class="post-metadata">

**Author:** ![THauptman](https://avatars.discourse-cdn.com/v4/letter/t/a88e57/32.png) [@THauptman](https://forum.inductiveautomation.com/u/THauptman)\
**Post date:** [June 11, 2024, 3:29pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673/3 "2024-06-11T15:29:12Z")

</div>

It looks that by default columns don't have this property. If I put manually render mode it doesn't have any effect.

By default, columns look like this  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/0/80079dd90c8eb1b4b44f4f189327d662824ccd22.png)

---

<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 11, 2024, 4:09pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673/4 "2024-06-11T16:09:49Z")

</div>

[Yes they do](https://www.docs.inductiveautomation.com/docs/8.1/appendix/components/perspective-components/perspective-display-palette/perspective-table#:~:text=Value%20is%20boolean.-,render,-%3A%20The%20default%20render) - you must be looking elsewhere. I suspect you're looking at your data; you need to look at the exact property path I supplied.

 ![Screenshot 2024-06-11 at 9.09.40 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/9/1943c8d0a20ee81fdc6aff1630d6806ef60319bd.png)

---

<div class="post-metadata">

**Author:** ![THauptman](https://avatars.discourse-cdn.com/v4/letter/t/a88e57/32.png) [@THauptman](https://forum.inductiveautomation.com/u/THauptman)\
**Post date:** [June 11, 2024, 4:33pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673/5 "2024-06-11T16:33:33Z")

</div>

No, I have an [alarm status table](https://www.docs.inductiveautomation.com/docs/8.1/appendix/components/perspective-components/perspective-display-palette/perspective-alarm-status-table), not regular table

---

<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 11, 2024, 4:45pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673/6 "2024-06-11T16:45:39Z")

</div>

Silly me... I will live forever with this shame.

The Event Value column is not intelligent enough to make any sort of inference regarding its type because different alarms could have different types, and so it will always sort that column as a string.  
 ![Screenshot 2024-06-11 at 9.47.00 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/f/bf2551c0144f1cadff3b3f6efa56fc970bc8f471.png)

---

<div class="post-metadata">

**Author:** ![THauptman](https://avatars.discourse-cdn.com/v4/letter/t/a88e57/32.png) [@THauptman](https://forum.inductiveautomation.com/u/THauptman)\
**Post date:** [June 11, 2024, 4:47pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673/7 "2024-06-11T16:47:01Z")

</div>

No worries 🙂

Is there any workaround to this? Customer would really like to sort alarms by eventValues

---

<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 11, 2024, 4:50pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673/8 "2024-06-11T16:50:31Z")

</div>

You would need to use a regular Table, populated with alarm information, and where you use the aforementioned `render` property to force the numeric render type. Be warned that mixing value types while forcing a "number" rendering approach will result in weird display scenarios.  
 ![Screenshot 2024-06-11 at 9.50.24 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/d/0db2254baf77a0182c9fbf9804ff2657691208d6.png)

---

<div class="post-metadata">

**Author:** ![THauptman](https://avatars.discourse-cdn.com/v4/letter/t/a88e57/32.png) [@THauptman](https://forum.inductiveautomation.com/u/THauptman)\
**Post date:** [June 11, 2024, 5:32pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-event-value-sorting/91673/9 "2024-06-11T17:32:34Z")

</div>

Ok I see, thank you 🙂
