oracle-apexoracle-apex-18.2oracle-apex-19.2

How to add conditional display to Interactive Grid column if no data returned for particular column

I have an Interactive grid based on data table with columns as : HEADER_1,HEADER_2...HEADER_6.

I want conditional display of columns such that if no row is returned for a particular column, i.e. if select HEADER_6 from data --> returns null, then HEADER_6 column shouldn't show at all.

I have page items created also for each column for another requirement like P4_HEADER_1...6, so in case they can be used in this also, please suggest.

Solution

  • Go to column HEADER_6 in section Server-side condition choose Rows returned and add query:

     SELECT 1
 FROM DATA
 WHERE = HEADER_6 IS NOT NULL;

    Or you can use item in Server-side condition.

    Column HEADER_6 will not be displayed if HEADER_6 is null.