Print

Passing value via URL to IR Parameters

Posted in Interactive Reports.

Dynamic Reports are great for allowing your users to control their view of data. Recently I had created a 'help' form & report in my app to store help how-to's (rather than having them locked away in a document).

For each help record, I had added tags, and then displayed these using a tag cloud plugin.

travel help

Dynamic Reports are great for allowing your users to control their view of data. Recently I had created a 'help' form & report in my app to store help how-to's (rather than having them locked away in a document).

For each help record, I had added tags, and then displayed these using a tag cloud plugin.

travel help

 

One of the settings of this plugin is the Target URL - what action should be taken when the user clicks on a tag. I wanted the tag to then be passed into the 'Search' field of the interactive report - but as this is a standard field with the IR region (no explicit item name) this was not straighforward.

It is easy though!

We need to do two things:

  1. Use 'RIR' in the ClearCache Section of the URL to reset to the default Interactive Report on the target Page.
  2. Pass the tag (search term) into 'IR_ROWFILTER'

 

So, where 'TAG' is the name of my column from my sql query, and '40' is my page ID use this URL:

f?p=&APP_ID.:40:&APP_SESSION.:::RIR:IR_ROWFILTER:#TAG#
(for more into about the url, see aricle: Understanding the URL and how to Pass Parameters )
 
 
Additionally, you can also pass values to specific columns. Use the following format in the itemnames part of the url:
IR<operator>_<target_column_name>
Where operator can be: 
 
EQ equals (this is the default)
NEQ not equals
LT less than
LTE less than or equal to
GT greater than
GTE greater than or equal to
LIKE SQL like operator
N null
NN not null
C contains
NC not contains

 

Example:

http://myapps.com/apex/f?p=12345:1:0::::IRGTE_YEAR,IRLT_YEAR,IRLIKE_STATUS:2011,2012,OPEN 

 

 

About Me

I currently specialise in developing bespoke applications using Oracle APEX.I have worked with APEX since it was known as HTMLDB, but have also dabbled with E-Business Suite, Oracle AS Portal, ECM, Webcenter and Website Design.

I enjoy working with new clients and assisting them develop custom applications to enhance and improve internal business processes.

Find Me

mandy nerd2