Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Condition Formatting in RTF template - "is not null"?

Received Response
759
Views
1
Comments
isnotavailable
isnotavailable Rank 1 - Community Starter
in Oracle Analytics Publisher

I have some boilerplate text and a field value that I only want to show if the field value is not null. How do I achieve this? The conditional options only seem to be to compare to some other field in the data model (equal to, not equal to, etc).

Answers

  • Nermin Khaled-Oracle
    Nermin Khaled-Oracle Rank 1 - Community Starter

    In your data model query, assign this field value to a specific unique value in case of NULL using NVL. Then in the RTF template write the condition to display your data when it doesn't equal this specific unique value.
    For instance:
    in your data model query:-
    Select NVL(COLUMN, 'NO_DATA') FIELD_NAME
    in your RTf:-
    <?if:FIELD_NAME!='NO_DATA'?> display whatever you want <?end if?>