This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
ITSM In-App Reporting
Smart Reporting: 9.1.00 ARS: 9.1.00 ITSM: 9.1.00 Mid-Tier: 9.1.00
Enum values are not getting converted in smart reporting when using Case function
Eg. CASE WHEN Impact IS NULL THEN 'Testing' ELSE Impact END
Kindly go through the documentation which states that the "IS NULL" and "NOT NULL" options in CASE statements are introduced from Smart Reporting 9.1, however it will only work with text fields. DATE and ENUM fields are not supported.
Enhanced JDBC capabilities > Support for comparison between NULL and NOT NULL values in a CASE statement