nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

AND Not working inside if statement in BI Publisher template

Vinay Ramu

Summary

AND Not working inside if statement in BI Publisher template

Content

Hi Experts,

Below expression error out when sample xml was loaded into RTF template on word and trying to generate PDF. "BookingMRC" and "TotalMRC" and xml tag in the sample xml.

Not working:

<?if:BookingMRC != '' AND TotalMRC != '' AND TotalMRC > 0 AND BookingMRC < 0?>

Increase%: <?xdoxslt:round((((-BookingMRC) div TotalMRC)*100),2)?> %

<?end if?>

Working:

<?if:BookingMRC != ''?><?if:TotalMRC != ''?><?if:TotalMRC > 0?><?if: BookingMRC < 0?>

Increase%: <?xdoxslt:round((((-BookingMRC) div TotalMRC)*100),2)?> %

<?end if?><?end if?><?end if?><?end if?>

Why not working with first approach?

Thanks,

Vinay

Find more posts tagged with

Accepted answers

All comments

Vinay Ramu

Additional info on "Not working" scenario. The error happens when TotalMRC is Null in XML.

for e.g.,<TotalMRC/>

Thanks

Brajesh Shukla-95078

Nope...I put 'and' in small case....XML publisher will not accept upper case 'AND'.

Brajesh Shukla-95078

<?if:BookingMRC != '' and TotalMRC != '' and TotalMRC > 0 and BookingMRC < 0?>

Increase%: <?xdoxslt:round((((-BookingMRC) div TotalMRC)*100),2)?> %

<?end if?>

Can you try the above?

Jim Mcdonald

Are you using this to hide or display a field? If so, the <?choose"> statement works well for this and the <?when:?> can contain xdoxslt.

Sherry George

What is the error? this should work. If you can, please post a sample XML to test.

Pavan kumar.

Hi,

Because BI Publisher has extended set of SQL and XSL functions in RTF Templates.

Whereas we cannot not use mix them within one expression as suggested by the oracle team.

As you mentioned in the first expression with AND Operand is belongs to SQL and whereas you are using it in XSL expression.

It's one of the primary reason the expression is not working as expected

Regards

Pavan

Vinay Ramu

Hi Expert,

Thanks for your reply. I have marked case sensitive "and" as correct answer as that worked out for me.

-Vinay