# Multiple path filters on Alarm Table

**URL:** <https://forum.inductiveautomation.com/t/multiple-path-filters-on-alarm-table/3958>\
**Category:** Ignition\
**Created:** [February 6, 2012, 12:34pm UTC](https://forum.inductiveautomation.com/t/multiple-path-filters-on-alarm-table/3958 "2012-02-06T12:34:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vahterto](https://avatars.discourse-cdn.com/v4/letter/v/e68b1a/32.png) [@vahterto](https://forum.inductiveautomation.com/u/vahterto)\
**Post date:** [February 6, 2012, 12:34pm UTC](https://forum.inductiveautomation.com/t/multiple-path-filters-on-alarm-table/3958/1 "2012-02-06T12:34:58Z")

</div>

Hi

Is it possible to use multiple path or itempath filters on Alarm Table?  
If not should I use “normal” table component and make SQL query to get this done?

Br  
Tommi

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [February 8, 2012, 5:09pm UTC](https://forum.inductiveautomation.com/t/multiple-path-filters-on-alarm-table/3958/2 "2012-02-08T17:09:50Z")

</div>

No, you cannot have multiple search patterns in the Item Path Filter. You enter strings like “folderabc\*” to indicate that you want everything in folderabc.

---

<div class="post-metadata">

**Author:** ![jay](https://avatars.discourse-cdn.com/v4/letter/j/ed8c4c/32.png) [@jay](https://forum.inductiveautomation.com/u/jay)\
**Post date:** [February 9, 2012, 7:44am UTC](https://forum.inductiveautomation.com/t/multiple-path-filters-on-alarm-table/3958/3 "2012-02-09T07:44:38Z")

</div>

The Ignition alarm schema is simple now (and so am I!). There is nothing stopping you from treating the ALERT\_LOG table as a generic table that you can manipulate as you please and display in the generic ‘Table’ component. Here’s a very simple SQL example of parsing the alarm table’s path column where the first folder-token in the path is extracted and renamed as “Site”. MySQL syntax. The derived “Flags” column, at the end, is used to color-code the alarms as active-unak’d, active ak’d, and inactive-ack’d. Again, I am not using the ‘Alarm Summary Table’ component to display this.

SELECT  
LEFT(PATH,LOCATE("/",PATH)-1) AS “Site”,  
DISPLAYPATH AS “Description”,  
ACTIVE\_TIMESTAMP AS “Active Time”,  
CLEARED\_TIMESTAMP AS “Cleared Time”,  
ACK\_TIMESTAMP AS “Ack Time”,  
ACK\_USER AS “Ack User”,  
PATH AS “Path”,  
SYSTEM AS “System”,  
STATE\_NAME AS “State”,  
STATE\_SEVERITY AS “Severity”,  
ISNULL(CLEARED\_TIMESTAMP) + 2\*ISNULL(ACK\_TIMESTAMP) AS “Flags”  
FROM ALERT\_LOG  
WHERE ACTIVE\_TIMESTAMP \>= ‘{Root Container.Date Range.startDate}’ AND  
ACTIVE\_TIMESTAMP \<= ‘{Root Container.Date Range.endDate}’  
ORDER BY ACTIVE\_TIMESTAMP DESC