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

isnotavailable

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).

Nermin Khaled-Oracle

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?>