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

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…

Top Leaders

User_UA8ST 20

Nathan CCC 20

MSA1 15

DDas3 15

VMITTAKANTI-HCG 1