Switching Interactive Report to Icon or Detail View in APEX 5 using Javascript

At yesterdays APEX Meetup in Vienna someone asked if there is a way to switch an Interactive Report programmatically (using Javascript) to Icon / List / Report – View in APEX 5, since gReport doesn’t exist anymore (which could do the job before APEX 5).

Application_Builder 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.

Continue reading

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

Continue reading

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.

Continue reading

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.

Continue reading

What’s new in Oracle APEX 4.1? – from the inside

We all read the blogpostings about what features were added in Oracle APEX 4.1, like the ones here, here, here and here.

But what does that mean on a more technical level? Which Views have changed, which API’s have changed?

Inspired by the Webinar over here I thought i’ll give the redgate Schema Compare Tool a try.

Continue reading