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_BuilderAbove you see an example of an Interactive Report everyone should know: this is the Application Builder listing all pages of an application.

The task at hand is to call (more...)

APEX Developer Addon for Firefox 43+ – now signed

Quick note: I finally managed to get the APEX Developer Addon signed by Mozilla and therefor working again in Firefox 43 upwards.

Please re-download and install, version of the Addon in Firefox is now 2.0.0.49. No changes for Chrome.

Apologies for the inconvenience and thanks for all those mails I got.

New Website for FOEX online

Last year was very eventful at FOEX, which kept me occupied and kept me from blogging. Thankfully I managed to attend a few conferences and stay in touch with the community through Twitter and Slack on apex.world.

FOEX is growing a lot and needed a new website design, so we had a brainstorming meeting and decided to again build it in APEX.

Last week we finally decided everything for the website was ready (more...)

APEX Instance debugging on command line

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.

When you download and unzip APEX 5 you’ll find a utilities directory which includes a debug directory:

The debug directory contains 4 SQL scripts:

  1. d0.sql
  2. d1.sql
  3. d2.sql
  4. ds.sql

Now lets take a look at what those scripts are doing:

d0.sql

With d0. (more...)

Differences between Oracle APEX 4.2 and 5.0

If you haven’t heard: APEX 5.0 is out !

And I finally got some time on my hands to do my usual “diff” between the new and previous version to point out all API and View changes.

To me this is a very valuable exercise to absorb all new information and to get to know all new Features of a version. Because everything I find in View and API changes, must also be reflected in (more...)

APEX Developers wanted!

Currently there are multiple positions open for APEX Developers locally in Vienna/Austria.

FOEX is looking for talented Oracle APEX and/or Ext JS Developers, which want to be part of our growing Startup currently serving customers in 13 countries worldwide. Check this link for more.

click-click IT Solutions is also looking for APEX Developers/Consultants. Check this link for details.

Since both companies share a wonderful office you can expect to have also the best possible colleagues (more...)

APEX Meetup Vienna/Austria

Hi everyone and happy “new” year!

This year’s resolution is to do even more APEX. Is this possible, you might ask?

Sure, for example on Feb 19 2015 at our next orclapex Vienna Meetup.

Hope to see you there. Patrick and Christian will provide us with the latest news of APEX 5 and tell us more about Early Adopter #3.

Don’t waste any more time: RSVP yes.

APEX Worst Practices – Survey

As preparation for my Presentation about Worst Practices in Oracle APEX I set up a survey using the Survey Builder Packaged Application.

Please help out and fill in the survey: https://apex.oracle.com/pls/apex/f?p=80076:Q::AAAW

There will be a follow up post with details on worst practices and survey results.

 

Thanks for your time,

Peter

orclapex Meetup group Vienna

For a long while now I’m having this idea to initiate an APEX group on some social network to bring APEX Fans together and have regular meetings in my hometown Vienna, Austria.

This idea in mind I met Dan McGhan at APEX World 2014 in Zeist, Netherlands. While talking about this and that we discovered that we both are fans of meetup.com which is a platform to organize meeting groups.

Of course we instantly (more...)

APEX 5.0 Early Adopter has arrived

Suddenly a big thunder rolled through the APEX community -> Version 5.0 has arrived in an early adopter version, as published on Joel Kallmans Blog (as usual on a friday, late night over here in europe).

Over the past 10-15 month we saw numerous presentations of what we can expect in APEX 5, and many of us had our own ideas.

As soon as I got word through twitter I applied for a workspace (more...)