Forum Stats

  • 3,769,513 Users
  • 2,252,970 Discussions
  • 7,875,068 Comments

Discussions

IR and apex_ir.add_filter

Brad Chriss
Brad Chriss Member Posts: 41 Blue Ribbon
edited Oct 27, 2021 11:05PM in APEX Discussions

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?

Tagged:

Answers