1. XML tag value present in the XML data, and it has a value which is not NULL
for ex:
<PO_NUMBER>123</PO_NUMBER>
Suppose you want to give some condition to check not null similar to the one we give in PL/SQL as,
IF value IS NOT NULL THEN
---
---
END IF;
BI Publisher syntax for this is,
<?if:XML_TAG_NAME!=?>
--
--
<?end if?>
2. XML tag value present in the XML data, but it does not have a value which is NULL.
for ex:
<PO_NUMBER></PO_NUMBER>
(OR)
<PO_NUMBER/>
Now you want to give some condition to check null similar to the one we give in PL/SQL as,
IF value is NULL THEN
--
--
END IF;
BI Publisher syntax for this is,
<?if:XML_TAG_NAME and XML_TAG_NAME="?>
--
--
<?end if?>
3. XML tag is not present in the XML data, and therefore there is no value.
Now you want to give a condition to check the existence of the tag in the XML data. Here is the BI Publisher syntax for this,
<?if:not(XML_TAG_NAME)?>
--
--
<?end if?> - See more at: http://flexfields.blogspot.in/2011/04/bi-publisher-handling-null-xml-value.html#sthash.jzeSFQcJ.dpuf
and
<?if: count(ABC) !=''?>logic here<?end if?> OR <?if:ABC!=''?>Field<?end if?>
for ex:
<PO_NUMBER>123</PO_NUMBER>
Suppose you want to give some condition to check not null similar to the one we give in PL/SQL as,
IF value IS NOT NULL THEN
---
---
END IF;
BI Publisher syntax for this is,
<?if:XML_TAG_NAME!=?>
--
--
<?end if?>
2. XML tag value present in the XML data, but it does not have a value which is NULL.
for ex:
<PO_NUMBER></PO_NUMBER>
(OR)
<PO_NUMBER/>
Now you want to give some condition to check null similar to the one we give in PL/SQL as,
IF value is NULL THEN
--
--
END IF;
BI Publisher syntax for this is,
<?if:XML_TAG_NAME and XML_TAG_NAME="?>
--
--
<?end if?>
3. XML tag is not present in the XML data, and therefore there is no value.
Now you want to give a condition to check the existence of the tag in the XML data. Here is the BI Publisher syntax for this,
<?if:not(XML_TAG_NAME)?>
--
--
<?end if?> - See more at: http://flexfields.blogspot.in/2011/04/bi-publisher-handling-null-xml-value.html#sthash.jzeSFQcJ.dpuf
and
<?if: count(ABC) !=''?>logic here<?end if?> OR <?if:ABC!=''?>Field<?end if?>
No comments:
Post a Comment