This preface contains:
The following are changes in Oracle Application Express End User's Guide for Oracle Application Express release 4.2.
The following features are new in this release:
Websheets
Toolbar Menu Enhancement
The existing toolbar menu options have been moved and new options have been added for reports. These changes are designed to make it easier, more productive, and more intuitive for users to navigate from within Websheets.
See "Using Websheets".
Link Directly to Data Grids
Provide users with the ability to utilize a link directly to edit a data grid or data grid row (form view) which can be exposed or emailed for easier access.
Interactive Reports
Interactive reports modernized
All interactive reports feature a modernized user interface to facilitate ease-of-use.
Date Columns can use Equal (=) Operator
Enables users to filter on a specific date using the equal (=) operator.
Data Upload
Provide Column Aliases
To avoid end users having to know table column names, developers can define aliases for columns to be uploaded. Table column names can be misleading and confusing for end users, especially for those columns where a lookup has been defined, for example, instead of requiring DEPTNO the user should upload Department Name.
Lookup Key Improvements
Instead of only allowing one column lookup and returning a numerical value, these improvements enable three columns to be specified to identify the lookup value which can be of any data type. This is required to uniquely identify a value where the lookup table has multiple part keys.
Transformation Rule Enhancement
For users uploading data with different character sets, you can now specify the character set used to create the file so that it can be updated correctly.
Ensure Concurrency
Developers can define a column for concurrency which is used to ensure that data being updated has not been changed since the end user began the upload process. This feature is important when end users are uploading records to a table that is regularly updated.
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 4.2 user interface enhancements.