Friday, October 16, 2015

(Unconfirmed) New Features APEX 5.1


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