Summary NVL In RTF Template Content Hi Team, How to use NVL In rtf templete If is null the it should write Thanks AT

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 AI and Analytics

Child Item

NVL In RTF Template

Thilib Arivu

Summary

NVL In RTF Template

Content

Hi Team,

How to use NVL In rtf templete

<ABC> is null the it should write <DEF>

Thanks

Find more posts tagged with

Accepted answers

All comments

Thilib Arivu

Can we use like this ?

<?xdofx: if ABC !='' then 'ABC' else 'DEF'?> <?end if?>

Thanks

Rajesh123

yes you can write like that

Rajesh123

Put in one column tag

<?if:string-length(ABC) != '0 '?>

<?ABC?>

<?end if?>

<?if:string-length(ABC) = '0 '?>

<?DEF?>

<?end if?>

<?choose:?>

<?when:ABC!=''?> ABC <?end when?>

<?otherwise:?>DEF<?end otherwise?>

<?end choose?>

Thilib Arivu

Hi Rajesh,

One small doubt

Do we need to pass it in a String or with String

<?xdofx: if ABC !='' then 'ABC' else 'DEF'?> <?end if?>

<?xdofx: if ABC !='' then ABC else DEF?> <?end if?>

Since ABC is Expression coming from the DB

Venkat Thota - BIP

You can directly use nvl function using xdofx function in RTF template

<?xdofx: nvl(ABC,'DEF')?> where ABC will the column or field. Thanks

Vani-R

Use the expression which Rajesh123 gave (<?ABC?> should be defined as BI Publisher Field)

Put in one column tag

<?if:string-length(ABC) != '0 '?>

<?ABC?>

<?end if?>

<?if:string-length(ABC) = '0 '?>

<?DEF?>

<?end if?>

Bruce Wang

<?xdoxslt:ifelse(ABC !='',ABC,DEF)?>

Ankur.Bansal

I have tried all the suggested options but nothing seems to work, I am pretty sure direct NVL used to work before

Mallikarjuna Kuppauru-Oracle

Hi @Ankur.Bansal

This is very old Thread if you still looking for an help/answer from community can you start new thread ?

https://community.oracle.com/products/oracleanalytics/categories/bi-publisher

Regards,

Arjun

Upcoming Event

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…

Top Leaders