BI Publisher (MOSC)

MOSC Banner

conditional sub string with in IF condition returning both values in BI Publishe

edited Dec 9, 2016 4:00AM in BI Publisher (MOSC) 3 commentsAnswered

Hi All

I am using below conditional sub string with in IF condition.

<?template:ADDR?>

<?xdofx:if (substr(ORDER_TYPE,1,3)!='FPD')then

Sample Data

Australia

12345

end if?>

<?xdofx:if (substr(ORDER_TYPE,1,3)='FPD')then

Sample Data

Australia

12345

EMI 123545

ABCD 

end if?>

<?end template?>

But it is printing both the values.

Can u please help me ?

Thank You

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