today:
22
yesterday:
179
Total:
1,001,118

Apex Interactive Report: The difference between CIR and RIR

You’ve probably already used the reset functionality in an Interactive Report, but do you know the exact the difference between CIR (Clear Interactive Report) and RIR (Reset Interactive Report)?

RIR or CIR, what is it?

First, let’s explain what CIR and RIR is and how you can use it.

With CIR and RIR you can clear or reset your Interactive Report after using filters. This can be handy if you’ve applied a filter on a page, but also want to (re)use the full report.

If you want to apply a filter on an interactive report when linking from another page you can use the following operators.

FunctionMeaning
IREQ_<COLUMN_NAME>Equals
IR_<COLUMN_NAME >Same as IREQ
LT_<COLUMN_NAME >Less than
IRLTE_<COLUMN_NAME >Less than or equal to
IRGT_<COLUMN_NAME >Greater then
IRGTE_<COLUMN_NAME >Greater then or equal to
IRLIKE_<COLUMN_NAME >Like operator
IRN_<COLUMN_NAME >Is Null
IRNN_<COLUMN_NAME >Is not Null
IRC_<COLUMN_NAME >Contains
IRNC_<COLUMN_NAME >Not Contains

You can also use above functions in a saved report, then you have to use IR_REPORT_<ALIAS>.

Sometimes the page with the interactive report can be accessed by multiple pages and you would like to reset the filters already applied to the interactive report.

i.e. You have a page with Countries and you want to filter your existing Customer Report to all customers in selected state. But, when you click on Customers on another page you want to see all customers, not only the ones you just filtered. In this case you can use CIR or RIR.

You can simply enter these options in the URL or the Clear Cache option in your button / branch.

APEX_CIR_RIR

But what is exactly the difference between using the CIR and the RIR?

As the name suggests, CIR Clears and RIR Resets.. But isn’t that the same?

Almost. The main difference is that CIR Clears the report, clearing all breakpoints, filters and other defined actions on your report, ignoring the settings of the primary report. RIR Resets the interactive report to the primary report.

In the following table you can see which user defined modifications to an Interactive Report will be lost or kept when using the CIR/RIR clear cache option.

 CIRRIR
Main FunctionClears Interactive ReportResets Interactive Report
No. Subject Author Date Views
86 What Is ERP? admin 2018.02.14 121
85 LIST OF VALUE (DYNAMIC) admin 2016.04.28 126
84 Global & Custom Serach file admin 2016.04.28 127
83 Column Data 일괄 추가 admin 2023.11.24 128
82 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 132
81 Oracle APEX 5.1.4 Installation admin 2018.04.17 132
80 Delimiter admin 2016.04.29 133
79 APEX Connect 2016 - David Peake - New Features in Oracle Application Express 5.1 admin 2017.11.25 135
78 How to Update Oracle XE admin 2018.04.25 138
77 BOOLEAN SAMPLE admin 2016.05.11 144
76 COUNT admin 2016.04.28 145
75 Outer Join with Oracle SQL admin 2016.04.29 147
74 wwv_flow_files admin 2016.05.01 147
73 Field Showing admin 2016.04.01 148
72 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 149
71 CREATE (INSERT) PROCESS admin 2016.04.28 150
70 NVL admin 2016.05.19 151
69 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 151
68 PHONE NUMBER admin 2016.04.28 152
67 MAX admin 2016.04.28 154