v24.2

With this version of Gantt Chart Pro, the minimum supported version of the Oracle APEX 22.1.  For previous versions of APEX, please use Gantt Chart Pro v24.1.
 

•  Re-design of the plug-in, "row-data" instead of the previously "task-data" parser
  list of new features:
  • Task dependency 
  • Task, Resource, and Dependency Templates
  • Theme changes
  • Downtime
  • Overtime
  • Color (Weekend, Current time)
  • Time buckets 
  • Custom scales and date formats (Date converter included)
  • Custom validations (click, move, resize)
  • Option to load additional modules (ex. oj-avatar)

Upgrade Instruction

Upgrade the "UC_GANTT" package and the plug-in "United Codes Gantt Chart Pro". 

If the "sort" functionality was used, please move the function into the new function "sortData" in  "option.methods".

/**
*     Example :
*      Previously
*/
function (pOptions) {
   
   //Invert resource sort
   pOptions.sort = 
       function (data) {
           return data.sort(function (a, b) {
               return a.resource < b.resource ? 1 : -1;
           })
       };       
   
   return pOptions;
}
/**
*     Example :
*      New from 24.2
*/
function (pOptions) {
   
   pOptions.methods = {   
       //Invert resource sort
       sortData : 
           function (data) {
               return data.sort(function (a, b) {
                   return a.resource < b.resource ? 1 : -1;
               })
       }  
       /*
       sortData : function (data) {
           //No sort
           return data;
       }
       */
   };
   return pOptions;
}

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.

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

• [1] The plug-in event is described in the section Item plug-in \ Events \ UC Froala Images In Collection.

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.