Multiple path filters on Alarm Table

Ignition
1

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

2

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.

3

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