It’s that time of year again: Conference Season! There’s a few conferences that fall in the 1st few months of the year that I try to present at each year, and this year is no different. Here’s where I’ll be presenting at over the next few months:
One of the MANY nice things that is coming in APEX 5.0 is the native integration of the jQuery based FullCalendar, known in the APEX 5.0 Builder as the CSS Calendar. While the native integration will be nice, you shouldn't have to wait for APEX 5.0 for this functionality.
Enter the Enkitec FullCalendar plugin. We integrated FullCalendar into our website quite some time ago to enable us to display our Education and Conference calendars. Recently I've taken the basis for that code and created a plug-in that works with APEX 4.1 and 4.2.
One of the first things I checked in APEX 5.0 EA was the region positioning of the sub regions. I was positively surprised to see that I can now position the regions next to each other as well. In earlier versions the only option was underneath. Having this possibility it will be much easier to create complex forms where you need to take care of positioning multiple items in more than one column. At the moment this is doable but somewhat tricky.
This is definitely the best APEX version ever. I just tested it and it took less than a couple of minutes to get used to it. You know how hard it is to accept major changes. This time it was easy. The changes made in the builder will for sure increase the productivity although this was never a weakness of APEX. There are of course some things missing (or I just couldn't find them) like how to create a simple form. Some features are still not implemented like workspace user management. Some things remained the same like a wizards for page creation.
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:
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
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)