Oracle Analytics and AI

using 'call:' inside 'if' statement

Summary

using 'call:' inside 'if' statement

Content

I'm having some troubles with the syntax for the code below. The code is embedded in a field within a .rtf.

I have an alphanumeric that I am doing a 'to_number' in order to do a comparison. Everything works fine if I use text in the 'then' statement. The code breaks down when I try using <?call:jack?> rather than text.

Works:

<?xdofx:if to_number(TOTAL_AMOUNT) > 25000 then 'Higher' end if?>

Does not work:

<?xdofx:if to_number(TOTAL_AMOUNT) > 25000 then <?call:jack?> end if?>

Does anyone have any suggestions about what I am doing wrong? Any suggestions are appreciated.

Thanks.

Find more posts tagged with

Accepted answers

All comments

User910243567

Can you refer this

https://blogs.oracle.com/xmlpublisher/conditional-templates

Brajesh Shukla-95078

You cannot put nested <? ?> in XML tag.

The correct syntax is

<?if: to_number(TOTAL_AMOUNT) > 25000 ?>

<?call:jack?>

<?end if?>

Kwujcik

Brajesh,

Thank you for the suggestion. I think the to_number is causing the issue here as well. Without 'xdofx' the code throws an error. If I add 'xdofx' back in, it appears to ignore the condition and always prints the <?call:jack?> image.

Any thoughts?

Kwujcik

Thank you for your help. Unfortunately I am still getting an error. The modified code is below. Any thoughts? It feels like the 'xdofx' and to_number is what is tripping me up...

<?choose:?>

<?xdofx:when: to_number(TOTAL_AMOUNT) > 25000?>

<?call:jack?>

<?end when?>

<?end choose?>

Brajesh Shukla-95078

Hi ,

to_number is xdofx function, so its mandatory to use xdofx if we to_number. And also <?call:template?> inside if is not possible because of nested xml tags (<??>)

So Please use below xsl code to achieve your requirement.

1. Create one XML placeholder tag.

2. Put the below code in the tag

<xsl:if test="number(TOTAL_AMOUNT) > 25000"><xsl:call-template name="jack"> </xsl:call-template></xsl:if>