Thursday, December 29, 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

11 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
  5. Nice blog about punchout XML, it's being great to read this.
    CXML Punchout

    ReplyDelete
  6. Thanks for sharing artile about OCI Punchout
    cXML PunchOut

    ReplyDelete
  7. Thanks for sharing artile about OCI Punchout
    cXML PunchOut

    ReplyDelete
  8. Its not working on apex 5.1, Please suggest.

    ReplyDelete
  9. Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad

    ReplyDelete
  10. Hi where to give tis condition in IR report can anyone please suggest

    ReplyDelete