Thursday, July 30, 2020

Exclude columns while downloading the Interactive report data in Oracle APEX


SELECT T.CITYID,
         T.CITYID AS CITYID_DISPLAY,
         T.CITYNAME,
         COUNTRYID,
         (SELECT C.COUNTRYNAME
            FROM COUNTRY C
           WHERE C.COUNTRYID = T.COUNTRYID)
            AS COUNTRYNAME,
         'Delete' Del
    FROM CITIES T
ORDER BY UPPER (T.CITYNAME) ASC

To exclude CITYID while export/download from Interactive Report:

Select the column -->Server-Side Condition -->  Type (PL/SQL Expression) --> Paste below script

nvl(:request, 'EMPTY') not in ('CSV','XLS','PDF','RTF','HTMLD')
and nvl(wwv_flow.g_widget_action, 'EMPTY') <> 'SEND_EMAIL'

No comments:

Post a Comment

Delete Row Button to all records of Interactive Report in Oracle Apex

 1. add 'Delete' Del column to Report Query 2. Set the Following Properties for the DEL Column Type: Link Heading: Delete Targ...