Release History

View Release Notes for Plug-in

The Plug-ins Pro Team 14-APR-2025
Enhanced Grid Pro
Bug fixes:
- fixed a bug where saving caused raised an error
The Plug-ins Pro Team 09-APR-2025
Enhanced Grid Pro
New features
- Validation functions can now process all submitted rows. This allows for validations that require checking multiple rows at once. You can specify if a validation function is "row-by-row" or "all rows".
- Related to this, you can now enable "process all rows". This will also send unchanged rows to the server (validation + save).
- Autofill/drag-down support for numeric arithmetic and geometric series.
- Option "outsideClickDeselects" where clicking outside the grid will lose the selection.
- Option to automatically select a value from an select list if the cascading parent was changed and only one value is returned from the query ("autoselectOnlyValueOnCascade")
- Experimental support to freeze columns (sticky position on horizontal scrolling)
Improvements
- Validation JS function now also receives the row data as an object.
- Saved reports now also store the static ID and will prefer the static ID over the internal region ID.
- The getData function has an optional "asObject" parameter, which returns a row as an object (with the column name) instead of an array.
- Option to allow pasting via the context-menu ("contextMenuPaste"). It is not enabled by default because it requires user permission to read the context menu.
Bug Fixes
- Fixed issue with duplicate row where, after a save, the original row was refreshed and displayed as the duplicated row.
- Clob columns are not sortable, as this caused issues
- Re-enabled column sorted for cascading select list children
- Fixed a bug where client-side validations fired on aggregate rows.
Also refer to the updated docs and sample app.
The Plug-ins Pro Team 04-MAR-2025
Gantt Chart Pro
Gantt Chart Pro v25.1
- Added new feature "Drag and Drop" on Hierarchy
- Added new event "Save" (triggers after saving the data into the database)
- Improved Tree sorting
- BUG FIX: Custom JS callback had a wrong first parameter, “self”
- Documentation update
Upgrade description
Upgrade package "UC_GANTT" and the plugin "United Codes Gantt Chart Pro".

File Versions
* 25.1.0.0 PL/SQL
* 25.1.0.0 JavaScript
* 25.1.0.0 Plugin
The Plug-ins Pro Team 11-FEB-2025
Enhanced Grid Pro
- Fixed Issue with modal links in APEX 24.2
- Fixed duplicate row if bottom row is fixed
- Fixed being able to paste on disabled columns
The Plug-ins Pro Team 28-JAN-2025
UC Redirect
Bug fixes:
- Fixed an issue when special characters where passed
The Plug-ins Pro Team 28-JAN-2025
SearchBox Pro
Bug fixes:
- Fixed an issue with APEX 24.2
The Plug-ins Pro Team 22-JAN-2025
Enhanced Grid Pro
Various stability improvements and bug fixes:
- Pasting null values for select lists now overwrites existing values
- Fixed case where select would not close upon clicking outside of it
- Aggregation rows (SUM) are now fixed on grids with a set height
- Fix changes getting discarded on scrolling
- Fixed duplicate sum recalculation causing wrong results
- Checkbox clear all header now works when false is set to “null”
- Plain text fields not work correctly with date format masks
- Fix client side validations firing on aggregations row
The Plug-ins Pro Team 13-JAN-2025
PDF Region Pro
- Security updates
The Plug-ins Pro Team 08-JAN-2025
UC Range Slider
- Fixed issue regarding date ranges with week numbers on year changes (e.g. 30th Dec would result in 01/2024 instead of 01/2025)
- Upgraded dependency
  - moment.js to 2.29.4
The Plug-ins Pro Team 21-NOV-2024
Gantt Chart Pro
Gantt Chart Pro v24.3
New feature: Time Buckets
Use Time Buckets to declaratively display sprints , holidays, or any other time bucket tailored to your needs.

Bug Fixes
- Fixed hierarchy levels
- Properly display the no data found message.
The Plug-ins Pro Team 08-NOV-2024
UC Advanced Password
UC Advanced Password v24.1
Improvements:
- Success and error state respects the success and error color of the current theme. Previous colors were also not accessibility-compliant (thanks Louis).
Fixes:
- Apply required to HTML input element
The Plug-ins Pro Team 05-NOV-2024
SearchBox Pro
SearchBox Pro v24.2
Features:
- Option to redirect to search results page when the user presses enter inside the search input item.
- Added tiny animation when the spotlight search opens and closes.
Improvements
- Ignore empty lines in the search configuration attribute field
- Respects stretch item option
- Respects appearance → css classes
The Plug-ins Pro Team 10-SEP-2024

SearchBox Pro
SearchBox Pro v24.1

We're thrilled to announce the initial release of SearchBox Pro, an APEX plug-in that adds a powerful global search to your applications.

Features

- Global search bar that integrates seamlessly into your app header
- Reuses existing APEX search configurations for quick setup
- Responsive design adapts to screen size (inline search bar on desktop, overlay spotlight mode on mobile)
- Customizable search bar and results UI via templates and CSS
- Keyboard shortcut (Cmd/Ctrl+K) to open search from anywhere
- Works with standard SQL queries and advanced options like Oracle Text indexes
- Supports reference to existing lists and ubiquitous search in newer database versions

Resources

- Plug-in documentation
- Demo application
The Plug-ins Pro Team 30-AUG-2024
Enhanced Grid Pro
Enhanced Grid Pro v24.1.1 is now available for download.
Overview
Added some features and fixed some bugs.
New features
Show/hide columns using UI dialog
Use Saved reports - in a same way as they're used with IR/IG
- Primary/Alternative
- Private
Use HTML Expression field, same as it's possible with IR/IG (to style cells, etc.)
- Used with all column types except for "Select list" and "Checkbox".
Use aggregations on numeric columns
- SUM
- AVG
- MIN
- MAX
- COUNT
Improvements
/
Bug Fixes
Fixed an issue with plug-in not working in APEX 24.1
- Reason was: With APEX 24.1, unlimited attributes for plug-ins were introduced.
"Sum" now rounded to two decimal places
- Before, too many decimal places were displayed to user.
Grid plug-in can now handle big numbers normally
The Plug-ins Pro Team 08-JUL-2024
PDF Region Pro
- New and improved way of handling the fetching of the PDF document, dramatically improving performance.
- Added support for downloading library files from a self-hosted webserver.
- Updated to latest version of the Apryse PDF Viewer.
- Security improvements.
The Plug-ins Pro Team 16-MAY-2024
Enhanced Grid Pro
Enhanced Grid Pro v24.1 is now available for download. This version is compatible with APEX 19.2 and higher.
Overview
Added some features and fixed some bugs.
Users can now copy values from Excel (or any other external source) to Select list columns (and developers can choose whether return or display values are pasted).
New features
JavaScript API:
- New function "getFiltersUsed" - returns all filters currently used (as JavaScript array).
- New function "isColumnReadOnly" - checks if Grid's column is readOnly (disabled).
- New function "isCellReadOnly" - checks if Grid's cell (column at given row index) is readOnly (disabled).
"Show delete column" option
- There's now an option to include the "Delete" column as the last column in Grid. This simplifies row deletion for end users.
New column option: "Duplicate Copies Existing Value"
- It works the same way as in the Interactive Grid. When the end user chooses to duplicate a Grid row, values will be copied (or not) to the new row based on the setting.
Improvements
Select list columns now support Copy-Paste from Excel
- Developers can define whether end users will paste Display or Return values into a Select list column. Once values are pasted, Grid will go to the database and check whether the pasted values are valid or not.
- By default, a DISPLAY value is expected.
Numeric column - added culture support
- The application's language is now used to determine how to display numeric values (what to use as thousand and decimal separators)
Bug Fixes
Select list column
- When multi-select is used, Grid plug-in was not detecting changes in the case when multiple values were there already and one got removed, and another one was added.
Checkbox column
- Previously, Grid's Javascript API function "setValidationFunction" could not be used with checkbox columns. Now, you can.
"Total" counter not updated
- When rows in Grid got deleted or created, the "Total" counter (at the bottom of the Grid) was not updated.
The Plug-ins Pro Team 14-MAY-2024
FlowForms
- Camera/File input is now fully supported
- Better file upload handling
- Added prepending of published forms
- Added appending of published forms
- Fixed a bug where disabling a group would not always work
- Fixed a bug that caused the form not to be properly fetched, resulting in only small forms being supported
The Plug-ins Pro Team 10-APR-2024
Gantt Chart Pro
v24.2
With this version of Gantt Chart Pro, the minimum supported version of the Oracle APEX 22.1. For previous versions of APEX, please use Gantt Chart Pro v24.1.
- Re-design of the plug-in, "row-data" instead of the previously "task-data" parser
  list of new features:
  Task dependency
  Task, Resource, and Dependency Templates
  Theme changes
  Downtime
  Overtime
  Color (Weekend, Current time)
  Time buckets
  Custom scales and date formats (Date converter included)
  Custom validations (click, move, resize)
  Option to load additional modules (ex. oj-avatar)
Upgrade Instruction
Upgrade the "UC_GANTT" package and the plug-in "United Codes Gantt Chart Pro".
If the "sort" functionality was used, please move the function into the new function "sortData" in "option.methods".
```
/**
*     Example :
*      Previously
*/
function (pOptions) {
   
   //Invert resource sort
   pOptions.sort = 
       function (data) {
           return data.sort(function (a, b) {
               return a.resource < b.resource ? 1 : -1;
           })
       };       
   
   return pOptions;
}
/**
*     Example :
*      New from 24.2
*/
function (pOptions) {
   
   pOptions.methods = {   
       //Invert resource sort
       sortData : 
           function (data) {
               return data.sort(function (a, b) {
                   return a.resource < b.resource ? 1 : -1;
               })
       }  
       /*
       sortData : function (data) {
           //No sort
           return data;
       }
       */
   };
   return pOptions;
}
```
The Plug-ins Pro Team 05-MAR-2024

FlowForms
Initial release of Plug-ins Pro FlowForms!
The Plug-ins Pro Team 06-FEB-2024
Gantt Chart Pro
v24.1
- Automatic timezone support. (Getting Started > Advanced Settings > Automatic Timezone)
- Bug fix on Update Drag and Drop, exclude “:APEX$GANTT_RESOURCE_ID” in the update statement if needed
- Documentation improvements
The Plug-ins Pro Team 22-JAN-2024
Rich Text Editor Pro
Version 23.2.3
Release date: 2024-01-22
Froala
Changes
- The Froala framework has been upgraded to version 4.1.4. See the Froala changelog to learn about changes.
Page item
Bug fixes
- Fixed: emptying rich text document and submitting page results in setting the on-load CLOB value instead of using value resulting from page item attribute Source \ Used \ Only when current value in session state is null.
- Fixed: evaluating the plug-in attribute Initialization PL/SQL Code might raise an error when performing page validation or plug-in AJAX requests. The attribute is now evaluated only once when rendering the plug-in.
- Fixed: misleading upload error message when an image upload request is terminated by the network error (AJAX ready state 0).
Changes
- The on-load CLOB is no longer used to compute page item value on page load. The plug-in uses On-load CLOB only internally to support CLOB checksum validation and by supporting dynamic action plug-in Reset Value.
- The plug-in PL/SQL API UC_FROALA_RTE.clobGetHTML and UC_FROALA_RTE.clobDisplay no longer use on-load CLOB. Previously, it was used when the draft CLOB value was NULL.
- The PL/SQL procedure UC_FROALA_RTE.manageClearCache is no longer required to clear the plug-in session state using Oracle APEX URL syntax in Oracle APEX 22.2 onwards. For prior APEX releases, the procedure is mandatory to clear the plug-in session state using APEX URL syntax.
- The package UC_FROALA_RTE variables defined using attribute Initialization PL/SQL Code are now stored in the plug-in session state (APEX collection). They are not evaluated for validation, metadata, and AJAX plug-in interface procedures.
- The upload error handling is now improved and handles the most common mistakes when creating a custom upload handler.
- An image filename dragged and dropped from an end-user desktop is now available in the RESTful service upload handler.
UX & UI
Bug fixes
- Fixed: When refreshing the rich text editor, a spinner is hidden due to the rich text editor scrollbar and maximum height. Now, a spinner is permanently attached to the parent container, making it always visible to the end-user.
- Fixed: Navigating to an image using upload & update workflow dialogs does not always show an image to the end user.
- Fixed: The upload and update workflow doesn't show an inline APEX notification about the terminated upload.
Changes
- The upload summary dialogs are redesigned and present information about images in a tabular layout.
PL/SQL API
Bug fixes
- Fixed: The procedure UC_FROALA_RTE.manageClearCache doesn't clear page items that implement the plug-in when URL syntax is missing CR, RP, or RR in Oracle APEX URL syntax for clearing page items.
- Fixed: With the plug-in version 23.2, the function UC_FROALA_RTE.setValue stopped returning a given CLOB checksum as the function result.
Changes
- Functions and procedures accepting page items as an argument now perform a check if a given page item implements the plug-in. If not, the PL/SQL error is raised.
- Function and procedure UC_FROALA.setValue (Signature 2) raises an error when an invalid CLOB type is given.
- Function UC_FROALA_RTE.getValue always returns the current value of the draft CLOB - previously, it could return on-load CLOB if draft CLOB was NULL.
- Procedure UC_FROALA_RTE.clear accepts a new optional argument p_set_session_state with a default value of false. When p_set_session_state is set to true, a page item APEX session state is set to NULL. When set to false, only the plug-in session state is purged (APEX collection).
- Procedure UC_FROALA_RTE.clobDisplay accepts a new optional argument p_include_css with default value true. When set to false, the plug-in doesn't add the plug-in CSS files styling rich text documents using default rich text editor CSS rules.
- Function UC_FROALA_RTE.setValue (Signature 1) sets only draft CLOB in the plug-in session state. Previously, it was updating on-load CLOB as well.
Supporting dynamic action plug-in
Bug fixes
- Fixed: Help text and help text examples are missing for the plug-in attribute JavaScript returning JSON.
- Fixed: JavaScript errors caused by the developer's invalid input are only shown in a browser console. Now, errors are shown as APEX inline notifications.
New features
- Action Update CLOB supports optional JavaScript callbacks (done and fail), which are definable using the attribute JavaScript Initialization Code.
Documentation
- Fixed: Function UC_FROALA_RTE.setValue parameter p_set_session_state was incorrectly described since the plug-in release 23.2. Since the plug-in version 23.2, the function updates a page item session state to the actual CLOB value instead of the given CLOB checksum.
- Fixed: Procedure UC_FROALA_RTE.clobDisplay (Signature 1) lists parameter p_item_name instead of p_clob.
- Fixed: The supporting dynamic action plug-in is missing the action Allow Image Resizing.
- Fixed: The plug-in session state is missing information about collection column c003 used by the supporting process plug-in
- The package UC_FROALA_SETTINGS variables are now described in Item Plug-in \ Database objects \ Package UC_FROALA_SETTINGS
- The package UC_FROALA_RTE variables available for the plug-in attribute Initialization PL/SQL Code are moved from Item Plug-in \ Custom Attributes \ Initialization PL/SQL Code to Item Plug-in \ Database objects \ Package UC_FROALA_RTE
- The plug-in session state has been updated due to mandatory changes for CLOB support across APEX versions.
- The plug-in documentation mentions new integrations with the Froala third-party plug-ins, such as WProofReader Web Spell Check, Wiris Math Type, CODOX.io, and Track changes.
- The supporting dynamic action plug-in Change Settings includes information about alternative customization using the page item attribute JavaScript Initialization Code.
RESTful service
Improvements
- Upload handler raising error 555 User Defined Error is now recognized and handled by the plug-in by showing a proper error message.
- Upload handler does not need to include data-image-id in the result JSON.
Database objects
Changes
- Access token type UC_RTE_ACCESS_TOKEN exposes static and member functions
- Package UC_FROALA_SAMPLE_REST doesn't reference UC_FROALA_RTE functions decoding access token.
- Package UC_FROALA_RTE relies on static access token types and member functions to handle access tokens.
- A new package variable UC_FROALA_RTE.g_disable_rest_enabled_check can now be used in the plug-in attribute Initialization PL/SQL Code as an alternative to defining UC_FROALA_SETTINGS.g_disable_rest_enabled_check on package level.
Debugging
Changes
- Debug messages now include information about the APEX version and if it supports CLOB values in the APEX session state.
- Debug messages now include the package name used to render the plug-in instance.
- Debug messages now include whether the plug-in instance is CLOB enabled (Shared components \ Plug-ins \ Item plug-in \ Standard Attributes).
- Debug messages now include information on whether a page item implementing the plug-in is CLOB enabled (Page Designer \ Item \ Session State \ Data Type).
- All plug-in errors and warnings are prefixed with RTE Error and RTE Warning to distinguish them from other non-plug-in PL/SQL warnings and errors.
Sample application
Bug fixes
- Fixed: The breadcrumb button opening the context menu does nothing when the United Codes Context Menu plug-in is not installed. Now, when the plug-in is not installed, the modal page with information about the plug-in is shown as initially intended.
Changes
- Internal development pages not shown in the sample application are now removed from the sample application.
Known Issues
Copied and pasted images are added with the width set to 0px
The issue occurs when a developer uses the Froala option imageDefaultWidth set to 0 in the plug-in attribute JavaScript Initialization Code. The problem is confirmed by the Froala framework bug. To add an image with the original size (without the width property set), a developer has to set the imageDefaultWidth to 100% and the imageResizeWithPercent set to true. See an example code below:
function( pOptions ) {
pOptions.imageDefaultWidth = ‘100%’;
pOptions.imageResizeWithPercent = true;
return pOptions;
}
The Plug-ins Pro Team 11-DEC-2023

UC Parallax
Small fix to sample application.
Added to Plug-ins Pro Community Plug-ins
The Plug-ins Pro Team 11-DEC-2023

UC IR Column Grouping
Added to Plug-ins Pro Community Plug-ins
The Plug-ins Pro Team 11-DEC-2023

UC List Extension
Added to Plug-ins Pro Community Plug-ins
The Plug-ins Pro Team 11-DEC-2023

UC Date Range Picker
Added to Plug-ins Pro Community Plug-ins
The Plug-ins Pro Team 11-DEC-2023

UC Context Menu
Initial release as a Plug-ins Pro Community Plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Nested Reports
Added to Plug-ins Pro Community Plug-ins
The Plug-ins Pro Team 11-DEC-2023

UC Trigger Event(s)
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Tooltip
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Timing Actions
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Text Snippet Expand
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Static Content
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Splitter
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Spinner Actions
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Redirect
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Range Slider
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Popup LOV Actions
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC PL/SQL Dynamic Content
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Notifications
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Message Actions
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Interactive Grid - Process Rows
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Interactive Grid - Add Button
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Image Slider
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Execute PL/SQL Code
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Drag and Drop
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Download File(s) - Process
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Download File(s) - Dynamic Action
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Date Picker Eraser
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Client-side Condition
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.
The Plug-ins Pro Team 11-DEC-2023

UC Advanced Password
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.

Release History

New features

Improvements

Bug Fixes

Gantt Chart Pro v25.1

Upgrade description

File Versions

Gantt Chart Pro v24.3

UC Advanced Password v24.1

SearchBox Pro v24.2

SearchBox Pro v24.1

Features

Resources

Overview

New features

Improvements

Bug Fixes

Overview

New features

Improvements

Bug Fixes

v24.2

Upgrade Instruction

Version 23.2.3

Froala

Changes

Page item

Bug fixes

Changes

UX & UI

Bug fixes

Changes

PL/SQL API

Bug fixes

Changes

Supporting dynamic action plug-in

Bug fixes

New features

Documentation

RESTful service

Improvements

Database objects

Changes

Debugging

Changes

Sample application

Bug fixes

Changes

Known Issues

Copied and pasted images are added with the width set to 0px