'Apex - Not able to exclude column in exported file
I have an interactive report and the goal is to let the user export the data but without 1 column. What I tried for the column in question:
1) Server-side condition - Request is NOT contained in value; Value - CSV, HTML
2) NVL(:REQUEST,'EMPTY') not in ('CSV','HTMLD')
The column I am trying to not export is a link with an icon. I tried changing it to 'Plain text' but to no avail.
Oracle Apex version 21.2.0
Solution 1:[1]
I managed to accomplish it using this:
instr(nvl(:REQUEST,'~'),'HTML') = 0 and instr(nvl(:REQUEST,'~'),'CSV') = 0
Solution 2:[2]
As far as I can tell, there's no declarative way to do that.
What you (actually, end user) can do, is to hide that column before downloading:
- click column heading, choose "Hide Column"
- download data
- result - no "Empno" column there
Or, let them download everything and then
- hide (or delete) unwanted column from the Excel file, or
- (even simpler) ignore it
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | yomac |
| Solution 2 | Littlefoot |