A client posed a reasonable question; could we just click on a button to reset an Interactive Report? Paraphrasing the conversation, the genesis of this request was that in order to reset a report we need to click Actions > …

Add a “Reset” button to your Interactive Reports Read more »

You may be familiar with the handy Substitution String #TIMING# in Oracle Application Express (read more about TIMING and other Substitution Strings).When you add it to the footer (or header) of a region you get to see how long it …

How to Hide & Show a region’s TIMING during development Read more »

As you may already know, APEX 5.1 implements native Warn Before Exit functionality. Basically, if the user makes changes on a page and tries to navigate away before they save their changes, they get a warning. Modal Pages also get …

Warn Before Closing APEX Modal Dialogs Read more »

“Substitution Strings, Bind Variables, and APEX Links” oh my. Have you ever build an APEX link manually and perhaps it looked something like this: ‘f?p=&APP_ID.:PAGE:&SESSION.::&DEBUG.:’ We should talk. I used to make this mistake and I’ve seen it made too …

Video: 006 – Substitution Strings, Bind Variables, and APEX Links Read more »

Picture a Report and Form pages used to edit records. The Report is an Interactive Report and the edit page is Modal. When the modal closes the IR refreshes, but also, the page jumps to the top after the refresh. …

Video: 005 – Restore screen position after refresh Read more »