Thursday, 29 December 2016

Include or Exclude column in APEX interactive report download



Include column only in download

Hidden column cannot be downloaded in interactive report if,
Display As : Hidden
Include In Export : Yes
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
Display column will be downloaded in interactive report if,
Display As :  Display as Text
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

               OR NVL(wwv_flow.g_widget_action,’EMPTY’)<>'SEND_EMAIL';


By
Angel

5 comments:

  1. Hi,
    this solution is not working in APEX 5.1 Any idea?

    ReplyDelete
  2. This solution is not working , if columns are added or removed and then CSV downloaded.
    Please let me know if there is any workaround.

    ReplyDelete
  3. Finepac Structures Pvt. Ltd. offers exceptionally designed Distillation Column Trays. We have provided different column trays for various giants of Oil & Gas, Petrochemical, Chemical industries.

    column internals manufacturers

    ReplyDelete
  4. Thanks for sharing such a great article about Punchout CXML, it will help me in my work.
    Punchout CXML Catlog




    ReplyDelete