Remedy Smart Reporting - Is it Possible to have Union and Append Sub-Query Added in a Single Report?

Version 1
    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:

    Smart Reporting Remedy


    APPLIES TO:

    Smart Reporting All Versions



    QUESTION:

    Is it Possible to have Union and Append Sub-Query Added in a Single Report in Smart Reporting?
    Adding Union and Append Sub-Query in a single report will result in the below error
    User-added image


    ANSWER:

    The AR JDBC Capabilities does not support Append & Union Sub-queries together. This is initially raised as a defect and later converted into enhancement.
    At this moment there isn't any official ETA; however, likely to be considered for upcoming releases.


     


    Article Number:

    000188743


    Article Type:

    FAQ/Procedural



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