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