Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to hide Column Formatting / HTML Expression when column is empty in an Interactive Report

PhilMan2Apr 24 2022

I'm using Apex 21.2 on a 21.C database.
I have an Interactive Report with a column named VIDEO_LINK with the following characteristics:

Type = Plain Text
Column Formatting/HTML Expression = <a href="#VIDEO_LINK#" target="_blank">Click Here</a>
Server-side Condition/Type =  -Select-

The links pointing to the video file can be too wide for the report, so I implemented the solution identified above. All that shows in the column is the clickable text "Click Here". The problem is that if the VIDEO_LINK column in a given row is null, then clicking on the link "Click Here" opens up a new window with a copy of the Interactive Report. When the VIDEO_LINK column is populated I want a new window to be opened with the video (hence the target="_blank" clause). That part already works fine. However, when the VIDEO_LINK value is null, i'd like to not display the link "Click Here". Or as an alternative, to not open up a new window. Thanks for looking at this.

This post has been answered by fac586 on Apr 24 2022
Jump to Answer
Comments
Post Details
Added on Apr 24 2022
2 comments
958 views