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

Question

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.

Answer 1

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.