Often I want to configure an APEX page based on how many rows have been returned in a (typically classic) report region. There are a number of methods for determining this row count, and some have advantages over others.
1) Computation while rendering the page.
I first blogged about build options
three years ago while still using APEX 3.x - I can tell by the green ;-)
I still use them regularly
, but not often for versioning as they're allocated at a component level and not for attribute modifications - perhaps in later (more...)
I find build options
as nifty tools to not only categorise components for the very purpose build options are documented for, but to help inform developers & testers of applications.
Here I've added a region on the global page to inform users of the status of the page - based (more...)
In a recent post
I showed how to determine the APEX region title on load of the page. This post will show how to change the region title dynamically - without submitting the page, and still in three steps.
1) Add a static ID to the region you want to (more...)
At this year's Australian Oracle User Group Insync13
conference series I conducted a half-day workshop in Melbourne, Brisbane and Perth called "Spice up your APEX application with third party plug-ins
I selected some commonly used plug-ins that I thought would be interesting and showed attendees how to download, (more...)
From my employer's perspective we had a very successful year at the Perth Insync13 conference. Sage
had 7 papers from 4 of our team, and as usual our exhibition booth was very popular.
We were pushing the mobile theme this year to help stand out to enter our giveaway you (more...)
At this week's Perth Insync conference I attended a great session comparing Oracle Glassfish Server (OGS) with Web Logic Server (WLS), only to find out that Oracle will discontinue future commercial support of the OGS product as of 4th November 2013.
This instigated a great flurry of discussion as one (more...)
"which I repeat here for everyone that find's this page"
Well Morgan, I found the page.
The backstory - I've been tidying my bookmarks, and I read through ACE Director Daniel Morgan's
thoughts for 2013.
(For those Oracle technologists who haven't seen his Library
, bookmark it now.)
I saw a forum post
recently asking how to dynamically change the region title.
This is a little ambiguous - is this dynamic to the value set in APEX meta-data, or dynamic as a result of user events on the page?
Here is the instructions for the former. Soon I (more...)
This post covers one way of customising the declarative sum totals on classic APEX reports.
|Classic Report sum totals|
The default output isn't that flash looking, and no doubt many would prefer at least a different label. Unfortunately I haven't found a method within APEX, so I applied some jQuery. (more...)
Dynamic actions are awesome.
Let's so you have a scenario where after you change the value of one item, you would like to validate it or perhaps calculate the value of a separate item - or both!
Given an entry of Radius
, I would like to calcular Sphere area
I like Tim Minchin.
One year I took my wife to see him with West Australian Symphony Orchestra (WASO) at Kings Park in Perth - now she likes Tim Minchin.
It's a shame he didn't perform his 10 minute beat poem, but that's best watched animated
, thanks to a (more...)
Attention Perth residents - and perhaps those interstate...SAGE Computing
are holding a 4 day Oracle Application 4.2 course from the 28th October, 2013.
Please contact me or Penny if you're interested in attending.
Sometimes to get the data displayed exactly how you want it, you need to employ some nested functions.
with t as (
select null n from dual union all
select 0 from dual union all
select 0.5 from dual union all
select 4 from dual union all
select 4. (more...)
It can be fairly simple to configure your APEX application to authenticate against your Active Directory server - this means your users can use the same username/password as the use to log onto their desktop machine - a big plus.
Declarative definition can be as simple as heading to Shared (more...)
Not all regular expressions are scary.
As the documentation
states, REGEXP_COUNT returns the number of times a pattern occurs in a string.
We can do this to simply count how many times the letter S appears in a string
select job, regexp_count(job,'S')
While many in the Oracle universe are enjoying OOW, here in Perth we are preparing for our leg of the Insync Conference Series
This year it's on 12-13 November at Pan Pacific Perth Hotel
- a healthy walk or short free bus ride from the Perth CBD.
Long story short - (more...)
Creating triggers, prior to 11g, would default them to an enabled state.
From 11g, we have this in the documentation
By default, a trigger is created in enabled state. To create a trigger in disabled state, use the DISABLE clause of the CREATE TRIGGER statement.
So when I write (more...)
If, like me, you are nowhere
near APEXposed in Montreal
, but you are interested in what might be coming in APEX5, then you must read this post from Scott Spendolini (USA Scott)http://spendolini.blogspot.com.au/2013/09/apex-50-impressions.html
Other commentary on APEX5 here
Scott (Australia Scott)
One of the reasons I
renamed this blog grassroots
-oracle was to occasionally illustrate some simple examples of functionality not everyone is aware of - or are maybe too scared to give it a go (or research).
Still today I occasionally work with people who aren't familiar with some (more...)