One of many small enhancements in Oracle APEX 5.0 is a small utility that can be used to help debugging an APEX application from SQLPLUS or sqlcl.
Category Archives: Tipps & Tricks
human readable URLs in Oracle APEX – Part 3
In the first two parts of this blogpost series we covered the basics and the technique on how to provide nice/friendly/readable URLs for a public APEX Application.
If you haven’t read the other two parts, please go back and read part 1, then read part 2. Done? Ok, lets continue. Continue reading
human readable URLs in Oracle APEX – Part 2
In the first part of this Blogpost Series we touched some fundamentals and finally listed some options. If you haven’t read it, yet, please do now before continuing here.
The last post ended with me saying I found a way for hrURLs that works with APEX Listener, mod_plsql and EPG.
I haven’t tested the Thoth Gateway, but based on the documentation I’d say it works as well as the mod_plsql way.
hrURL – human readable URLs in Oracle APEX
Searching the APEX Forum for nice URLs is as old as Oracle APEX itself, so far without much luck. There is magic switch that forces APEX to create readable URLs.
As part of preparing my Presentation “Going Public” for Kscope 2014 in Seattle, I investigated the available methods on providing readable URLs and found some good ones.
You can check this public APEX website to see how good URLs can look like: www.click-click.at
Set Cursor to Interactive Report Search Field
A Question I get over and over again is: how can I position the Cursor in the Interactive Report Search Field when the Page Loads?
Well, the Answer is simple, but not obvious.
At first you have to change the Page Setting Cursor Focus to Do not focus cursor, because the Setting First Item on Page doesn’t count the IR-Search Field as Item.
Plugin Competition – Win a Prize!
Today (Tuesday March 27th 2012) started the first ODTUG APEX Plugin Competition. This is a chance for everybody to submit their self created Plugins to get reviewed, judged and maybe win one of the many Prizes available.
Plugins will be judged upon skill level of its creator. That means beginners and experts will not be in the same category, to make it fair to everyone.
ApexLib APEX Developer Addon
Do you ever wanted to have Syntax Highlighting in the APEX Application Builder?
Or Keyboard Shortcuts for Save, Run, Next and others?
What about efficient and quick Navigation through the Application Builder? e.g. Jump directly from Edit Page to Application Items?
Set Interactive Report Filter with URL Parameters
Interactive Reports are very powerful, the end user can set filters, highlighting, add computed columns, do control breaks or groupings and much more.
As a Developer you might sometimes have the requirement to redirect from one page to another which displays an interactive report, but this report should be filtered by whatever value is selected on the first page.
Continue reading
Enable support of $v and $s for your APEX Item Plugins
Roel informed me that my HTML5 input type plugins don’t support the APEX Javascript API’s $v and $s (to retrieve and set the content of the item via Javascript).
After some quick investigations i detected that some Javascript was missing in my Plugin.
Hidden mobile Support in Oracle APEX 4.1
Mark Sewtz just revealed a secret: Oracle APEX already contains more support for mobile Applications as expected.
I had to try it out and see what’s new.