My Oracle Support Banner

Oracle Apex Linking To Interactive Reports Using IN / NOT IN Column Filter Does Not Work (Doc ID 2561661.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Application Express (APEX) - Version 18.2.0.00.12 and later
Information in this document applies to any platform.

Symptoms

Created a button which executes a branch process with behavior "function returning a URL (redirect)" to redirect the page to an interactive report on another page.

Code is --  return 'f?p=&APP_ALIAS.:2:&APP_SESSION.::&DEBUG.:RP,CIR:IRIN_CUST_FIRST_NAME:ABC,\DEF';

The page loads successfully however only the first value of the IN parameter is applied to the column filter
in this case only ABC info is been displayed

The documentation at

https://docs.oracle.com/database/apex-18.1/HTMDB/linking-to-interactive-reports.htm#GUID-A46FD7AC-A474-4443-9208-473BD4E17F00

states that to use the IN operator We need to "escape the comma separated values with backslash, ".

 '\' has been provided but taking only the first value is being read.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.