What's New in Oracle APEX 19.2

Faceted Search

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.

  • SQL Driven

    All of the filtering and computations happen directly in the database, closest to the data.

  • Auto Discovery

    Facets are automatically created based on data patterns from your tables.

  • Count Computation

    Facet result counts are dynamic and computed based on current filter settings.

  • Multiple Facets

    There are a variety of facet types such as checkboxes, radio groups, ranges, and more.

screenshot

All New Team Development

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.

  • Streamlined User Experience

    Team Development now has a far simpler user experience that provides all relevant information about a given issue in a single timeline view.

  • Issues

    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.

  • Labels, Label Groups, and Templates

    You can define custom labels, label groups, and templates that make it easy to create, manage, and close issues.

  • Notifications

    You can receive email notifications for issues you are subscribed to so you don't miss out on anything.

  • Attachments

    Easily upload attachments directly from the text editor as you create Issues or add comments.

screenshot

New and Improved Item Types

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.

  • Popup LOV

    Completely reimagined Popup LOV that now supports multiple display columns, search-as-you-type, improved multiple value selection, and an all-new simplified user interface.

  • Markdown Editor

    Empower your users to be more expressive by accepting Markdown input in your applications using the new Markdown Editor. Markdown is the industry standard shorthand for easily applying formatting to text without the need to master HTML.

  • Star Rating

    Give your applications a 5-Star rating with this all-new Star Rating item.

  • On / Off Switch

    The Switch Item has been updated to display as an On / Off toggle button inspired from common mobile design patterns.

Screenshot of new item types

Expanded Shared LOVs

There are numerous enhancements to Shared List of Values (LOV) including support for additional data sources, declarative column mappings, and multiple display column.

  • Support for Additional Data Sources

    List of Values are more flexible than ever before and can be based on data from either local tables, or REST Enabled SQL and Web Source Modules.

  • Declarative Column Mappings

    You can now easily select display and return columns, as well as the default sort order, icon, and group columns.

  • Multi Column Support

    You can define multiple display columns for the LOV, with additional metadata specifying if the column is displayed, searchable, or requires any format mask.

Builder Improvements

There have been numerous changes and user experience enhancements to the Oracle APEX App Builder to make it even more productive.

  • Code Editor in SQL Workshop

    SQL Commands and Quick SQL have been updated to provide syntax highlighting and more.

  • SQL Workshop Improvements

    Be more productive with SQL Workshop with new functionality to display Sample Queries for a given table, easier REST enablement, and the ability to jump into the Create App wizard.

  • APEX Global Search Improvements

    APEX Search now has a much larger index allowing you to navigate directly to more places. You can also perform an application-scoped search simply by entering the application number followed by colon to search within that application (ex. 100:templates to jump to Templates).

  • More Powerful Multi-Edit in Page Designer

    You can now edit Template Options, code blocks, text areas, and check box properties for multiple components at once.

  • Data Dictionary Cache

    Statistics and data analysis of your tables are used to create a Data Dictionary Cache which are used when creating new applications or pages. This cache can be managed from Workspace Administration.

Universal Theme

Universal Theme has been refreshed with UI refinements, accessibility improvements, new template options, and deeper control via Theme Roller to help your applications look better than ever.

  • Dark Mode

    Universal Theme now has a brand new Theme Style that enables you to add Dark Mode to your applications. Simply select the "Vita - Dark" Theme Style and you're set to go!

  • Fully Collapsible Navigation Menu

    The side Navigation Menu can now be fully collapsed via template options.

  • New Login Page Styles

    You can now choose between new layouts and backgrounds for your app's login page.

  • New Content Row Template

    There is a new Classic Report template that makes it easy to display formatted content with selection, actions, and more.

  • Logo Editor in Theme Roller

    You can easily upload or define your app's logo using Theme Roller.

screenshot

Additional Features

Below are a number of additional features you should familiarize yourself with.

  • Developer Toolbar

    Developer Toolbar allows setting the Default Debug Level and remembers the debug level when run again from the App Builder.

  • Search via REST

    Interactive Report, Interactive Grid, and Popup LOV searches can be passed to a REST service. Enable the Use for Row Search switch for a Web Source Module parameter in order to use this feature.

  • Data Load into Existing Tables

    The data upload functionality in SQL Workshop has been extended to allow uploading native Excel, CSV, XML, and JSON documents into existing tables.

  • Updates to Data Loading and Parser

    SQL Workshop Data Loading and the APEX_DATA_PARSER package support up to 20 CLOB columns.

  • Oracle Text Indexes Support

    If an Oracle Text Index Column is chosen, Interactive Report and Popup LOV row searches will benefit from advanced searching capabilities such as fuzzy or linguistic search. Note: For Popup LOV, the Oracle Text Index Column is chosen in the Shared LOV definition.

  • Library Updates

    Several libraries have been updated to newer releases including Oracle JET, jQuery, FullCalendar, CKEditor, CodeMirror and more!

Learn more about Oracle APEX 19.2

Documentation