Hi everyone,
I have 2 identical columns in my Interactive Grid:
(column A) to be shown in the Grid (since it is an HTML Expression) and not shown in the CSV
(column B) to be shown in the CSV after export and not shown in the Grid.
There are no problems with the (column A) - just set 'No' to Include In Export/Print. However, I'm struggling with the latter (column B), so far I have tried the following things, but it is not exactly what is needed:
I set 'Hidden' type for the column B, but then there is no Header in the CSV report for this column, which is not a good option.
I tried to set a Server-Side Condition for column B as the following SQL Expression: NVL(:REQUEST,'EMPTY') NOT IN('CSV','XLS','PDF','XML','RTF','HTMLD') , but it didn't work. I also noticed that in my case :REQUEST equals to APEX_AJAX_DISPATCH in both Grid and CSV. Maybe there is another variable to indicate whether the data is shown on the Grid or in the CSV?
Eventually, I created a Dynamic action on Page Load to hide Column B apex.region("<ig_id>").widget().interactiveGrid("getViews","grid").view$.grid("hideColumn","<column B>"); . But it could be executed only after all the Grid data is loaded. So, firstly the column header is visible, but after the data is loaded it disappears, which is also not the perfect solution.
I would appreciate any advice on this topic. Thank you in advance!
APEX version: 19.2.0.00.18