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!  Interactive Grid Checkbox Pro is now available for download.

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

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