Application Express 4.2.6.00.03
Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production
I have an Iinteractive report with a query that includes data depending on the user. Concept example below:
Select * from x
where private_data is null
where private_data is not null and :APP_USER = 'SPECIAL_USER'
or done via a different way...
(private_data is null or
private_data is not null and :APP_USER = 'SPECIAL_USER'
When these queries are used a single click on the Interactive report header produces and incomplete list of values. It does not list all the available options in that column.
It does this inconsistently, with some columns producing all values, and others not. Also, column with missing values prevuiously can have full list of values next day.
There is no problem with ACTIONS -> FILTER method. All data can be specified here and filtering will work.
Is there any information on the header functionality or work arounds that will solve this?
Or a better method of query that will solve this?
I wonder if this might actually be related to the paging of results. Perhaps only temporarily as an experiment, could you set the IR to return all rows with no paging and see if the problem persists?