You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Handle Null or Not Present tags in xml file in BI Publisher?

edited Aug 13, 2021 9:32AM in Reporting and Analytics for ERP 4 comments

Content

Hi all,

I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be implemented in the RTF file.

SQL QUERY :

    CASE
        WHEN ACA.ATTRIBUTE1 IS NOT NULL THEN
            ACA.ATTRIBUTE1
        WHEN ACA.ATTRIBUTE1 IS NULL
             AND IPA.PAYEE_ALTERNATE_NAME IS NOT NULL THEN
            IPA.PAYEE_ALTERNATE_NAME
        ELSE
            IPA.PAYEE_NAME
    END                                       AS "PAYEE"

Can someone tell me how can I implement the same on the XML tag?

SrcDescriptiveFlexField/Attribute1   ;   SupplierorParty/AlternateName    ;    Payee/Name

The above-mentioned tags are the corresponding tags for the SQL I provided above.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!