Oracle Apex Interactive reports URL filters
Warning: mysql_get_server_info(): Access denied for user ''@'localhost' (using password: NO) in /home/blucel/public_html/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php on line 10
Warning: mysql_get_server_info(): A link to the server could not be established in /home/blucel/public_html/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php on line 10
Quick post to remind you all of the interactive report url parameter filters available in Oracle Apex.
Usage: http://myserver/pls/mydad/f?p=1:12:3318977423147915::NO:CIR:IREQ_INSIGHT:complaint
This code filters the IR on page 12 to only show insights with a value of complaint
If you want to filter a report with PLSQL then use the following APEX_UTIL procedure.
apex_util.ir_filter(
p_page_id in number, -- Page that contains an Interactive Report
p_report_column in varchar2, -- Name of the report SQL column to be filtered
p_operator_abbr in varchar2 default null, -- Filter type
p_filter_value in varchar2); -- Value of filter, not used for N and NN