Filter to trigger with excluding a zone fails to exclude
Posted: Sat Mar 16, 2024 3:32 am
I'm trying to create an action for a trigger of one alarm zone and not another alarm zone:
This is the debug:
It looks like it's not register the negation. I've also tried does not match or does not contain, and none seem to create the correct SQL.
Should this not be Score = 0 ?
Thank you, Chris
- zm-error-filter1.png (21.38 KiB) Viewed 296 times
Code: Select all
SQL SELECT E.,M.Name AS MonitorName,M.DefaultScale
FROM Monitors AS M INNER JOIN Events AS E ON (M.Id = E.MonitorId)
WHERE
E.TotScore > '30' and / AlarmedZoneId / EXISTS (SELECT * FROM Stats WHERE EventId=E.Id AND ZoneId=3 AND Score > 0)
and / AlarmedZoneId */ EXISTS (SELECT * FROM Stats WHERE EventId=E.Id AND ZoneId=2 AND Score > 0) ORDER BY StartDateTime ASC
Should this not be Score = 0 ?
Thank you, Chris