I'm trying to set up a simple Rectangle which should change color from whatever, to red/orange, if an alarm is not assigned to anything (NULL) and is critical/major.
The query works fine when I test it, but the Rectangle never change color in live view?
This is my query:
SELECT assigned_to
from NAS_ALARMS
WHERE ASSIGNED_TO is NULL
AND (SEVERITY ='critical' OR SEVERITY ='major')
AND (USER_TAG2 ='mon2')