Enum values are not getting converted in smart reports when using Case function

Version 2
    Share This:

    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

      when we use Case Function as give below then it returns enum values instead of alias 
      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

    Article Number:


    Article Type:

    Solutions to a Product Problem

      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles