Changelog

Changelog

25.1

Release date : 9-APR-2025

New features

• Validation functions can now process all submitted rows. This allows for validations that require checking multiple rows at once. You can specify if a validation function is “row-by-row” or “all rows”.
• Related to this, you can now enable “process all rows”. This will also send unchanged rows to the server (validation + save).
• Autofill/drag-down support for numeric arithmetic and geometric series.
• Option “outsideClickDeselects” where clicking outside the grid will lose the selection.
• Option to automatically select a value from an select list if the cascading parent was changed and only one value is returned from the query (“autoselectOnlyValueOnCascade”)
• Experimental support to freeze columns (sticky position on horizontal scrolling)

Improvements

• Validation JS function now also receives the row data as an object.
• Saved reports now also store the static ID and will prefer the static ID over the internal region ID.
• The getData function has an optional “asObject” parameter, which returns a row as an object (with the column name) instead of an array.
• Option to allow pasting via the context-menu (“contextMenuPaste”). It is not enabled by default because it requires user permission to read the context menu.

Bug Fixes

• Fixed issue with duplicate row where, after a save, the original row was refreshed and displayed as the duplicated row.
• Clob columns are not sortable, as this caused issues
• Re-enabled column sorted for cascading select list children
• Fixed a bug where client-side validations fired on aggregate rows.

Migration

Run the following SQL to migrate the database or import the sample application and click upgrade supporting objects.

alter table uc_grid_report_settings
  add constraint uc_grid_report_settings_report_type_ck
  check ( report_type in ('primary', 'alternative', 'private') );

alter table uc_grid_report_settings
  add constraint uc_grid_report_settings_username_null_ck
  check (
    (username is null and report_type in ('primary', 'alternative') )
    or
    (username is not null and report_type = 'private' )
);

alter table uc_grid_report_settings add static_id varchar2(255 char);

begin
  for rec in (
    select rs.id, rg.static_id
      from uc_grid_report_settings rs
      join apex_application_page_regions rg
        on rg.application_id = rs.app_id
       and rg.page_id = rs.page_id
       and rg.region_id = rs.region_id
       and rg.static_id is not null
  )
  loop
    update uc_grid_report_settings
       set static_id = rec.static_id
     where id = rec.id;
  end loop;

  commit;
end;
/

create index uc_grid_report_settings_ix1
  on uc_grid_report_settings (app_id, page_id, static_id, region_id);

24.1.1

Release date : 30-AUG-2024

New features

• Show/hide columns using UI dialog

• Use Saved reports - in a same way as they’re used with IR/IG

  • Primary/Alternative
  • Private

• Use HTML Expression field, same as it’s possible with IR (to style cells, etc.)

  • Used with all column types except for “Select list” and “Checkbox”.

• Use aggregations on numeric columns

  • SUM
  • AVG
  • MIN
  • MAX
  • COUNT

Bug Fixes

• Fixed an issue with plug-in not working in APEX 24.1

  • Reason was: With APEX 24.1, unlimited attributes for plug-ins were introduced

• “Sum” now rounded to two decimal places

  • Before, too many decimal places were displayed to user.

24.1.0

Release date : 16-MAY-2024

New features

• JavaScript API:

  • New function “getFiltersUsed” - it returns all filters cuurently used (as JavaScript array).
  • New function “isColumnReadOnly” - it checks if Grid’s column is readOnly (disabled).
  • New function “isCellReadOnly” - it checks if Grid’s cell (column at given row index) is readOnly (disabled).

• “Show delete column” option

  • There’s an option now to include “Delete” column as the last column in Grid. That simplifies deleting rows for end users.

• New column option: “Duplicate Copies Existing Value”

  • Works the same way as in the Interactive Grid. When end user chooses to duplicate Grid’s row, values will be copied (or not) to the new row, based on the setting.

Improvements

• Select list columns now support Copy-Paste from Excel

  • Developers can define whether end users will paste Display or Return values into Select list column. Once values are pasted, Grid will go to database and check whether pasted values are valid or not.
  • By default a DISPLAY value is expected.

• Numeric column - added culture support

  • Application’s language is now used to determine how to display numeric values (what to use as thousand and decimal separator)

Bug Fixes

• Select list column

  • When multi-select is used, Grid plug-in was not detecting changes in case when multiple values were there already and one got removed, and another one added.

• Checkbox column

  • It was not possible to use Grid’s Javascript API function “setValidationFunction” with checkbox columns. Now that is possible.

• “Total” counter not updated

  • When rows in Grid got deleted or created, “Total” counter (at the bottom of the Grid) was not updated.

23.2.1

Release date : 15-SEP-2023

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 clicked the line between rows
• Error when copy-pasting select list value to Text column

23.2.0

Release date : 23-AUG-2023

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 to database.

Improvements

• “Select list” column

  • Select lists are now using lazy loading
  • It’s now possible to define 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 Hard coded 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 unchecked checkbox sent string ‘null’ to database, instead of NULL
• When pasting data into Grid (e.g. from Excel), Grid inserts as many new rows as needed automatically. But it shouldn’t do this when “Add Row” option is disabled in Grid’s settings. Till now, this setting was not taken into account, now it is.

23.1.0

Initial release.

Release date : 12-APR-2023