1. Overview
This document talks about how to User can include or exclude the columns while downloading the reports
2. Technologies and Tools Used
The following technology has been used to achieve this functionality in Oracle Apex.
- Oracle Apex
3. Use Case
- To Include columns only for download
- To exclude columns only for download
4. Architecture
Following steps explains in detail,
Include column only in download
Step1:
Hidden column cannot be downloaded in interactive report if,
Display As : Hidden
Include In Export : Yes
Step2:
This can be achieved using the PLSQL Function body returning a Boolean :
Column attributes->
Display As : Display as Text
Column attributes-> Conditional display->
Condition Type : PLSQL Function body returning a Boolean
Expression: RETURN NVL(:REQUEST,’EMPTY’)IN(‘CSV’,’XLS’,’RTF’,’HTMLD’)
OR
NVL(wwv_flow.g_widget_action,’EMPTY’)=’SEND_EMAIL’;
Exclude column only in download
Step1:
Display column will be downloaded in interactive report if,
Display As : Display as Text
Step2:
This can be achieved using the PLSQL Function body returning a Boolean :
Column attributes->
Display As : Display as Text
Column attributes-> Conditional display->
Condition Type : PLSQL Function body returning a Boolean
Expression : RETURN NVL(:REQUEST,’EMPTY’)NOT IN(‘CSV’,’XLS’,’RTF’,’HTMLD’)
OR
NVL(wwv_flow.g_widget_action,’EMPTY’)<>’SEND_EMAIL’;