Key Features in Oracle APEX

 


In this session we are going to discuss:
  • Key features in oracle apex latest versions
  • How to use maps in our applications 
  • Importance of up-gradation to the latest version

Version 19.1

  • The built-in support for REST Enabled SQL and Web Sources has been extended to Form regions, allowing read and write access to remote data sources.
  • Form Region Type
  • The new Form region type significantly improves and streamlines how data is retrieved and processed for page items.
  • There are now two additional styles for the tree-based Navigation Menu for Universal Theme
  • There is a new Inline Popup region template for Universal Theme
  • Improved responsive behavior for breadcrumbs and several other UI components in Universal Theme
  • A number of new declarative attributes have been added to Interactive Grids such as Select First Row and new Toolbar Controls.
  • New dynamic actions for opening and closing regions have been added.
  • Authentication to the App Builder can now be configured to use Social Login.
  • Save Session State just in memory
  • Improved translation editing

Version 19.2

  1. Faceted Search
  2. Introducing Faceted Search, a new component that enables you to quickly search and filter your data like never before. Empower your users to see data in new ways, and discover new insights, effortlessly, with just a few clicks.
  3. All New Team Development
  4. Team Development has been completely reimagined to provide a simple and easy way for your team to collaborate together. Whether it's an enhancement request, a new feature, or a bug – everything is now tracked as an Issue that can easily be assigned, labeled, and managed. You can even receive notifications and see a full timeline of everything that's happening from a single page.
  5. New and Improved Item Types
  6. From a completely reimagined Popup LOV component to an all-new UI for the Switch item, get more out-of-the-box with these new and improved item types in this release.

Version 20.1

  1. APEX + Redwood
  2. The user interface of APEX and the App Builder has been refreshed to align with Redwood, Oracle's new user experience design system. The new design and color scheme extend across the full developer experience and provides refreshing new visuals. The appearance of APEX can now automatically switch between the dark and light appearance modes based on your OS or platform setting, enabling APEX to seamlessly integrate with your workflow.
  3. Faceted Search Enhancements
  4. Faceted Search has been enhanced to allow for cascading list of values, conditional facets, and compact count display, among other enhancements.
  5. Friendly URLs
  6. The URL syntax for APEX apps has been simplified to allow for friendlier URLs at runtime. The new syntax provides a Search Engine Optimization (SEO)-friendly URL structure which is far easier to understand and provides immediate context as to where you are within an app. The URL no longer features application or page numbers, and instead, uses the workspace path prefix, application and page aliases, and standard web parameter syntax for its URL structure.
  7. There have been numerous improvements in application lifecycle management including one-click app deployments, automated backups, zip exports, and more. These features make it easy to deploy APEX apps and integrate it into your existing workflow.
  8. Native PDF Printing
  9. You can now print PDF files directly from Interactive Grids. This feature produces a PDF file that includes formatting options such as highlighting, column grouping, and column breaks.
  10. Mega Menus
  11. Universal Theme now includes Mega Menus for your application's navigation. Mega Menus render the navigation menu as a collapsible floating panel that displays all navigation items at once. It is especially useful for displaying the various aspects of your application and enables direct access to sections of your app.
  12. Other Features
  13. Users will now be alerted shortly before their APEX session is about to expire and will have the opportunity to extend it.
  14. There have been a number of improvements and bug fixes within Universal Theme for right-to-left languages.
  15. Filtering of data in an Interactive Grid is now supported through URL parameters as well as the new APEX_IG API.
  16. The version of the Oracle JavaScript Extension Toolkit (JET) library has been upgraded to version 8.0.

Version 20.2

  1.   Cards Region
  2. The new Cards Region is a lightweight report region, declaratively supporting customizations of layout, appearance, icon, badge, media, and actions. Use cards to embed and share media sourced from the BLOB column, URL, or video in iFrame. Cards are useful for presenting a variety of information in small blocks. As Cards usually provide entry to more detailed information, you can include a number of actions as buttons or links declaratively.
  3. Automations
  4. Automations are a sequential set of PL/SQL actions, triggered by query results. They are used to monitor data and then perform the appropriate action (examples are auto-approving specific requests and sending email alerts). Automation can be triggered on Schedule or on Demand, by invoking the APEX_AUTOMATION package. Query results can be derived from Table or View, SQL Query, or a PL/SQL function returning a SQL Query. Local Database or REST Enabled SQL. REST Data Source (aka Web Source Modules).
  5. Faceted Search Enhancements
  6. Faceted Search has been enhanced to generating bar or pie charts of facet value counts, grouping checkbox facets for Boolean columns, supporting comparing the user-entered value with the facet column in Input Field facet type, and perform optimization for distinct value facets.
  7. Report Printing
  8. Built-in PDF printing is supported in Interactive Reports, Interactive Grids, and Classic Reports and in Chinese, Japanese and Korean languages. You can attach any download formats in Interactive Report - Send Email. Enhanced integration with BI publisher. Use new APEX_REGION.EXPORT_DATA and APEX_DATA_EXPORT APIs to programmatically generate PDF, CSV, Excel, HTML, JSON and XML files.

Version 21.1

  1.    Maps Region
  2. Displaying spatial data within your APEX apps has never been easier. The all-new native Map component allows you to add powerfully, feature-rich, and interactive maps to your APEX apps within minutes. They are powered by Oracle eLocation Service so it is ready to use, no API Key required!
  3. Faceted Search Enhancements
  4. Faceted search now supports Maps and Calendar region types, and provides additional end-user flexibility for showing or hiding facets, enabling you to easily hide advanced or rarely used facets that can be made available on demand.
  5. New Date Picker Item Type
  6. The Date Picker item has been completely revamped and supports additional display modes, time selection, dynamic minimum, and maximum date ranges, and several user experiences and accessibility improvements.
  7. Security Improvements
  8. We have added various security improvements such as an attribute for Application items that allow users to escape characters, a default Referrer-Policy HTTP header, and an increase to the maximum session idle timeout.
  9. Reporting Improvements
  10. This release also features improvements to Classic and Interactive reports, including support for Lazy Loading, complex text layout languages when exporting to PDF, and variable height rows in Interactive Grids.
  11. Other Features
  12. You can now define Client-Side Conditions, Server-Side Conditions, Authorizations, and Build Options for Actions of Dynamic Actions.
  13. The Number Field page item type now does automatic formatting according to its format mask and client-side validation.
  14. The Color Picker page item type has been updated including new functionality for different display modes, color presets, contrast checking, and multiple value return formats.
  15. The client-side validation messaging is more consistent with server validation messaging, and no longer displays the error pop-up.
  16. There's now GeoJSON and SDO_GEOMETRY support in the APEX_JSON and APEX_EXEC packages.

Key features in Later releases

  1. New Smart Search and Filters Component
  2. Data Generator
  3. Additional Oracle JET-based Components
  4. Expanded Capabilities in APEX Service Cloud Console
  5. REST Service Catalog
  6. Integration with developer lifecycle services
  7. Improved printing and PDF export capabilities
  8. Runtime Application Customizations
  9. Analytics
  10. Machine Learning
  11. Process Modeling
  12. Extended Support for MySQL


Comments