I wrote a post a couple of weeks ago about our roll-out of APEX 5.1.1 to our Dev and Test systems. In that post I said we would probably go live pretty quickly. I intended to write a quick post to say when it happened, then promptly forgot…
Just a quick note to say there were no issues found in our Dev and Test systems, so we quickly moved it out to production. I think it (more...)
The latest version of Oracle Application Express has been made available yesterday for download from Oracle as reported by Joel Kallman.
As usual a number of issues and bugs have been fixed, read more in Apex 5.1.1 patch set notes.
I have an editable tabular form using Apex’s old greyscale edit link icons:
The users complained that they currently have to click each link to drill down to the detail records to find and fix any errors; they wanted the screen to indicate which detail records were already fine and which ones needed attention.
Since screen real-estate is limited here, I wanted to indicate the problems by showing a red edit link instead of the (more...)
Sometimes, it's the little things in an application that make users happy.
Sometimes, it's just the icon on a darn button, card, or menu that makes all the difference.
Surely by now you've encountered using icons within Oracle APEX, and we've come a long way since Theme 25. To get anyone up to speed, APEX 5.0 saw the introduction of Font Awesome baked into the builder, which is a reputable CSS icon library for (more...)
Recently I was asked to create a simple Master-Detail Apex form on top of some metadata tables stored within Oracle 12c. Apex version 4.2 is already pre-installed in 12c but it needs configuring to be able to use. This is where I hit some trouble which stems from a conflict of information across a number of different sources.
It's February, so it must be time to do this. I explore what thoughts arise from looking back, and forward to the future. It helps me to remember stuff, decide what to do, and apparently some people find it interesting.
So many tools. And I arguably don't use enough of them.
It's out and I'm excited. Unfortunately, scheduling is super tight, so I'll be waiting at my current site until hopefully around (more...)
I have an Interactive Report that includes some editable columns, and the users wanted to include some “quick picks” on these columns to make it easy to copy data from a previous period. The user can choose to type in a new value, or click the “quick pick” to quickly data-enter the suggested value.
Normally, a simple page item can have a quick pick by setting the Show Quick Picks attribute on the item. This (more...)
I thought I'd add a simple demonstration, for reference.
Consider the following query, with variations of escaped column output.
with data as (select q'[G'day,]'||chr(10) ||'Scott<strong>loves</strong>' ||'<br>APEX<script></script>' as string from dual) select -- UI default string dflt -- where no tags expected ,apex_escape.html(string) protected -- good for most things ,apex_escape.html_whitelist(string) whitelisted -- replace line feeds with HTML line break. (more...)
I was looking at the GitHub "contribution chart", which shows number of commits per day as a heatmap calendar. I thought this type of chart would be cool to have as an APEX plugin, so I went ahead and implemented it.
Here is a video I recorded to walk through how the plugin was made: