(Unconfirmed) New Features APEX 5.1

-
by @APEXORADEV


Following the news feeds on the internet, tagged #orclapex, a series of slides presented at a UKOUG event came along that I think are worth to get summarized in a blog post and shared with the community. It's a list of (unconfirmed) new features we could find in APEX release 5.1.

The list looks impressive. The APEX Development Team once again would prove, that development of APEX is much driven by developer/community feedback and customer demands.

·         Interactive Grid
o   Modern, rich & interactive multi-row editing
o   Used for Master > Detail(s), Master > Detail > Detail
o   Great for existing Forms customers, who are used to having rich Master > Detail blocks
o   Interactive Report style end-user customization, but better!
o   Mid-term goal to replace Interactive Reports, Tabular Forms and Websheet Data Grids
o   Fast, Responsive, JSON-based, lightweight AJAX communications
o   Using jQuery UI Widget Factory
o   Infinite scrolling with fixed headers and columns
o   RTL support
o   Accessible, with outstanding keyboard support
o   Expose all existing Item types for use in Grid Columns
o   Plug-in infrastructure enhancements to allow item plug-ins that can be used in this context
o   Declarative support for all APEX server processing; validations, processes, computations
o   Allow use of custom PL/SQL API’s instead of native DML processes, if necessary
o   Declarative support for Cascading LOV’s and Dynamic Actions
·         New Charts
o   New charting engine build by Oracle
o   HTML5 only
o   Responsive and accessible
o   Migration facility for existing charts
o   Same chart types as 5.0 + new types (like Bubble, Funnel, …)
o   Advanced customization available through documented JavaScript API’s
·         Page Designer Enhancements
o   2-column mode
o   Component View integrated into Page Designer
o   Create Component prompt for key information
o   Property Editor multi-tab mode
o   Property Editor search capability
o   Style and contrast enhancements
·         Greatly simplified Wizards
o   Fewer steps, more defaults
o   Attributes no longer exposed in wizards can easily be edited in Page Designer post-creation
o   Consistency across component types


If you miss a feature rich, interactive, drag-n-drop enabled, Excel-like data analyzing component in this list, no worries: you still can choose to integrate the APEX SmartPivot plug-in to greatly enhance your application, even when upgrading to APEX 5.1.
APEX SmartPivot Plugin

Comments

  1. KarenOctober 16, 2015 at 5:34 PM

    Thanks Christian - great to hear, good to know for planning upcoming projects and migrations.

    ReplyDelete
    Replies
    1. Christian Rokitta ♠October 19, 2015 at 10:00 AM

      Hi Karen,

      Keep in mind: this information is UNCONFIRMED!

      Cheers,
      Christian

      Delete
    2. UnknownMarch 12, 2016 at 10:59 PM

      it is very good news about apex 5

      Delete

Post a Comment

Popular posts from this blog

Remember Me - APEX Autologin

-
Image
I promised to publish about this subject to one of the attendees during my presentation at KScope 12 in San Antonio. I used this functionality in my demo application ( FifApex ) and it seems there is interest in how to do this. Most of the public websites like Facebook, LinkedIn, Twitter, Amazon or OTN do have it: an option to stay logged in, even if you closed the browser, so you do not have to authenticate each time you visit the site again. I’m pretty used to it and would be surprised if a website didn’t offer this convenient feature. OK, it’s not entirely secure, but, as I said, very convenient. I’m working on a “consumer” site/application, I’m building it with APEX and I want to offer this “remember me” option too. I knew an APEX based website that does offer this feature ( www.plsqlchallenge.com ) and I had a chat with the developer that implemented it’s login mechanism, Paul Broughton from Apex Evangelists . So, here my thanks to him for the original inspiration.   Oracle
Read more

Tabular Forms on Complex Views - using INSTEAD OF Triggers

-
Image
Creating tabular forms in Apex is relative straight forward. One gets fully generated, instant insert/update/delete functionality. Unfortunately (for the form developer), tables are usually part of a more or less complex data model, which is optimized for data storage, rather then for form-layout. Well, Apex offers some possibilities to the developer to enable tabular forms beyond 1:1 table based. Collections One alternative is to create your tabular form using the Apex Collection API. There is a good article on Martin Giffy D'Souza’s blog describing this technique. This collection-approach basically pre-fetches data into a (PL/SQL) collection from a query/cursor. The “collected” data will be displayed in the form. An on-submit page process will store the data submitted from the form into the collection. After this you can perform some validation before submitting the data to table(s) in an on-submit page process. Database Views Well, I favor an approach that keeps the
Read more

"Who are you?" – client device Categorizr for APEX

-
Image
This article describes a solution to determine the client device category (i.e. desktop, browser or tablet) your APEX application is accessed from. Until recently, building a web application with Oracle Application Express usually meant to build a desktop browser application. But if you look at the growing number of mobile devices, this will change very soon, if not already has for some of you. Being able to develop applications, that can be accessed by tablets or smart phones offers lots of new possibilities. But it also comes with some challenges. Mobile devices are different. Interaction by touch screen, screen size and (non-) support of certain common web functionality (flash, for example), just to mention a few. Oracles announcement to integrate the jQuery mobile framework into APEX 4.2 will help us to deal with many of the challenges, developing for multiple devices will bring. Until now, one of the biggest challenges is, to determine the actual client your application
Read more