BI Publisher (MOSC)

MOSC Banner

Need inputs to check NVL condition in IF statement

Hi Team,

In the RTF template, we have multiple fields that need to be validated after the for-loop. Some of these fields may contain data, while others may be null. In cases where an XML tag does not contain any data, it is necessary to use the NVL function to assign a constant value during comparison. I attached the sample xml and template for your reference.

<?for-each:PERSON_REC?><?if: ((PERSON_SSN != PERSON_SSN_OLD) or (PERSON_NAME != PERSON_NAME_OLD))?>

Can you share inputs how to use NVL condition in the rtf template.

Thanks,

Viswanadh K

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