1 Reply Latest reply on Nov 9, 2018 10:59 PM by Justin Warwick

    IR Report Header content - not displaying all data for Union Query

    Mr Neil

      Hi all,

       

      Application Express 4.2.6.00.03

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.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

       

      union all

       

      Select * from x

      where private_data is not null and :APP_USER = 'SPECIAL_USER'

      ----

       

      or done via a different way...

      -----

      Select * from x

      where

      (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?

       

       

      Thanks,

      FM