Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

APEX_UTIL.IR_FILTER button/textbox help

DooliusMar 10 2014 — edited Mar 10 2014

I have created a button (PCFN_SEARCH) and a textbox (PCFN_VALUES) in the region of one of my interactive report pages.

I want the user to be able to type in multiple values, separated by commas, and press the PCFN_SEARCH button and basically do the same thing the Filter would do with the 'IN' operator.

I've created a dynamic action, on click, with the following PL/SQL code:

BEGIN

    APEX_UTIL.IR_FILTER (  

        p_page_id        => 10,

        p_report_column  => 'PCFN',

        p_operator_abbr  => 'C',

        p_filter_value   => 'PCFN_VALUES',

        p_report_alias   => '000001'

        );

END;

This code does not work (which I kind of assumed that it wouldn't) my PL/SQL knowledge is not very high so any help is appreciated.

-Doolius

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2014
Added on Mar 10 2014
2 comments
203 views