APEX_UTIL.IR_FILTER button/textbox help

Doolius

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

vincent_deelen

Hi Doolius,

Rather then writing a PL/SQL dynamic action, have you considered using an url redirect?

See this blog post for example:

http://www.oracle-and-apex.com/set-interactive-report-filter-with-url-parameters/

Regards,

Vincent

http://vincentdeelen.blogspot.com

Doolius

Vincent,

If I understood the "Linking to Interactive Reports" section of that it seemed like I would have to know what the user will be wanting to search for because of the examples:

f?p=...:IR_ENAME:KING

The previous example is equivalent to the end user creating a filter on the target page: ENAME = KING. Note that when an operatory is not provided, EQ is used because it is the default.

f?p-...:IRGT_SAL:300

The previous example is equilavent to the user creating a filter on the target page: SAL > 3000.

If this is the case, it is not what I am looking for. I will not know what the user wants to search for. I was able to automatically display the "Filter" box (located in the actions dropdown) on page load with the below code but do not know how to automatically set the operator to "in" as well.

javascript: gReport.dialog2('SHOW_FILTER');