Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reset button on Interactive Report with partial page refresh

AppExJan 21 2023

IG has a Reset button but IR doesn't?
I've looked up and all I find is to set the button to redirect to the same page (&APP_PAGE_ID.) with Clear Cache set to page ID,RIR. Even the App Builder page in APEX has the Reset button that does nothing more than redirect to the same page with an RIR.
I'm looking for the button logic that refreshes just the IR region (PPR) with the same confirmation (or no confirmation) but without page redirection or full page refresh for an optimal behavior, consistent with IG. The Reset should just clear the Search and Filter criteria and retain all other customizations such as sorting, highlighting, control break, etc.
What is the code to use for the custom Reset button placed in the IR's header? There is a Reset menu option in Actions -> Reset. Can we copy its code to the Reset button? What is the code? I'm not a JS developer yet.
TIA

This post has been answered by Louis Moreaux on Feb 3 2023
Jump to Answer
Comments
Post Details
Added on Jan 21 2023
3 comments
2,109 views