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.

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.

Recover deleted Page with APEX and Firebug

Today a very important Page of an important APEX Application has accidentially been deleted. We didn’t want to step back to yesterdays backup, because right before the deletion many changes took place and we didn’t want to code that again.

Plugin: Month Picker

Last Week i had a customer requirement for an easy method to enter a date, but only month and year. Using the Date Picker Item it wasn’t possible to show a popup without the days, so I began a search and found a month picker jQuery Plugin. Using that it was easy to create an [...]

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 [...]

ApexLib 2.2 released

Since Version 4.1 of Oracle APEX – with it’s changed Error Handling – ApexLib didn’t work anymore. The changes in Oracle APEX 4.1 lead to compilation errors in APEXLIB_ERROR-Package.

ODTUG Vote for Board of Directors

Martin Giffy D’Souza is running for the ODTUG Board of Directors. I think this is a great idea, Martin is always very active in the APEX Community and tries to pass his knowledge further on. If he gets voted onto the ODTUG Board of Directors he’ll take care that APEX is further promoted with and [...]

Oracle APEX Events in Vienna/Austria

In my Opinion Vienna (Austria) is growing into one of the most important Places for APEX Enthusiasts to be. Not only are 2 Developers of the international APEX Development Team situated in Vienna (Patrick and Chris), but also is there a growing number of Events, Workshops and APEX Users (as Developer or as End User) [...]

Follow Up to APEX for Mobile Development Webinar

Two weeks ago my Webinar on APEX for Mobile Phones took place with many interested attendees. If you missed the webinar, you can view the recording over here. With this post i give you a listing of links to all ressources mentioned in the webinar, as well as some F.A.Q. regarding mobile on APEX. There [...]

Static LOV’s can contain any characters

Yesterday i stumbled (for the umpteenth time) over the static LOV limitations in Oracle APEX. I tried to have a comma (“,”) in the Return Value which messed up my LOV, because a comma is a seperation character in the LOV definition.

mobile for APEX 4.1 AND below

There is a lot of confusion going on about Oracle APEX support for mobile Phones (mobile Web-Applications). Yesterday started Kscope 2011 with some very interesting presentations and a load of Twitter messages following that.

Create a mobile Theme for Oracle APEX

This is Article #2 in my series about Oracle APEX on mobile Devices. If you haven’t read the first one, please do so now. This Article is based on the current release of Oracle APEX 4.0.2.00.07, but should also work on APEX 3.x and 4.1. With Oracle APEX 4.1 and later there will be more [...]

Create better XLIFF Files for Oracle APEX Translations

One of the many good things about Oracle APEX is the builtin capability to create multilingual Applications. It gives you a set of tools to translate your Application and provide it in multiple languages at the same time. One of the Key Components of this Translation Mechanism is the creation of an XLIFF File. This [...]

mobile Oracle APEX on your smartphone

Going mobile is one of the hot topics at the moment. Everyone has a smartphone with internet connection and a browser. Some prefer brand A against brand B, but that’s just a personal preference. It doesn’t really change a thing. You want to join the crowd and provide a mobile interface for your APEX Application? [...]

Oracle APEX 4.1 – Early Adopter

On Friday 06.05.2011 the APEX Development Team had a Surprise for us: they published the first Early Adopter Version of Oracle APEX 4.1 See the posts of Joel Kallman and David Peake.

Install Oracle XE 11g Beta on Windows XP

It sounded like an April 1st joke as Kris Rice announced the release of the long awaited Oracle XE 11g Beta Version. On OTN you can download either a Windows Installer or a Linux Installer (no mac version there).

OGH APEX Dag 2011

Just came back to vienna from the APEX Dag 2011 in Zeist/Holland, organized by the dutch Oracle User Group OGH. What can I say? It was a really good day with lots of interesting speeches and a very interested audience of 250 people !

Plugin: Location Map Image

A couple of weeks i introduced a Plugin which helps the user to enter a postal address in an APEX Form. Now i present a Plugin which lets you display an already stored address or location coordinates in a very simple and fast loading Google Map Image (png).

Enhance the APEX 4.0 Search Box

Oracle APEX 4.0 brought us a “Search Application” functionality which helps really a lot. Not only can you search there for strings in your application code, you also can enter an page-id and jump directly to the page. This is so good, that i thought i go a little further and improve it even more.



See all Posts