BI Publisher (MOSC)

MOSC Banner

If Statement not working in XLS template

edited Oct 12, 2020 6:19AM in BI Publisher (MOSC) 3 commentsAnswered ✓

Hi,

If Statement in XLS template is not working for me. what am i doing wrong?

(XML Structure below) I need each node corresponding BOI_ID to show the value of BALANCE.

For example: when BOI_ID=1 then show the value of BALANCE in the node (1000)

In XDO_METADATA i tried :

<xsl:if test="/DATA_DS/G_1/BOI_ID=1"> <xsl:value-of select="/DATA_DS/G_1/G_2/BALANCE"/></xsl:if>

<xsl:if test=".//BOI_ID=1"> <xsl:value-of select="BALANCE"/></xsl:if>

<xsl:value-of select="//BALANCE[//@BOI_ID=1]"/>

<xsl:if test=".//BOI_ID=1">.//BALANCE</xsl:if>


NOTHING WORKS. even a simple fake IF gives null pointer exception like <?if:1=1?>1<?end if?>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center