Do you ever run into a validation that perhaps you want the user to be able to bypass? Imagine, the validation is more like a warning and once you make the user aware they can proceed with the processing of …
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 »
APEX 5.1 introduced native functionality for warning the user when they attempt to navigate away from a page when the page contains unsaved changes. However, this feature doesn’t track items created via the APEX_ITEM API. Which brings me to the …
I often need to have a single item on a page (think a search item above a report for example). I would like this item’s label to still align to the right, but be flush with the left side of …
I recently had this requirement for freezing the column and header on a Classic Report, just the way you can with Excel. The report had too many columns and once you scroll horizontally or vertically you would loose track of …
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 …
Modal Dialogs in APEX5 use the Modal Page Title attribute as the Title of the dialog. Often, I wish this valuable area of the page could convey more information. So, I thought I could use a Substitution String in the …
“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 »