Databases Reference
In-Depth Information
Figure 13-35.
Report with filter programmatically set
IR_DELETE_REPORT
IR DELETE REPORT
is the programmatic way to delete saved interactive reports. It can be used to delete all
but the primary default report. If you want to build the ability to delete saved reports from within your
application, allowing administrators to delete reports who might not have access to the development
environment, you would use this. You would create a page that displays all the saved reports, querying
from the
APEX APPLICATION PAGE IR RPT
view and then call this procedure.
Please note that it must be executed from within the same running application where the reports
reside—if it is called from another application or from within SQL Commands, it will not work. The
syntax is very simple:
APEX UTIL.IR DELETE REPORT (
p report id IN NUMBER );
I used the following query to produce a report of all the public, non-primary reports in my
application.
select apex item.checkbox(1,report id) to delete,
page id,
(select page name
from apex application pages
where application id = :APP ID
and page id = ir.page id) page name,
(select r.region name
from apex application page regions r,
apex application page ir i
where i.region id = r.region id
and i.interactive report id = ir.interactive report id) region name,
report name,
report alias
from apex application page ir rpt ir
where application id = :APP ID
and report type = 'ALTERNATIVE DEFAULT'
