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:
p_page_id => 10,
p_report_column => 'PCFN',
p_operator_abbr => 'C',
p_filter_value => 'PCFN_VALUES',
p_report_alias => '000001'
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.