Hi,
I am on APEX 24.2.6 and facing a issue when using : apex_region.open_query_context followed by calls to APEX exec to retrieve data from an interactive report containing computed columns. It seems the query is populating the computed columns with (null) instead of the computation.
E.g.:
… (extracted from apex_debug_messages)
from (select "TITLE","CUSTOMER_NAME","CONTACT_TYPE","PHONE","EMAIL",(null) "APXWS_CC_001",(null) "APXWS_CC_002","CUSTOMER_ID",
…
If I use the (deprecated) APEX_IR.GET_REPORT, the query correctly includes the computations:
…
"CONTACT_TYPE","PHONE","EMAIL",(TO_CHAR ( LENGTH ( "NAME" ) )) "APXWS_CC_001",("NAME" || ' TEST') "APXWS_CC_002","CUSTOMER_ID","
…
Does this mean that IR computed columns are not currently supported in apex_region.open_query_context ?
Thanks
Martin