3 days - 3 cities - 6 presentations (4 different ones)
My tour started on Monday afternoon when I left my house around 1.30PM to get on the bus to the train station. The 2PM train left exactly on time for the Amsterdam airport. I arrived at Schiphol around 3:30PM, perfectly on time to catch the 5PM flight to Copenhagen.
The flight to Copenhagen was very uneventful. From the airport I took the train (more...)
It just isn't fair. If you install a Packaged Application - and you should because there is a lot to learn from those apps - in your APEX Workspace they all have a cool looking icon. And your own applications, just show up with two characters in a (random?) coloured box. Why can't I have a nice looking icon for my application?
For the third time in a row I'll be running for ODTUG's Board of Directors. But after ending as a runner up twice, I am sure I'm going to make it this time! But not without your help!
My campaign statement this year is:
I have been attending and presenting at Kscope conferences since 2007. This not only resulted in a vast amount of knowledge, but also - and even more important - a huge (more...)
In 1.5 week I'll be travelling to and through the Nordics as one of the speakers during the OTN Nordic ACE Tour
. It will be quite a busy schedule!
and one about APEX (more...)
When you have multiple Interactive Reports (IR) on your page and use a Region Display Selector to mimic tabs, you might notice some weird behaviour in the IR headings if you switch tabs. The headings are not positioned correctly and you get an extra empty row under the headings. It just looks weird and ugly. But if you resize your browser window, it all looks fine again (until you switch to another tab..)
The APEX Development Team recently mentioned that not only the Data Visualisations part of JET will be included in APEX 5.1, but the complete installation of JET. The whole package. That won't do the size of the downloadable install file any good, but more important is: what can we do with (more...)
In APEX you can define a web service that returns XML as below - all declarative, just a few steps through a wizard.
Then generate a report on top of that web service - again just a few clicks through a wizard. The generated query looks like this:
from apex_collections c,
XMLTable('/Response/S_getCustomerListTableArray/S_getCustomerListArrayItem' passing xmltype001
At my current project we use Interactive Reports heavily. But in some cases the underlying queries are rather complex and a query without any filter or with just a filter on all columns doesn't perform that well (understatement...). We already implemented a solution to prevent initial loading of the data by adding an additional criterium to the query ( :P400_SEARCH = 'Y'
). The default value of this hidden item is 'N' and on (more...)
Creating a Navigation Bar using static values is very straightforward. Just create a list similar to this example below - and you can easily define multiple levels.
Then, in the User Interface Attributes, set that list to be your application's "Navigation Bar List" and specify the template.
And the Navigation Bar pops up nicely in the upper right corner of the screen.
So far so good.
But what if you don't want a Static List, (more...)
This afternoon my Twitter timeline exploded with retweets, likes and congratulations. It all started with this tweet:
So it's official now. As Sarah Zumbrum had to step down due to her (dream) move to Oracle, a position on the ODTUG board opened up. And I was asked whether I was still interested. And of course I was! So after an internal voting procedure, I received the good news last weekend - and had to keep (more...)
A customer of mine switched to a Singe Sign On Authentication Scheme for their APEX application - using Oracle Access Manager, but that's irrelevant to this case.
The renewed Calendar Region in APEX is awesome. With just one SQL statement you can provide your users with a calendar view of their data that looks very familiar to what they already know, use and love. Apart from one thing: Navigating to a specific date is cumbersome.
The shortest route is:
- Navigate to the right month (can be any number of clicks)
- Switch to "Week view"
- Navigate to the right week (between 0 and (more...)
Last month was the annual election for the Board of Directors of ODTUG. And just like the year before, I was one of the 19 (!) candidates for one of the 5 spots.
During the campaign and election periods I received a lot of positive feedback and my hopes were high - but the competition was extremely strong. During Oracle Open World the results were announced and I was notified I hadn't made (more...)
Apart from the Current Record Indicator in your APEX Reports
, another question often pops up at my client sites. A lot of functionality is implemented using a Report and a (Modal) Form. But to access that Form, the user has to click exactly on the small link icon in the first column of the report. So can that be changed, making it more "accessible"?
Set the Link Attributes of the column you're using for (more...)
Developers with an Oracle Forms background might still remember this nice feature: If you click on a row in an Oracle Form "report" then it can be highlighted - either the full row or just a small first item of the row. The main difference with the Oracle Forms "reports" and the APEX Reports is that in Forms a "report" is usually comparable to an APEX Tabular Form. But a similar feature is frequently asked (more...)
Recently at a client site I ran into a strange issue. There was an APEX page where you can set some parameters and then a report would refresh according these new settings. But the strange thing was: Sometimes it worked perfectly, but sometimes it didn't. In the latter case one or more of the parameters seem discarded... WTF ??
So I dived into it and looked at the code. The parameter / refresh mechanism was implemented (more...)
APEX 5 comes with Modal Dialogs out of the box. Very neat. Especially for adding and changing data. And to minimise the number of time a user has to click, it could be useful to add a "Close Dialog
" process after the actual data processing. When the data processing fails, the Dialog stays on top showing the error. When data processing runs fine, the Dialog is closed ... without any confirmation. And this might (more...)
It took a while, but last month the second edition of the Expert Oracle Application Express
was released. It is the natural successor of the first edition (duh), but its not just that. Some of chapters are updated for APEX 5, but about half of the chapters are completely new
! And that means also half of the authors are new as well. Because this is a joint project, 14 authors, 14 chapters, one goal. And (more...)
APEX 5.0 has been released this spring. People who have already spent some time on this new version know this version is packed with new features aimed to make APEX developers even more productive, like the Page Designer.
Another striking new subset of features is aimed at creating better looking user interfaces for your APEX applications in an easy and maintainable way.
The definition of user interface components in APEX 5.0 is very (more...)