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

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.

Initial release!  Item Option Manager Pro is now available for download.

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

Added 'headers' property to Web Service parameters, this allows you to send HTTP-Headers to the web service.

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.

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

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

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

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

Initial release!  UC AutoNumeric is now available for download.

Initial release!  SweetAlert2 Pro is now available for download.

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

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

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

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

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

• Added support for Interactive Grid
• Added option on "Position button" to "Popup LOV (inline)"
• Improved debug
• Code aligned with UC code convention

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

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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".

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

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 following fixes are included in 20.1.1:

• Initialisation of RTE in a Modal window
• Compatibility with Oracle DB 12c

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

• 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

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

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

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

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