Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Conditional fa-icon in classic report

mtAug 16 2023

In a classic report, I'd like to have a column that conditionally shows either an edit icon, or a view icon. I adjusted my query as shown below - but I'm drawing a blank on how to get the icon to appear in the report rather than the icon name.

thank you-

mt in NY

select detail_id,

(select case when distribid in (select distribid from distrib_investor)
then 'fa-eye'
else 'fa-edit'
end
from dual) as status_icon

from distribdet
This post has been answered by Gabriel Guzman on Aug 16 2023
Jump to Answer
Comments
Post Details
Added on Aug 16 2023
2 comments
45 views