Verify UL Value Query | Manitou Knowledge Base

Often, operations have different responses for accounts that are UL (or ULC) certified. This query determines the UL Value on the alarm customer's record.

The queries provided should be tested to ensure they meet the customer's specific needs. The company makes no guarantees regarding their accuracy or suitability.

SELECT ULGRADE= CASE
           WHEN ULGRADE IS NOT NULL THEN "ULGRADE"
           WHEN ULGRADE IS NULL THEN "NO_ULGRADE"
           ELSE "NO_ULGRADE" END
FROM MONITORING
WHERE SERIALNO={ME}

SELECT ULGRADE - Looks to find the UL Grade value found in the MONITORING table.
CASE - Starts the parameters to seek.
WHEN ULGRADE IS NOT NULL - looking for a non-null value in the ULGRADE column.
THEN "ULGRADE" - The returned value when the WHEN value is TRUE
WHEN ULGRADE IS NULL - looking for null value in the ULGRADE column.
THEN "NO_ULGRADE" - The returned value when the WHEN value is TRUE.
ELSE "NO_ULGRADE" - If neither CASE value is TRUE, or not found, the returned value.
END - Closes the CASE.
FROM MONITORING - Looks in this table for the ULGRADE value.
WHERE SERIALNO={ME} - Matches the alarm's customer serial number to the serial number in the Monitoring table.