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

CodePudding user response：

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:

1. click column heading, choose "Hide Column"
2. download data
3. 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

CodePudding user response：

I managed to accomplish it using this:

instr(nvl(:REQUEST,'~'),'HTML') = 0 and instr(nvl(:REQUEST,'~'),'CSV') = 0