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.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    ITSM In-App Reporting


    APPLIES TO:

    Smart Reporting: 9.1.00 ARS: 9.1.00 ITSM: 9.1.00 Mid-Tier: 9.1.00



    PROBLEM:

    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

     


    SOLUTION:

    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.

    https://docs.bmc.com/docs/display/public/itsm91/BMC+Remedy+Smart+Reporting+for+version+9.1.00+enhancements

    Enhanced JDBC capabilities > Support for comparison between NULL and NOT NULL values in a CASE statement


    Article Number:

    000128609


    Article Type:

    Solutions to a Product Problem



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