Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

BI Publisher - Like Condition in If statement

anasaziiNov 5 2019

Hi - I apologize in advance if this is not the proper community, I was having a hard time finding one specifically for BI Publisher.

I have an RTF template for BI Publisher, to use in Oracle Applications.

I want to have conditional formatting around a field using an if statement.  I want the if statement to be based on if one of my fields is like a specific format. 

If I were writing SQL I would do this as  - where my_field like 'FB%' - I can't seem to find what the syntax for this would need to be in BI so that I can write this in my if statement...is it possible?


Thanks!

Janel

Oracle R12.1.3

Comments

SiatGesi Feb 14 2025

THE FIRST problem howto wrap I have resolved…

SiatGesi Feb 14 2025

now I'm trying to move the unzipped files (pictures) from db to AS… my real problem… best regards

1 - 2