v26.1.0 - fixes Interactive Grid fixed headers inside splitter panels and renames the plug-in, which requires a one-time migration when upgrading from v23.1 or older.
- Interactive Grid fixed headers now work inside a splitter panel. The header sticks to the top of the panel as the panel scrolls, instead of to the page.- Breaking — the internal name is now UNITEDCODES_SPLITTER (was US_SPLITTER). APEX matches plug-ins on internal name, so this version is not recognised as an update of the old one. See UPGRADE.md for the one-time migration; every upgrade after this one installs normally, and splitter positions saved with either Persist State option are unaffected.- The export file is now region_type_plugin_unitedcodes_splitter.sql (was region_type_plugin_us_splitter.sql). Only the name changed — update any script or pipeline that imports it by the old name.- Migration helpers included. migrate_splitter_export.sh (macOS, Linux) and migrate_splitter_export.ps1 (Windows) perform the rename in your application export, refuse to write if the references don't add up, and leave the original untouched.- Minimum supported versions are now Oracle APEX 24.2 and Oracle Database 19c.
v26.1.2 - Fixes a defect that silently reverted the Universal Theme size correction, and moves that correction into the plug-in so it can't happen again.
- BUG FIX: the sample application installed an outdated UC_GANTT package. Its supporting objects carried their own copy of the installation DDL, still holding the package body from 25.1.1. Installing the sample application therefore replaced a correct UC_GANTT with the older one — without any error — and the chart went back to rendering around 60% too large on Universal Theme 26.1. Affected anyone who installed or reinstalled the sample application on 26.1.0.0 or 26.1.1.0, whether or not ddl_uc_gcp_manual_install.sql had been run first.- The Universal Theme size correction now ships with the plug-in as css/uc_gantt_theme_scale.css, so importing the plug-in is enough. It no longer depends on the package being reinstalled and cannot be undone by an older package installed over it.- Licence packages refreshed in the sample application's supporting objects, which had been two years behind what the installation script ships.- Licenses must be re-activated on every major release — the package presents version 26.1 to the licence check. Obtain a new api key through the Plug-ins Pro portal and activate it as described in the installation docs.
v26.1.1 - Corrects the plug-in export itself, 26.1.0.0 shipped one produced on APEX 22.1, and a sample application with the wrong alias and compatibility mode.
- Plug-in export rebuilt on APEX 24.2. The 26.1.0.0 export was still produced on 22.1, so the stated 24.2 minimum did not match the version stamp APEX checks on import.- Help text corrected to state the 24.2 minimum and name the release to use on older APEX: 25.1.1 for 22.1–24.1, 24.1 for 19.2–21.2.- Sample application: fixed application alias, APP_NAME substitution string, and compatibility mode; updated the footer copyright year and Plug-ins Pro link.- Documentation links corrected throughout.
v26.1.0 — adds Oracle APEX 26.1 support, fixing two regressions that made the chart render incorrectly or not at all on that release.
Fixed
- Chart no longer blanks with "Invalid data" when a task's end date precedes its start — the new Oracle JET library rejects such rows, and one was enough to replace the entire chart. Invalid rows are now dropped and logged instead.- Chart rendered roughly 60% too large on APEX 26.1 with the minor axis dates truncated. Universal Theme 26.1 raised the root font size from 10px to 16px and JET sizes the chart in rem; dimensions are now pinned in pixels and render identically on every Universal Theme generation.- Sample application: task 37 had an end date before its start; the Downtime and Overtime examples produced a downtime window that ended before it began on short and zero-length tasks, dropping those tasks.- The UC_GANTT package can now be renamed — it was previously hardcoded in the wrap.
Minimum versions
- Oracle APEX 24.2 (was 22.1) — use release 25.1.1 for APEX 22.1–24.1, release 24.1 for 19.2–21.2.- Oracle Database 19c (was 12c).
Upgrading — both steps are required
- Import the plug-in "United Codes Gantt Chart Pro".- Run ddl_uc_gcp_manual_install.sql to update the UC_GANTT package. Unlike 25.1.1 this is not optional: the Universal Theme size fix lives in the package, not the plug-in.- Licence is unaffected and needs no re-activation. Full version matrix in UPGRADE.md.
v26.1.0 — the plug-in is now self-contained, gains support for APEX 26.1 Trigger Actions, and raises its minimum APEX version.
- No PL/SQL package needed. The plug-in carries its own code; UC_CONTEXT_MENU is no longer installed or shipped. An existing package can be dropped — see UPGRADE.md.- Renamed. Internal name is now UNITEDCODES_CONTEXT_MENU, display name UC - Context Menu. Upgrading from v23.1 or older is a one-time manual migration — UPGRADE.md describes three ways to do it.- APEX 26.1 Trigger Actions supported. A context menu attached to a Trigger Action no longer fails with ORA-01403: no data found.- Fixed: modal pages opened twice. Menu entries targeting a modal page opened two identical dialogs on APEX 24.2 and later.- Fixed: "function body returning boolean" entry conditions. The condition code is no longer upper-cased, so comparisons against text such as 'Smith' keep matching, and only the first declare/begin is rewritten so nested blocks stay intact.- Minimum version is now APEX 24.2 (Oracle Database 19c). Previously APEX 19.2.
### Changed behavior
- Cells with client-side validation errors no longer trap the user in the cell. Invalid cells are now highlighted, the validation error is shown as a cell comment, and the user can continue editing other cells. Saving stays blocked until all errors are resolved. Set the new option `trapInvalidCells` to `true` to restore the previous trapping behavior.
### Improvements
- Pasting many rows into select list (LOV) columns now resolves the display values in a few batched requests instead of one request per cell. This prevents "too many requests" (HTTP 429) errors when pasting large datasets (e.g. hundreds of rows from Excel).
### Bug Fixes
- Pasting into cascading select list columns now resolves child columns correctly: parent columns are resolved first and their pasted values are used to filter the child LOVs. Previously, child values on freshly inserted rows could be wrongly flagged as invalid.- Select list values containing commas or trailing whitespace are now matched exactly on paste instead of being flagged as invalid.- Aggregation rows (SUM, AVG, ...) are no longer included when copying or cutting grid data, so pasting the data back does not create a spurious extra row.- Pasting more rows than the grid contains no longer overwrites or displaces the aggregation row; new rows are inserted above it.- Validation error comments are now kept visible on invalid cells. Previously the comment could be wiped right after it was set, leaving an empty comment box.- Fixed lingering tooltips that stayed on the grid after scrolling or navigating with the keyboard.- Fixed a state leak in the multiple select editor where values from a previously edited cell could carry over when opening the editor by typing.
Fixed issue with select lists missing a value when editing multiple rows in a quick way.
(You only need to update the plug-in)
- Fix issue with ' character in values
'
- Security optimizations
All dependencies are now included in the plug-in itself. No JavaScript will be loaded from a CDN anymore.
The plug-in now throws an exception when calling p_crud_request.get_value instead of p_crud_request.get_clob_value in validation / DML processes for a CLOB.
Only database sources changed, not the plug-in itself.
Upgrade the plug-in "United Codes Gantt Chart Pro".
* 25.1.0.0 PL/SQL * 25.1.1.0 JavaScript * 25.1.1.0 Plugin
Enhanced Grid Pro:
Bug Fixes:
Improvements:
Fixes:
New features:
Fixed issues with APEX 24.2 where triggering element would not work anymore.
Resolved an issue where if a user adds a new row, clicks save, and then scrolls down to load more rows, the last row would be loaded again and thus duplicated.
Added a workaround for a database issue where empty CLOB values where treated as string “null” instead of a real NULL. This resulted in CLOB columns getting updated to string “null”'s when saving a row with an empty clob.
- Fixed bugs when using external CDN for the plugin.
- Used the new Modular UI of the Apryse PDF Viewer
Bug fixes:
Also refer to the updated docs and sample app.
Upgrade package "UC_GANTT" and the plugin "United Codes Gantt Chart Pro".
* 25.1.0.0 PL/SQL * 25.1.0.0 JavaScript * 25.1.0.0 Plugin
Various stability improvements and bug fixes:
New feature: Time Buckets
Use Time Buckets to declaratively display sprints , holidays, or any other time bucket tailored to your needs.
Bug Fixes
Features:
Improvements
We're thrilled to announce the initial release of SearchBox Pro, an APEX plug-in that adds a powerful global search to your applications.
- 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
- Plug-in documentation
- Demo application
Enhanced Grid Pro v24.1.1 is now available for download.
Added some features and fixed some bugs.
Show/hide columns using UI dialog
Use Saved reports - in a same way as they're used with IR/IG
Use HTML Expression field, same as it's possible with IR/IG (to style cells, etc.)
Use aggregations on numeric columns
/
Fixed an issue with plug-in not working in APEX 24.1
"Sum" now rounded to two decimal places
Grid plug-in can now handle big numbers normally
Enhanced Grid Pro v24.1 is now available for download. This version is compatible with APEX 19.2 and higher.
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).
JavaScript API:
"Show delete column" option
New column option: "Duplicate Copies Existing Value"
Select list columns now support Copy-Paste from Excel
Numeric column - added culture support
Select list column
Checkbox column
"Total" counter not updated
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.
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; }
Initial release of Plug-ins Pro FlowForms!
v24.1
Release date: 2024-01-22
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;
}
Small fix to sample application.
Added to Plug-ins Pro Community Plug-ins
Initial release as a Plug-ins Pro Community Plug-in.
Initial release as a Plug-ins Pro Community Plug-in. Previously released by FOEX as a FOS plug-in.