APEX

Oracle APEX version 21.2

Oracle Database version 19_c_ (19.0.0.0)

I have an IR (Interactive Report) and inside the SQL query, one of the columns is an expression based on a case statement:

Just showing partial of the query.

select
       case table.spin_specimen
          when 'N' then
             table.spin_specimen
          else
             concat(
                    concat( '<a href="', APEX_UTIL.PREPARE_URL('javascript:void(0)') )
                   ,concat(
                           concat( '"data-spin_specimen=', nvl(table.spin_specimen, 'Y') )
                                ,'><input type="checkbox" name="Spin Specimen" value="Please spin the specimen">'
                          )
                   )
  from table
                   
             
             

So in the interactive report, I see either the value “N” or an actual checkbox

My question, I want a value to be set WHEN the user checks the checkbox. I've tried a dynamic action but at this point the page has already been rendered thus it won't know of the checkbox being “checked”. Once I get the value assigned to some hidden page item, then I can use that value to have ready so that in the next column over there's a button that will make a REST API call.

Any thoughts?

thanks,