I have a region with two sub-regions. In one region are three page items to be user as filters, along with a btn to apply the filter from a DA. The second region is an IR.
On click (of the btn) PL/SQL (below) runs and tries to apply the filters.
The issue is APEX returns an error stating the report doesn't exist. After verifying the report_id contains the correct interactive_report_id with querying the DB and through browser dev tools, this error makes no sense to me.
DECLARE
page_id NUMBER;
region_id NUMBER;
report_id NUMBER;
BEGIN
SELECT page_id, region_id, interactive_report_id
INTO page_id, region_id, report_id
FROM apex_application_page_ir
WHERE region_name = 'Daily Cash Blotter Report';
apex_ir.add_filter(
p_page_id => page_id,
p_region_id => region_id,
p_report_column => 'SF1219_M_DSSN',
p_filter_value => :P900_DSSN,
p_report_id => report_id,
p_operator_abbr => 'EQ'
);
apex_ir.add_filter(
p_page_id => page_id,
p_region_id => region_id,
p_report_column => 'SF1219_M_SYSTEM_NAME',
p_filter_value => :P900_SYSTEM,
p_report_id => report_id,
p_operator_abbr => NULL
);
END;
Alternatively I tried to understand this tutorial, but it seems "htmldb_Get()" is no longer supported by javascript. What is the alternative to "htmldb_Get()" for APEX 20.2?