view counter

APEX Feed

Oracle Application Express (APEX) resources, news, and support articles.

APEX 5.0 (EA) Page Designer video's

APEX 5.0 early adopter is about to be released in the public.

Requesting a workspace is not working yet at the time of writing this post, but I expect it can be opened every moment now.

APEX 5.0 carries many new features, one of the biggest is the new Page Designer which should increase developer productivity even more. David Peake recorded some videos, here's the APEX 5.0 Page Designer Overview:

Increase post back size in Glassfish

I created a small mobile APEX app for my football team where they can upload pictures to the app.

APEX Validation: Check overlapping time periods

There is a easy way to check if a row with overlapping time periods exists inside you table.

All you need to do is to create the following APEX validation:
We assume that our table is called T_MACHINE with the columns m_id (PK), valid_from and valid_until Validation type: NOT Exist
SQL:


select 1 from T_MACHINE
WHERE (:P6_ID IS NOT NULL AND M_ID != :P6_ID OR :P6_ID IS NULL)
AND (VALID_FROM <= TO_DATE(:P6_UNTIL,'DD.MM.YYYY')) and (TO_DATE(:P6_FROM,'DD.MM.YYYY') <= VALID_UNTIL)

Scroll to the top of your page/report

In case you use partial page refresh inside your reports you may have encountered an issue that you always stay on the bottom of the page even after the refresh of the report.  One of my customer marked this as a bug and meant that after the refresh the display position should be at the beginning of the report.

Seems complicated but worked out to be really easy:
Add a dynamic action: After refresh of your report execute this javascript statement

/* Scroll to Top */
$("html, body").animate({ scrollTop: 0 }, 0);

APEX Vortrag und APEX Stammtisch

Am 05.02.2014 (Rhein-Main, Neu-Isenburg) halte ich einen APEX Vortrag zum Thema Pivotreports.
Details findet Ihr hier: http://www.doag.org/termine/termine.php?tid=473736

Außerdem plant die Community nun schon seit einiger Zeit an einem APEX Stammtisch in Frankfurt.
Wer Interesse hat kann sich hier anmelden: http://doodle.com/b9uqef2338itkgkv
Mit etwas Glück könnte der Termin im Anschluss des DOAG Treffens stattfinden. :D

Developing Mobile Web Applications with Oracle Application Express 4.2

If you’re interested in developing Mobile Web Apps on the Oracle Database – and if you’re following my Blog, chances are that you are – then here’s a great opportunity to get up to speed on the latest trends and learn how you can quickly and easily develop your own mobile web apps and extend your existing APEX apps for mobile use: attend my upcoming free ODTUG Webinar on February 20th:

APEX Training 2014 - Best Practices

Our next training will be held in Bensheim on 26th of May 2014. You can find the details here.

Die Erfolgreiche Trainingserie geht auch in diesem Jahr weiter. Dietmar Aust und ich organisieren ein weiteres Best Practice Training am 26.05.2014 in Bensheim. Diesmal findet das Training auf der Basis von APEX 4.2 statt. Nutzen Sie die Möglichkeit von Experten zu lernen und melden Sie sich an.

Barcode Report

This example seems still to be interesting to some people in the community. The number of requests and questions I am getting regarding it forced me to update it. Now the rendering is using an application process instead of a public procedure - using public procedures in XE is somewhat tricky.

view counter