Category: APEX

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 »

Tagged with:

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 …

Warn on Unsaved Changes for APEX_ITEM Read More »

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 …

Single Item CSS Grid Alignment Read More »

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 …

Freeze Column & Headers Plugin 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 »

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 …

Dynamic Modal Dialog Titles in APEX5 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 »

Do you want to add Drag & Drop functionality to your APEX applications? That’s what this video is all about. You’ll see me working on the list created in the previous episodes (Part 1, Part 2 and Part 3) and …

Video: Part 4 – Implementing Drag & Drop functionality Read More »