See https://apex.oracle.com/pls/apex/f?p=134181:54
The SQL query is
with data as (
select
r.*,c.*,
mod(trunc(dbms_random.value(1,100)),2) val
from rows_tab r
cross join cols_tab c
)
select
d.*,
decode(val,0,'fa-remove',1,'fa-check') icon
from data d
VAL column has the HTML Expression as <span class="fa #ICON#"></span> to display the icon to represent 0 or 1.
Questions
- The report view displays the icon but the Pivot view continues to show the column value. How can I display the icon in the Pivot view too?
- Looks like the Interactive Grid in 19.2 still missing this Pivot feature. Is there a way to implement this in the IG to edit the 1/0 values? Plan B could be to wire up a dynamic action on the IR cells to save the value
Thanks