Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IR Add Filter Call

Brad ChrissJun 18 2025

When calling APEX_IR.ADD_FILTER against an IR column, is there a reason it only uses ‘EQ’ operator in stead of any other operator?

APEX_IR.ADD_FILTER (
            p_page_id   =>    p_page_id,
            p_region_id =>    v_region_id,
            p_report_column => 'A500_VOUCHR_NR',
            p_filter_value  => APEX_UTIL.GET_SESSION_STATE('P5_VOUCHER_NBR'), 
            p_operator_abbr => 'C', 
            p_report_id     => NULL );

This code always revert back to EQUALS TO ('EQ') when the filter runs

Is there an override in the column properties?

Comments
Post Details
Added on Jun 18 2025
11 comments
123 views