Skip to Main Content

Release History

  • 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
  • The Plug-ins Pro Team 09-FEB-2022
    Automatic Constraint Validation Pro

    Initial release!  Automatic Constraint Validation Pro is now available for download.

  • The Plug-ins Pro Team 09-FEB-2022
    UC Automatic Constraint Validation

    Initial release!  UC Automatic Constraint Validation is now available for download.

  • The Plug-ins Pro Team 18-JAN-2022
    Rich Text Editor Pro

    Important notice regarding upgrading from v21.4: Changes introduced with this release might be affected by the current plug-in settings in your existing implementation. It is strongly recommended that you upgrade the plug-in in a copy of your application before releasing it to a production environment. 

    • After upgrading the plug-in in your application examine the plug-in component settings in Shared Components. Attributes configuring URLs to REST module must be (if using #OWNER_LOWER#) updated with new default values described in help texts. If any plug-in instance is using Override Application Attributes, it must be updated too. Learn more in REST URLs attributes help text. Using #OWNER_LOWER# results in showing error on page load.
    • Examine changes in the sample REST package for uploading images (procedure UC_FROALA_SAMPLE_REST.imageUpload) - REST template uploading images has to return the full URL to uploaded image. The current value of a new attribute Image GET URL is available through the plug-in access token and it must be used to return an image URL by REST template upload.
    • In order to enable uploading images examine all implementations of the plug-in and set the new plug-in attribute Upload Image(s) on Request(s) on item level. Otherwise, newly added images will never be uploaded using the plug-in REST.
    • If you were processing images (stored in the plug-in collection) on page submission you have to adapt to the new collection column usage - learn more in the plug-in documentation.
    • If you were using the supporting dynamic action plug-in action Browser Parameters make sure dynamic actions implementing the action is listening to the plug-in event Froala Before Initialization.

    Froala framework

    • Froala framework has been updated from version 3.2.1 to 3.2.6-1 (learn more in Froala change log Changelog for WYSIWYG Editor - Froala )
    • Froala is now more RWD-friendly and adapts editor width dynamically.

    General

    • Image resizing with the mouse is now enabled by default
    • Multibyte characters are now supported and don't raise an error when processing CLOB content
    • When application (or item) level attributes defining REST URLs are having different protocol than currently used in the browser, the plug-in forces the current protocol

    Image handling

    • Images now are uploaded only for defined page request(s) when a page is submitted. If images are not uploaded by the plug-in they remain in CLOB content as they were added (or loaded with CLOB) to the plug-in editor. For example, images added from desktop are embedded as inline base 64 images by default,
    • If an image is copied and pasted into the plug-in editor within a browser, the plug-in will try to download an image (based on the src attribute) and upload (using REST) it on-page submission. If the plug-in fails on downloading an image, the end-user is asked whether to cancel the upload or preserve the image in CLOB content as it is.
    • Images uploaded using plug-in REST and removed from the editor can be easily deleted in the database using the new supporting plug-in process type Delete Removed Images.
    • Images statuses in the collection were re-designed and use different collection columns - learn more in documentation
    • Pasting content containing images from Microsoft Word or Google docs is now supported
    • Images added to the editor are using less data-* attributes to track images

    United Codes Rich Text Editor Pro (Item)

    Item attributes

    • Application-level attributes for REST URLs are now required
    • New item level attribute Upload Image(s) on Request(s) defining page submit a request for which images are uploaded.
    • Item level attributes Image Browse URL, Image Delete URL, Image Upload URL use new default values #DEFAULT_REST_URL_UPLOAD#, #DEFAULT_REST_URL_BROWSE#, #DEFAULT_REST_URL_DELETE#. Old substitution string #OWNER_LOWER# is still supported but deprecated.
    • Item-level attribute Settings \ Embed Images as Inline Base64 was removed.
    • Application and item level attribute Image GET URL has been added along with default value #DEFAULT_REST_URL_GET#.
    • Application and item level attributes Image Browse URL, Image Delete URL, Image Upload URL, and Image GET URL can use substitution string #DEFAULT_REST_URL_MODULE# - see attribute help text for detailed information.

    Events

    • Event Froala Image Removed was removed
    • Event Froala Image Inserted was removed
    • Event Froala Images in Collection is updated and exposes new data - learn more in the plug-in documentation.

    United Codes Rich Text Editor Pro (Extend)

    • Oracle APEX dynamic action flag Wait for Result is now supported by the supporting plug-in
    • Action Enable Base64 Images was removed
    • Action Disable Base64 Images was removed
    • Action Browser Parameters has been updated and must be now created only for the plug-in event Froala Before Initialization.

    United Codes Rich Text Editor Pro (Process)

    • A new process type Delete Removed Images is added (learn more about usage in the sample application)

    PL/SQL API

    • A new procedure clobDisplay is added
    • A new function clobGetHTML is added

    RESTful Service

    • Sample REST module ucfroalasamplerest is updated on the template level
    • Sample REST module ucfroalasamplerest package UC_FROALA_SAMPLE_REST has been updated
      • Procedures were adapted to the new image handling
      • Procedures now have default error handling implemented

    Sample Application

    • The home page has been updated in order to show major plug-in features
    • A new page The Plug-in \ Attributes \ Upload Images on Request has been added,
    • The page The Plug-in \ Events has been updated
    • The page The Plug-in \ Attributes Plug-in \ Embed Images as Inline Base64 was removed
    • The page The plug-in \ Attributes \ Height has been updated
    • A new page Supporting plug-ins \ United Codes Rich Text Editor Pro (Process) \ Delete Removed Images has been added,
    • The page Supporting plug-ins \ United Codes Rich Text Editor Pro (Extend) \ Minimum Height has been updated
    • The page Supporting plug-ins \ United Codes Rich Text Editor Pro (Extend) \ Maximum Height has been updated
    • The page Supporting plug-ins \ United Codes Rich Text Editor Pro (Extend) \ Base64 Images was removed
    • The page Supporting plug-ins \ United Codes Rich Text Editor Pro (Extend) Browse Parameters is updated - page description was invalid and misleading
    • The page Examples \ How to display CLOB content? has been updated
    • The page Examples \ How to create and send an HTML email? has been updated
    • The page Examples \ How do I print the contents of my editor? has been updated

    Supporting Objects

    • Installation scripts have been updated
    • Deinstallation scripts have been updated.  All plug-in supporting objects are now removed.  If any other plug-in is activated in the current workspace, the script won't remove the objects listed below:
      • UC_PLUGISNPRO_LICENSE table
      • PIP_CRYPTO package
      • UC_PLUGINSPRO package

     

  • The Plug-ins Pro Team 05-MAY-2021
    UC List Extension
    • Added support for Interactive Grid
    • Added option on "Position button" to "Popup LOV (inline)"
    • Improved debug
    • Code aligned with UC code convention
  • The Plug-ins Pro Team 22-APR-2021
    Progress Bar Pro

    Initial release!  Progress Bar Pro is now available for download.

  • The Plug-ins Pro Team 16-APR-2021
    Client-side Validation Pro

    Client-side Validation Pro has been updated to support  validation subtypes.

  • The Plug-ins Pro Team 31-MAR-2021
    Client-side Validation Pro

    Updated licensing mechanism.

    Important Note: Installing a Plug-ins Pro plug-in containing the 31-MAR-2021 licensing update, will require that ALLPlug-ins Pro plug-ins installed in the same schema be updated and reactivated to a compatible version released on or after 31-MAR-2021.

  • The Plug-ins Pro Team 31-MAR-2021
    Gantt Chart Pro

    Updated licensing mechanism.

    Important Note: Installing a Plug-ins Pro plug-in containing the 31-MAR-2021 licensing update, will require that ALLPlug-ins Pro plug-ins installed in the same schema be updated and reactivated to a compatible version released on or after 31-MAR-2021.

  • The Plug-ins Pro Team 31-MAR-2021
    Guided Tour Pro

    Updated licensing mechanism.

    Important Note: Installing a Plug-ins Pro plug-in containing the 31-MAR-2021 licensing update, will require that ALLPlug-ins Pro plug-ins installed in the same schema be updated and reactivated to a compatible version released on or after 31-MAR-2021.

  • The Plug-ins Pro Team 31-MAR-2021
    File & Image Uploader Pro

    Updated licensing mechanism.

    Important Note: Installing a Plug-ins Pro plug-in containing the 31-MAR-2021 licensing update, will require that ALLPlug-ins Pro plug-ins installed in the same schema be updated and reactivated to a compatible version released on or after 31-MAR-2021.

  • The Plug-ins Pro Team 31-MAR-2021
    Rich Text Editor Pro

    Updated licensing mechanism.

    Important Note: Installing a Plug-ins Pro plug-in containing the 31-MAR-2021 licensing update, will require that ALLPlug-ins Pro plug-ins installed in the same schema be updated and reactivated to a compatible version released on or after 31-MAR-2021.

  • The Plug-ins Pro Team 31-MAR-2021
    Interactive JET Charts Pro

    Updated licensing mechanism.

    Important Note: Installing a Plug-ins Pro plug-in containing the 31-MAR-2021 licensing update, will require that ALLPlug-ins Pro plug-ins installed in the same schema be updated and reactivated to a compatible version released on or after 31-MAR-2021.

  • The Plug-ins Pro Team 31-MAR-2021
    IG File Download Pro

    Updated licensing mechanism.

    Important Note: Installing a Plug-ins Pro plug-in containing the 31-MAR-2021 licensing update, will require that ALLPlug-ins Pro plug-ins installed in the same schema be updated and reactivated to a compatible version released on or after 31-MAR-2021.

  • The Plug-ins Pro Team 31-MAR-2021
    IG Checkbox Pro

    Updated licensing mechanism.

    Important Note: Installing a Plug-ins Pro plug-in containing the 31-MAR-2021 licensing update, will require that ALLPlug-ins Pro plug-ins installed in the same schema be updated and reactivated to a compatible version released on or after 31-MAR-2021.

     
  • The Plug-ins Pro Team 03-MAR-2021
    Rich Text Editor Pro

    Fix for supporting plug-in "process":

    • When the plug-in collection wasn't initialized, the plug-in type "Clear" was raising an error on clearing the plug-in not initialized collection. Now, removing an item CLOB value from the plug-in collection is done only if the collection is initialized. Otherwise, no action is performed.
    • When the plug-in type was set to "Load from SQL Query" and provided SQL query returned other type than CLOB, the plug-in wasn't able to fetch CLOB value using APEX_EXEC.GET_CLOB. Now, the plug-in raises an error if APEX_EXEC.GET_CLOB raises no_data_found. In order to fetch non-CLOB value from SQL Query it is required to use to_clob function within SQL Query. For example: "select to_clob(123) from dual"

    Fix for license creation to support Oracle Database 21c.

  • The Plug-ins Pro Team 19-FEB-2021
    UC List Extension

    Initial release! UC List Extension is now available for download.

  • The Plug-ins Pro Team 09-FEB-2021
    Guided Tour Pro

    Enhancements

    • Attributes - new application attributes added: "Popper Skidding" and "Popper Distance" configuring popper offset of a tour step cross application.
    • User Interface - when tour was not using "Add Masking", the step arrow was not visible. Step element shadow is increased to highlight the step arrow.
    • Sample application
      • A new "Tour Builder" page has been added. The tour builder enables developers to create table-based tours directly from the sample application.
      • "Examples \ Table-based tour" page has been updated.
    • Supporting Objects \ Packages - new package "UC_GUIDEDTOUR_API" has been added. The package contains functions/procedures to handle tables "UC_GUIDEDTOURS_STEPS" and "UC_GUIDEDTOURS_TOURS"

     Bug fixes

    • Plug-in JavaScript core - Fixed: table-based tours wasn't respecting flag "Fire on page load" set to "No". 
    • Pug-in attributes
      • Fixed: when table-based tour has no steps, the plug-in was raising unhandled error.
      • Removed invalid column "CUSTOM_BUTTONS" from the plug-in default value for attribute "SQL Query Returning Tour Steps".
      • Added missing column "DISPLAY_SEQUENCE" to the plug-in default value for attribute "SQL Query Returning Tour Steps".
      • Added missing column "INIT_JS" to the plug-in default value for attribute "SQL Query Returning Tour Steps".  
      • Attribute "Action \ Initialize Tour (Custom Table)" no longer raises an error on tour initialization.

    Other

    •   Supporting Objects \ Tables
      • table "UC_GUIDEDTOURS_STEPS" renamed to "UC_GUIDED_TOUR_SAMPLE_STEPS".
      • table "UC_GUIDEDTOURS_TOURS" renamed to "UC_GUIDED_TOUR_SAMPLE_TOURS".
      • table "UC_GUIDEDTOUR_DISALBED" renamed to "UC_GUIDEDTOUR_SAMPLE_DISABLED"
      • new table "UC_GUIDEDTOUR_STEPS" has been added. Table is used by the plug-in action "Initialize Tour (Table)".
      • new table "UC_GUIDEDTOUR_TOURS" has been added. Table is used by the plug-in action "Initialize Tour (Table)".
    • Supporting Objects \ Packages - package "UC_GUIDEDTOUR_SAMPLE_APP" has been changed in order to handle tables "UC_GUIDED_TOUR_SAMPLE_STEPS" and "UC_GUIDED_TOUR_SAMPLE_TOURS".
  • The Plug-ins Pro Team 04-FEB-2021
    Gantt Chart Pro

    Initial release!  Gantt Chart Pro is now available for download.

  • The Plug-ins Pro Team 01-FEB-2021
    Rich Text Editor Pro

    The following fixes are included in 21.1:

    • Modal Page issue fix: creating the plug-in instance is followed with a timeout check (500ms) to initialise plug-in if event "theme42ready" or "apexwindowresized" is not triggered.
    • Added "apex-session" for ORDS RESTful call header / allows to authenticate call on ORDS level
    • Refactored error handling for the process plug-in
    • When the process plug-in "load" actions executes and "no_data_found" is raised, the plug-in logs information on the PL/SQL level and sets the CLOB to null
  • The Plug-ins Pro Team 02-DEC-2020
    Rich Text Editor Pro

    The following fixes are included in 20.1.1:

    • Initialisation of RTE in a Modal window
    • Compatibility with Oracle DB 12c
  • The Plug-ins Pro Team 20-NOV-2020
    Rich Text Editor Pro

    Initial release!  Rich Text Editor Pro is now available for download.

  • The Plug-ins Pro Team 14-SEP-2020
    IG Checkbox Pro
    The following fixes are included in 20.1.1:
    • Interactive Grids using rowid are now supported
    • The plug-in change event is now properly triggered for the active row and modified colum
    • The checkbox container now uses an additional attribute, data-column-name, to identify the column
    • Clicking on checkboxes in different rows is no longer displays the checkbox in the IG inline popup
  • The Plug-ins Pro Team 15-JUL-2020
    File & Image Uploader Pro

    Initial release!  Image Uploader Pro is now available for download.

  • The Plug-ins Pro Team 16-JUN-2020
    Client-side Validation Pro

    Initial release!  Client-side Validation Pro is now available for download.

  • The Plug-ins Pro Team 16-JUN-2020
    IG Checkbox Pro

    Initial release!  Interactive Grid Checkbox Pro is now available for download.

  • The Plug-ins Pro Team 16-JUN-2020
    IG File Download Pro

    Initial release!  Interactive Grid Download File Pro is now available for download.