Release History

View Release Notes for Plug-in

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.
The Plug-ins Pro Team 02-NOV-2023

PDF Region Pro
Added a redaction feature for PDF.
The Plug-ins Pro Team 24-OCT-2023

Rich Text Editor Pro
Version 23.2.2
Release Date: 2023-10-24
Froala framework
Changes
- The Froala WYSIWYG editor updated to 4.1.3 - changelog
Item plug-in
Bug fixes
- Fixed: Component settings Image Upload URL (Value Required) in 23.2.1 was referencing a hardcoded invalid URL
- Fixed: Plug-in attribute File URLs to Load \ Cascading Style Sheet was having extra / for plug-in file froala_editor.pkgd.min.css, causing editor not to render correctly on servers with strict policies
- Fixed: Computing REST handlers URL based on the plug-in substitution string #DEFAULT_*# was malformed when owa_util.get_cgi_env('X-Forwarded-Port') is set to NULL
- Fixed: Uploading error message when REST upload handler raises errors ERR_* was misleading, pointing to CORS policies [1]
- Fixed: Updating CLOB using supporting dynamic action was setting a page item session state to not supported value, including on-load checksum [2]
Annotations
- [1] Now, it prompts a developer to check an error in a browser console for a detailed error raised by a browser.
- [2] When using the plug-in APEX before 22.2, and the CLOB value exceeds the VARCHAR2 limitation, the plug-in nulls a page item session item, similarly to the APEX engine.
The Plug-ins Pro Team 18-OCT-2023

UC Parallax
Initial release! UC Parallax is now available for download.
The Plug-ins Pro Team 25-SEP-2023
Rich Text Editor Pro
Rich Text Editor Pro v23.2 is now available for download. This version is compatible with APEX 19.2 and higher.
Rich Text Editor Pro v23.2
The plug-in is successfully tested with the most recent APEX version (23.1.3) at apex.oracle.com.
General
- Froala editor is updated to 4.1.2
- a page item value in the session state is no longer the checksum of the current rich text - on APEX before 22.2, when the rich text content exceeds VARCHAR2 limitation, the session state is set to NULL according to APEX capabilities
- Checksum validation is stored in f01 or a page item if defined
- The editor’s toolbar layout is refined - buttons are regrouped within Froala editor’s toolbar groups: paragraph, text, rich, and misc.
Bug fixes
- Fixed: Removing duplicated uploaded images one by one doesn’t result in marking an image as removed in the plug-in session state.
- Fixed: The editor’s popup when inserting an image was cropped by APEX CSS rules for the grid column
- Fixed: The editor’s popup when inserting a link was cropped by APEX CSS rules for the grid column
- Fixed: The editor’s popup when inserting a font awesome icon was cropped by APEX CSS rules for the grid column
- Fixed: The editor’s popup when inserting special characters was cropped by APEX CSS rules for the grid column
- Fixed: The editor’s popup inserting emoticons icon was cropped by APEX CSS rules for the grid column
- Fixed: The editor’s popup inserting video was cropped by APEX CSS rules for the grid column
- Fixed: Clearing the plug-in session state using URL syntax and PL/SQL API **manageClearCache** was not working as expected
New features
- Support for native CLOB support starting with APEX 22.2 [1]
- The native Form component is now supported for APEX 19.2 and above [2]
- New image uploading mechanism
- Upload images on demand using dynamic action
- New third-party integrations are introduced
- Enhanced handling for uploaded images
Annotations
- [1] Native CLOB support still has flaws. For example, page item attribute Value required raises an error when rich text content exceeds the VARCHAR2 limitation. The workaround is to use APEX validation NOT NULL
- [2] Before APEX 22.2, the supporting process plug-in is required to handle CLOB values exceeding the VARCHAR2 limitation. CLOB values below 32 767 characters are supported natively
Support for CLOB values across APEX versions
- Form component is supported across APEX versions - before APEX 22.2, the supporting process plug-in is required to handle CLOB values exceeding the VARCHAR2 limitation. CLOB values below 32 767 characters are supported natively
- When not using a supporting plug-in, CLOB is supported by the APEX engine
New image uploading mechanism
- Images are uploaded in parallel, not one by one
- Possibility to preview upload errors and successes from page item level
- Configurable upload workflow to automatically cancel, continue or ask the end-user to take an action
- An image upload parameters are evaluated for each image when uploading
Upload images on demand
- Images can be uploaded on demand using the supporting dynamic action plug-in
- A developer can specify three JavaScript callbacks to be executed based on the upload workflow: fail, cancel, and done
Third-party plug-ins are supported
- A free third-party plug-in supported: Track Changes
- Paid third-party plug-in supported: WProofreader WebSpellCheck for Froala
- Paid third-party plug-in supported: Wiris Math Type
- Paid third-party plug-in supported: CODOX.io
Enhancements
- A new page item level attribute Initialization PL/SQL Initialization
- A new application level attribute Initialization PL/SQL Initialization
- Page item source type Database Column is supported when using native form component [1]
- Page item source type Item is supported [1]
- Page item source type PL/SQL Expression is supported [1]
- Page item attribute Default is now supported [1]
- Page item attributes Pre and Post are now supported
- Computing page item height is enhanced - minimum and maximum height is computed based on page item Height attribute, JavaScript Initialization Code (height, heightMax, heightMin), or value overridden using supporting dynamic action plug-in
Annotations
- [1] The plug-in relies on the APEX capabilities to handle CLOB values.
Item plug-in
Bug fixes
- Fixed: When the plug-in attribute JavaScript Initialization Code raised an error, the unhandled error message was shown. Now. the plug-in shows why, for example, the returned value from the anonymous JavaScript function is undefined.
- Fixed: plug-in wasn’t initialized when dynamic action customizing the editor wasn’t executed immediately
Changes
- The setting Enable TUI Image Editor is removed from page item attribute Settings in favor of the package variable UC_FROALA_RTE.g_plug_tui_enable. By default, it’s set to true, and it can be configured on the page item level or application level
- A new page item attribute Settings option is added: Expand height to fit rich text
- A new page item attribute is added: Initialization PL/SQL Code
- A new component settings attribute is added: Initialization PL/SQL Code
Dynamic Action plug-in
Bug fixes
- Fixed: missing help text for Upload parameters
- Fixed: missing help text for Image Browse Parameters
- Fixed: When dynamic action was implemented on the global page and it was containing true and false actions, and dynamic action wasn’t applied to the current instance, it made the plug-in stuck on initialization
- Fixed: using multiple instances where one is customized with dynamic action blocks initialization of each
New features
- New action Upload Images on demand
Changes
- Standard attribute JavaScript Initialization Code is enabled - right now, it is used only by a new action* upload images on demand
- Dynamic actions support dynamic action Wait For Result attribute
- Customizing rich text editor using global page has been redesigned
Process plug-in
Changes
- A new flag, g_froala_image_safe_to_delete is available for Delete Removed Images
- When Update PL/SQL doesn’t update CLOB in the database (SQL%ROWCOUNT is 0) then, the plug-in error message is set to Updating #LABEL# failed. where #LABEL# is page item label text.
New features
- A new process Process Uploaded Images looping over recently uploaded images, has been added
Packages
UC_FROALA_RTE
General
- New package variable g_update_include_rowcount
- New package variable g_toolbar_presets_refined
- New package variable g_warn_about_clob [1]
- New package variable g_froala_image_safe_to_delete [2]
- New package constant c_toolbar_group_paragraph [3]
- New package constant c_toolbar_group_text [3]
- New package constant c_toolbar_group_rich [3]
- New package constant c_toolbar_group_misc [3]
Annotations
- [1] if enabled and APEX supports CLOB and page item attribute Data Type is not set to CLOB, then the plug-in shows an error prompting to enable CLOB on page item level.
- [2] It was released with v23.1 but not included in the changelog
- [3] constants should be used as values for g_plug_trackchanges_group, g_plug_wiris_editor_group, g_plug_wiris_chemistry_group
Third-party integration: Track Changes
- New package variable g_plug_trackchanges_enable
- New package variable g_plug_trackchanges_group
- New package variable g_plug_trackchanges_pos
Third-party integration: TOAST UI Image Editor
- New package variable g_plug_tui_enable
Third-party integration: WProofreader Text Checker
- New package variable g_plug_spellcheck_enable
- New package variable g_plug_spellcheck_js
- New package variable g_plug_spellcheck_api
- New package variable g_plug_spellcheck_lang
- New package variable g_plug_spellcheck_ui_lang
- New package variable g_plug_spellcheck_theme
- New package variable g_plug_spellcheck_badge_enable
- New package variable g_plug_spellcheck_badge_lang
Third-party integration: Wiris Math Type
- New package variable g_plug_wiris_enable
- New package variable g_plug_wiris_js
- New package variable g_plug_wiris_editor_group
- New package variable g_plug_wiris_editor_pos
- New package variable g_plug_wiris_chemistry_group
- New package variable g_plug_wiris_chemistry_pos
UC_FROALA_SETTINGS
New package variable g_disable_rest_enabled_check
Sample application
New features
- Preview the plug-in page item definition directly in the sample application
- Preview the plug-in dynamic action definition directly in the sample application
- Preview the plug-in process definition directly in the sample application
- Preview the native form definition directly in the sample application
- Example pages are described using United Codes Guided Tour Pro
- Examples pages navigation is enhanced with the United Codes Context Menu
New examples
- Native form implementation for Oracle APEX 22.2 and above
- Native form implementation for Oracle APEX before 22.2
- Using page item source attribute to load CLOB content
- Display CLOB rich text using page item read-only attribute
- Handle CLOB using the supporting process plug-in only
- Handle CLOB using the plug-in PL/SQL API only
- Configure the plug-in upload images workflow
- Save images in the context of rich text in the database
- Custom toolbar: Google Calendar
- Custom toolbar: Google Docs
- Third-party integration: Track Changes
- Third-party integration: WProofreader WebSpellChecker
- This-party integration: Wiris Math Type
- Process Uploaded Images
- Upload Images on demand
Refined examples
- Customize the rich text editor using
- Send e-mail written using rich text editor
- Home page
Database objects
- A new sample table UC_FROALA_SAMPLE_CLOB_BLOBS
- A new sequence UC_FROALA_SAMPLE_CLOB_BLOBS_SEQ
- A new constraint UC_FROALA_SAMPLE_CLOB_BLOBS_FK
- A new constraint UC_FROALA_SAMPLE_CLOB_BLOBS_FK2
The Plug-ins Pro Team 15-SEP-2023
Enhanced Grid Pro
Enhanced Grid Pro v23.2.1 is now available for download. This version is compatible with APEX 19.2 and higher.
Overview
Minor release.
Fixed three issues.
Bug Fixes
- Setting NULL value via JS function setValue fails
- Required column should not be checked if not displayed (on Save)
- Close editor (e.g. datepicker, select list) on scroll event
- JS error message when clicking the line between rows
- Error when copy-pasting select list value to Text column
The Plug-ins Pro Team 23-AUG-2023
Enhanced Grid Pro
Enhanced Grid Pro v23.2 is now available for download. This version is compatible with APEX 19.2 and higher.
Overview
Most of the changes in this release are under the hood, so they are not directly visible to the users. But in general, the user experience with Enhanced Grid Pro is now better.
New features
- Cells Highlighting: It’s now possible to highlight cells/rows/columns in Grid via Grid’s Context menu. When highlighting is used, an event is triggered, so you can easily store highlighting settings in the database.
Improvements
“Select list” column
- Select lists now use lazy loading
- It's now possible to define a separator when multiple values are selected
Text Messages
- All texts used by Enhanced Grid Pro can now be translated via Text Messages
General
- Setting Cell Level CSS (background color) from SQL Query - GitHub issue #3
Bug Fixes
- No function with name 'COLUMN_OT' exists in this scope - GitHub issue #1
- Data Paging Hardcoded to 50 rows, Paging not always triggered - GitHub issue #2
- Bug when saving null values in UC Grid - GitHub issue #4
- Fixed a bug where the unchecked checkbox sent the string 'null' to the database instead of NULL
- When pasting data into Grid (e.g., from Excel), Grid automatically inserts as many new rows as needed. But it shouldn’t do this when the “Add Row” option is disabled in Grid’s settings. Till now, this setting was not taken into account, and now it is.
The Plug-ins Pro Team 26-JUL-2023

Item Option Manager Pro
Initial release! Item Option Manager Pro is now available for download.
The Plug-ins Pro Team 26-JUL-2023
Progress Bar Pro
Progress Bar Pro v23.1 is now available for download. This version is compatible with APEX 19.2 and higher.
- Fixed Max value issue
- Fixed JavaScript error (stack error)
- Support for DB 12.x
The Plug-ins Pro Team 06-JUL-2023

File & Image Uploader Pro
Added 'headers' property to Web Service parameters, this allows you to send HTTP-Headers to the web service.
The Plug-ins Pro Team 12-JUN-2023

Modal Warn on Unsaved Changes Pro
Modal Warn on Unsaved Changes Pro v23.1 is now ready for download! This is the initial release of this plug-in.
Displaying Warning messages when data has been changed but not saved is beyond the scope of a modal dialog page's native functionality. We've built Modal Warn on Unsaved Changes Pro to improve the user interface and experience. This plug-in tracks if there are any changes on the modal page when closing or canceling the modal dialog to warn the user of possible data loss.
The Plug-ins Pro Team 17-MAY-2023
UC AutoNumeric
UC Autonumeric v23.1 is now ready for download! This release includes:
- A new attribute called “Has Filter” for the following feature https://forums.oracle.com/ords/apexds/post/interactive-grid-column-aggregation-when-column-type-is-plu-5225
- Upgraded the library to the last stable version v4.6.3
The Plug-ins Pro Team 15-MAY-2023
Gantt Chart Pro
Minor update:
- BugFix on move task (before: if the date (items on top of the grid) was changed, then move action stopped working)
- BugFix on refresh Gantt (before: if the date (items on top of the grid) was changed, all the tasks were scattered and not neatly aligned.)
- Upgrade on edit task (click on the task) - In 'EDIT Link' is now also possible to pass variable APEX$GANTT_RESOURCE_ID

Release History

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

Version 23.2.2

Froala framework

Changes

Item plug-in

Bug fixes

Rich Text Editor Pro v23.2

General​

Bug fixes​

New features​

Enhancements​

Item plug-in​

Bug fixes​

Changes​

Dynamic Action plug-in​

Bug fixes​

New features​

Changes​

Process plug-in​

Changes​

New features​

Packages​

UC_FROALA_RTE​

UC_FROALA_SETTINGS​

Sample application​

New features​

New examples​

Refined examples​

Database objects​

Overview

Bug Fixes

Overview

New features

Improvements

Bug Fixes

General

Bug fixes

New features

Enhancements

Item plug-in

Bug fixes

Changes

Dynamic Action plug-in

Bug fixes

New features

Changes

Process plug-in

Changes

New features

Packages

UC_FROALA_RTE

UC_FROALA_SETTINGS

Sample application

New features

New examples

Refined examples

Database objects