This preface contains:
The following are changes in Oracle Application Express App Builder User’s Guide for Oracle Application Express release 5.1.
The following features are new in this release:
Interactive grid presents end users with a set of data in a searchable, customizable report. From a functional perspective, an interactive grid includes the customizations capabilities available in interactive reports plus the ability to rearrange the report interactively using the mouse. In an editable interactive grid, users can also add to, modify, and refresh the data set directly on the page.
Key features include:
Full Featured Grid - Includes powerful reporting capabilities, including fixed headers, frozen columns, scroll pagination, multiple filters, sorting, aggregates, and computations. Includes powerful reporting capabilities, including fixed headers, frozen columns, scroll pagination, multiple filters, sorting, aggregates, and computations.
Extensible and Customizable - Edit text, numerical data, and list of values. Interactive grids support all item types and item type plug-ins.
Master Detail - Create master-detail relationships that are any number of levels deep and across. Create master-detail relationships that are any number of levels deep and across.
Oracle JET Charts
See "Creating Charts."
In release 5.1, wizards have been streamlined and simplified.
Create Application Wizard - The Create Application Wizard for Desktop applications now supports the creation of interactive grid pages as reports, forms, and master detail. When creating an application from a spreadsheet, this wizard also supports interactive grids as either a single page or a report and form page.
Create Page Wizard - The Create Page Wizard features a more consistent, streamlined interface consisting of fewer steps. Master Detail forms now incorporate an interactive grid region on either a single page or on two pages.
Calendar in this release offers many improvements:
End Date Displayed Inclusive - In release 5.0, the CSS calendar considered the end date of an all-day event as exclusive (similar to the jQuery FullCalendar Plugin ). In release 5.1, the end date is inclusive like all other Oracle Application Express components.
Dynamic Actions Events - Enables developers to capture events within the calendar and define dynamic actions against these events.
Keyboard Support - When the calendar grid has focus, the arrow keys can be used to navigate within the calendar.
See "Creating Calendars."
File Browse page items can be configured to support multiple file uploads, and can be restricted by file types.
Component View Tab - To assist developers with the transition to Page Designer, Page Designer includes a Component View tab. Similar in appearance to Legacy Component View, the Page Designer Component View tab presents user interface elements and application logic by component type. However, when you click a component and the Property Editor highlights the corresponding attribute in the right pane.
Two Pane Mode - Page Designer now enables developers to view just two panes instead of three. Two Pane mode enables developers to focus on two panes at a time.
Drag and Drop Tab Reordering - Developers can now customize Page Designer by reordering tabs across panes.
Property Editor, Filter Properties Search - Search for a group or an attribute in the Property Editor by entering keyword in the Filter Properties field.
Property Editor Change Indicator - Changed attributes display with a blue marker until the page is saved.
Reload On Submit Page Attribute - Enables developers to specify when the page should be reloaded following a page submission.
Universal Theme and User Experience Enhancements
Font APEX - Font APEX is a new icon library designed specifically for Oracle Application Express and the Universal Theme. Font APEX includes over 1,000 icons. To learn more about Font APEX, install the Universal Theme Sample Application.
Live Template Options - Live Template Options enable developers to alter a component's template options without refreshing the page.
Theme Styles - Enabling users to select a theme style in a running application.
See "Deprecated Features" and "Desupported Features" in Oracle Application Express Release Notes.
The following are additional changes in the release:
All content has been updated to reflect new functionality.
Screen captures and graphics have been added and updated to reflect Oracle Application Express release 5.1 user interface enhancements.
A new organization in which legacy application components are grouped together. Legacy application components are components Oracle still supports but does not recommend using.
"Appendix E: Accessibility in Oracle Application Express" has been removed. Accessibility information can now be found in Oracle Application Express Accessibility Guide.