Skip to Main Content
LOB Functions Mask Digits

Linking to Interactive Reports

How to link to Interactive Reports

Example

APEX_UTIL.PREPARE_URL (
             'f?p='
          || v ('APP_ID')
          || ':NN:'
          || v ('SESSION')
          || ':::RIR,CIR:IR[MY_REPORT]IN_MY_COLUMN_NAME:'
          || TARGET_VALUE_TO_SEARCH
          || '')

Where: 

  • NN: Target Page

  • RIR,CIR : Clear Report filters

  • IR : Prefix Mandatory

  • [MY_REPORT] : Static Id of Interactive Report.

  • IN : Report filter IN operator ( see operator list below)

  • MY_COLUMN_NAME: Interactive report column name.

  • TARGET_VALUE_TO_SEARCH: Value of filter

 

 

 

 

  • C = Contains

  • EQ = Equals (this is the default)

  • GTE = Greater than or equal to

  • GT = Greater Than

  • LIKE = SQL Like operator

  • LT = Less than

  • LTE = Less than or equal to

  • N = Null

  • NC = Not Contains

  • NEQ = Not Equals

  • NLIKE = Not Like

  • NN = Not Null

  • NIN = Not In (escape the comma separated values with a leading and trailing backslash, )

  • IN = In (escape the comma separated values with a leading and trailing backslash, )

  • ROWFILTER = Row Text Contains (this searches all columns displayed in the report with type STRING or NUMBER)

 

 
www.1apx.com
_