Skip to Main Content

Release History

  • 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:

    functionpOptions ) {

    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:

  • 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
  • The Plug-ins Pro Team 17-APR-2023
    PDF Region Pro

    Initial release!  PDF Region Pro is now available for download.

  • The Plug-ins Pro Team 13-APR-2023
    Enhanced Grid Pro

    Initial release!  Enhanced Grid Pro is now available for download.

  • The Plug-ins Pro Team 15-MAR-2023
    Rich Text Editor Pro

    The plug-in is successfully tested with the most recent APEX version (22.2.4) at apex.oracle.com.

    Item plug-in

    • All files except the TUI image editor and language files are referenced in an application builder's plug-in definition - see the plug-in attribute File URLs to Load. Referencing the plug-in JS and CSS files on th plug-in definition level enables a developer to move the plug-in files to an external server.
    • Fixed: the plug-in export file size is reduced from 13,3 MB to 6,4 MD due to removing redundant Froala files from the plug-in definition.
    • Fixed: WEBP images don't raise an error when uploading.
    • Fixed: the plug-in raises an error for a non-existing metadata procedure.
    • Fixed: an image collection flag save to remove is being wrongly computed when an image URL protocol differs from an application's protocol.
    • Fixed: missing workspace name when an application uses friendly URLs and when REST URL is computed from the plug-in substitution strings #DEFAULT_REST_URL_*
    • Fixed: the plug-in event UC Froala Images In Collection triggered with corrupted event data. [1]
    • Fixed: the plug-in raises a PL/SQL error when computing a CLOB checksum for CLOBs value bigger than 8 MB.
    • Fixed: missing help text for the standard plug-in attribute Execute JavaScript Initialization Code

    Annotations

    PL/SQL API

    • A new signature for function UC_FROALA_RTE.clobGetHTML is now available. The function accepts an item name implementing the plug-in.
    • A new signature for procedure UC_FROALA_RTE.clobDisplay is now available. The procedure accepts an item name implementing the plug-in.

    Sample application

    The plug-in documentation can be opened directly from the sample application pages.

    Fixed: the de-installation script raises an error on removing package PIP_CRYPTO.

    Documentation

    • The documentation is remastered and available at https://www.plug-ins-pro.com/docs/rich-text-editor-pro.
    • The database objects created after installation are now described.
    • The installation instructions (sample application and manual installation) are now described.
    • The license activation instructions are now described.
    • The support instructions are
    • The downloading instructions are now described.
    • The changelog is now included in the documentation.

    Installation bundle

    • DDL scripts removed: ddl_unitedcodes_rich_text_editor_pro.sql and ddl_unitedcodes_rich_text_editor_pro_sample_rest.sql. [1]
    • A new DDL script is now available: ddl_uc_rte_update_plugin_pkgs.sql. [2]
    • A new DDL script is now available: ddl_uc_rte_manual_install.sql. [3]
    • A new DDL script is now available: ddl_uc_rte_manual_deinstall.sql. [4]

    Annotations

    • [1] Scripts are replaced by a new DDL script ddl_uc_rte_manual_install installing all objects at once.
    • [2] The script overrides the plug-in packages UC_FROALA_RTE, UC_FROALA_SETTINGS, and the plug-in type UC_RTE_ACCESS_TOKEN.
    • [3] The script is used to manually install the plug-in database objects in an existing application.
    • [4] The script removes database objects created using the script ddl_uc_rte_manual_install.sql.
  • The Plug-ins Pro Team 13-DEC-2022
    UC AutoNumeric

    Initial release!  UC AutoNumeric is now available for download.

  • The Plug-ins Pro Team 09-DEC-2022
    SweetAlert2 Pro

    Initial release!  SweetAlert2 Pro is now available for download.

  • The Plug-ins Pro Team 03-MAR-2022
    Automatic Constraint Validation Pro

    Version 22.1.08 of Automatic Constraint Validation Pro is ready to be downloaded.  Improvements include:

    Sample Application Bug Fixes

    • Forms on all pages - After successful saving of a form with 'Apply Changes' or 'Create' the form was empty. Now the app stores the PK values in session state.
    • On page Introduction / Events / Item \ Column - the Instruction list was not clickable. The links have been fixed.

    Library 

    • function validate_form_items_list:
      • checked conversion of item min and max values
      • date item min and max : changed wrong format 'YYYY-MM-DDTHH24:MI:SS' to 'DD-MON-YYYY'
      • allowed process points now include 'Before Regions'
      • Improved validation messages for foreign keys and intervals.
    • function Current_Page_Has_No_Plugin_DA:
      • The function now returns true when the current page has no plug-in invocations and the current page has input fields for database columns.

    New Plug-in Arguments

    • Added filter for inactive constraints.
    • Added Table Name Prefix. (To be removed from displayed table names.)

    Javascript event handler 

    • Ignore leading and trailing blanks in key comparison for IG uniqueness test
    • Improved messages for composite uniqueness test
  • The Plug-ins Pro Team 03-MAR-2022
    UC Automatic Constraint Validation

    Version 22.1.08 of UC Automatic Constraint Validation is ready to be downloaded.  Improvements include:

    Sample Application Bug Fixes

    • Forms on all pages - After successful saving of a form with 'Apply Changes' or 'Create' the form was empty. Now the app stores the PK values in session state.
    • On page Introduction / Events / Item \ Column - the Instruction list was not clickable. The links have been fixed.

    Library 

    • function validate_form_items_list:
      • checked conversion of item min and max values
      • date item min and max : changed wrong format 'YYYY-MM-DDTHH24:MI:SS' to 'DD-MON-YYYY'
      • allowed process points now include 'Before Regions'
      • Improved validation messages for foreign keys and intervals.
    • function Current_Page_Has_No_Plugin_DA:
      • The function now returns true when the current page has no plug-in invocations and the current page has input fields for database columns.

    New Plug-in Arguments

    • Added filter for inactive constraints.
    • Added Table Name Prefix. (To be removed from displayed table names.)

    Javascript event handler 

    • Ignore leading and trailing blanks in key comparison for IG uniqueness test
    • Improved messages for composite uniqueness test