How to Handle Null or Not Present tags in xml file in BI Publisher?
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 :
WHEN ACA.ATTRIBUTE1 IS NOT NULL THEN
WHEN ACA.ATTRIBUTE1 IS NULL
AND IPA.PAYEE_ALTERNATE_NAME IS NOT NULL THEN
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.