New month. New leader. All in all some twelve features changed positions. Where does your favorite APEX 5.2 feature rank?
Biggest Mover Up: REST Enabled SQL Support [ +4 ]
Biggest Mover Down: New Create App Wizard [ -2 ]
Previous Rankings: January 2018
Editor’s note: Each month, we’ll power rank the rumored enhancements ahead of Oracle APEX 5.2’s GA release. We’ll take the pulse of the APEX community, monitoring comments, talking to you all and gauging the interest, enthusiasm and expected impact of each of these enhancements. If you’re looking forward to a particular feature, make sure to tweet or blog about it. It just may affect the rankings!Power Rankings are based on a preponderance of social media. If you have an issue with these Oracle APEX 5.2 rankings, or have a question or comment for Monty Latiolais, send him an e-mail or contact him via Twitter.
Advisor ImprovementsLast month’s ranking: 16th [ No change ]
- New Accessibility checks to check your apps for common accessibility issues
List View RegionLast month’s ranking: 14th [ -1 ]
- The List View region from the deprecated mobile UI is support on desktop UI. See the known issues for current limitations.
Tree Region EnhancementsLast month’s ranking: 13th [ -1 ]
- Something that will be needed now that jsTree is removed.
- Added Default Icon attribute. Allow Icon Type to be empty (without forcing a-Icon).
- Improved Page Designer help text for all attributes.
- Support Dynamic Action Event Selection Change [Tree].
- Advanced Config option (nodeSelector) to support checkbox selection.
- Tree region now supports the apex.region API.
- Copy selection to clipboard
Additional JET ChartsLast month’s ranking: 12th [ -1 ]
- Gantt – based on Oracle JET Gantt
- Box Plot ( aka Box & Whisker )
- Sample Charts app – revised with new examples
Item Type ImprovementsLast month’s ranking: 15th [ +3 ]
- New ‘Text with Autocomplete’ item type using Oracle JET
Text message substitutionsLast month’s ranking: 11th [ No change ]
- For a given text message MY_MESSAGE, you can now use and v(‘APP_TEXT$MY_MESSAGE’) to retrieve the message text.
- Use APP_TEXT$MY_MESSAGE$XX to return the translation text for language XX (examples for XX are DE, FR, …)
- Same syntax is supported on the client via the apex.util.applyTemplate API
Oracle JET and jQuery Library UpgradesLast month’s ranking: 9th [ -1 ]
- JET 4.1.0
- jQuery 3.1.1
- jQuery UI 1.12.0
- jsTree 3rd party library is removed because it is incompatible with new versions. Tree regions will be converted to use the APEX treeView widget.
- FullCalendar 3.3.1
APEX Spotlight SearchLast month’s ranking: 10th [ +1 ]
- Provides quick navigation and unified search experience across APEX
- Activate by clicking search button from header, or using the keyboard shortcut Ctrl + ‘
- You can navigate to most screens within APEX builder
- Quickly jump across applications and pages
- Also works in Page Designer – can focus on page components
New AuthenticationLast month’s ranking: 8th [ No change ]
- OAuth2 authentication for APEX Applications and the APEX Development Environment
Developer Toolbar ImprovementsLast month’s ranking: 6th [ -1 ]
- New feature to see page performance timing. Menu Page Info > Show Page Timing. Show/Hide Layout Columns moved to Page Info menu.
Interactive Grid EnhancementsLast month’s ranking: 4th [ -1 ]
- Copy Down support and range selection; see new Actions > Selection sub menu (Fill and Clear)
- Copy to Clipboard (for row or cell range selections)
- Expose additional events to Dynamic Actions
Page Designer ImprovementsLast month’s ranking: 3rd [ -1 ]
- Property Editor
- Updated UI to improve usability
- Removed show common / show all, and collapse all / expand all functionality
- When a property has focus, the group becomes highlighted
- Improved ‘Go to group’ functionality
- Sticky Filters
- Filters can now be pinned so you can filter on something and click across to other components maintaining the filter
- Property Editor
New Create App WizardLast month’s ranking: 1st [ -2 ]
- New and improved user experience for creating applications
- Simpler wizards for creating pages
- Add common frameworks or “features” to applications such as activity reporting, access control, theme selection and more
- Customize user interface options such as Theme Style, application icon and page icons
- Leverage existing applications or UI defaults to default labels and form display types
REST Service ConsumptionLast month’s ranking: 2nd [ No change ]
- Create and maintain references to REST services (Web Source Modules) within Shared Components
- Leverage Oracle REST Data Services features like server-side filtering or pagination to fetch only required data from the REST service
- Use Simple HTTP for generic REST services, JSON or XML data feeds
- Have Application Express automatically discover and maintain the Data Profile; no manual SQL or PL/SQL coding is required for JSON or XML parsing
- Use Web Sources as the data source for Classic Reports, Interactive Reports, Oracle JET Charts or the CSS Calendar
- Use the APEX_EXEC PL/SQL package in order to invoke REST services from within custom PL/SQL code in Plug-Ins or page processes.
REST Enabled SQL SupportLast month’s ranking: 5th [ +4 ]
- Create and maintain references to REST Enabled SQL instances (Oracle REST Data Services) in Shared Components
- Use a REST Enabled SQL Service and therefore a remote Oracle database as the data source for Classic Reports, Interactive Reports, Oracle JET Charts or CSS Calendar
- Execute PL/SQL page processes on a remote Oracle database
- Use the APEX_EXEC PL/SQL package to execute SQL Queries or PL/SQL blocks on a remote database, from within your custom PL/SQL code.
“REST enabled SQL is something I’m really looking forward to. Clients will want to connect to all these disparate data repositories that were previously inaccessible or required cumbersome data conversions. Or worse, data syncing code. The code for synchronizing data is complex and complicated and if you need to sync both ways forget about it. The new REST Enabled SQL feature in APEX 5.2 promises a direct path to writing Classic and Interactive Reports that are based on remote data sources.”
— Jorge Rimblas at Insum Solutions