Tech, Oracle, user experience, coffee, design standards, and shameless ranting

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

Share

You can follow any responses to this entry through the RSS 2.0 feed.

Switch to our mobile site