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.

• EQ = Equals
• LT = Less than
• LTE = Less then or equal to
• GT = Greater Than
• GTE = Greater than or equal to
• LIKE = SQL Like operator
• N = Null
• NN = Not Null

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