3 Replies Latest reply on May 19, 2019 12:35 AM by partlycloudy

    Interactive Report - Pivot HTML Expression

    partlycloudy

      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

      1. 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?
      2. 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