Forum Stats

  • 3,874,594 Users
  • 2,266,750 Discussions
  • 7,911,908 Comments

Discussions

APEX_UTIL.IR_FILTER button/textbox help

Doolius
Doolius Member Posts: 115
edited Mar 10, 2014 11:04AM in APEX Discussions

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

Answers

  • 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
    Doolius Member Posts: 115

    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');

This discussion has been closed.