BI Publisher (MOSC)

MOSC Banner

BIP 11.1.1.7.0: Using instr to conditionally display a field in RTF template

edited Aug 22, 2013 6:02AM in BI Publisher (MOSC) 4 commentsAnswered
Hello,

The requirement is that if the field say CUSTOMER_CODE (in the data xml) has value 'ABCDEF001', I want to display another field SALES_VALUE only if the value of CUSTOMER_CODE contains a string 'ABCD'.

Here's how I am trying to do this:

<?if:instr(CUSTOMER_CODE,'ABCD')>'0'?> <?SALES_VALUE?> <?end if?>

This results in an error :

Caused by: oracle.xdo11g.xpath.XPathException: Parse Error in instr function.
 at oracle.xdo11g.xslt.XSLProcessor.reportException

Any pointers appreciated.

Thanks,

Manish

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