Skip to Main Content


The APEX_IG PL/SQL package is finally here and it offers some long awaited features. Mainly, the setting and clearing of filters.


As it turns out, some of these functions contain some bugs, so for now, your mileage may vary. These problems should however be addressed in the general release.

Add Filter


Clear Report

Add some filters first, then use this procedure to clear all filters.

Reset Report

Change some settings of the report, hide/show columns, then use this procedure to reset the report to its initial state.


Much of the reason people asked for a Interactive Grid API was for the ability to fetch the current runtime query. While you will not find this functionality in this package, this has already been possible since APEX 19.2 through the APEX_REGION.open_query_context API.