APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to filter interactive report columns when multiple interactive report in a page

User701669-OracleJun 29 2017 — edited Jul 4 2017

Hi ,

I am having a difficult time debugging the filtering of an Interactive report through URLs (https://docs.oracle.com/database/apex-5.1/HTMDB/linking-to-interactive-reports.htm#HTMDB30108) when a page has multiple interactive reports. Though I am passing the "itemName" and "ItemValue" in the URL, the filter is not applied. What is interesting is that operator "ROWFILTER " works. I am using "Universal Theme - 42"

I have two interactive reports. I have provided the Name and Static of both in the table below

I am trying to perform a filter on a column "Bug" in BugDetailsIR. Therefore, I am constructing the following URL. Please note the Static ID of the interactive report is provided within [] .

.... CIR:IR[BugDetailsIR]_Bug:111111

This does not work.

However, if I contsruct URL

.....CIR:IR[BugDetailsIR]_ROWFILTER:12748962

I can see the filter being applied. This works.