Version 17 Release Note

Summary

  • The Release Note outlines the key features and updates in Version 17 of AdapTable
  • It was released in January 2024 and supports AG Grid version 30

Breaking Change

New Modules

2 new Modules have been added in AdapTable 17.

Grid Filter

Data Import

  • The Data Import Module allows run-time users to import data into AdapTable
  • It supports both updating existing Rows and adding new Rows

Enhancements

AdapTable 17 includes a huge number of enhancements and improvements:

  • The Column and Context Menus have been refactored; each is now configured using a single property
  • Menu Items for Column Filters have been consolidated (with options to suspend or clear Filters)

User Interface

  • New Query Builder UI to enable building Expressions quickly and intuitively
  • New Dropdown / Select component which supports type-ahead
  • New option to pin toolbars in the Dashboard directly above Grid (rather than in Tabs)

Hint

This is particularly useful for Grid Filter as you can put the toolbar directly above the Grid near the Column Filters

General

AdapTableQL

Versioning Updates

AdapTable 17 has updated the minimum version for some core libraries and frameworks.

AdapTable React

  • React 18 is now the minimum supported version of React

Note

It is therefore no longer necessary to provide a renderReactRoot implementation

Breaking Change

The renderReactRoot prop has been removed

AdapTable Angular

  • AdapTable now supports Angular LTS versioning (similar to AG Grid)
  • This means Angular 15 is the current minimum supported version
  • We also updated the RxJS dependency version to ^7.4.0.

Hint

  • We highly recommend upgrading your RxJS version to 7.x
  • Although not mandatory, it comes with significant benefits, e.g. improved performance & reduced bundle size

Typescript

  • The minimum version of TypeScript supported is updated to 4.9.5

Coding Changes

The following changes have been to AdapTable's public classes:

AdapTable Modules

These changes have been made to AdapTable Modules:

Breaking Change

  • Filter or Query references in Dashboard, Tool Panel, Status Bar or Settings Panel Initial State won't be read
  • However AdapTable will automatically update all old Initial State the first time an application loads post update

Initial Adaptable State

  • In Initial Adaptable State the Query section of was removed and its 2 properties have been replaced as follows:
    • CurrentQuery is now the GridFilter property (of type GridFilter) in a Layout
    • NamedQueries is now the NamedQueries property in a new section of AdapTable State called Named Query

Breaking Change

  • The previous Queries State will no longer work in Version 17
  • However AdapTable will automatically update all old Initial State the first time an application loads post update

Adaptable Options

The changes to Adaptable Options are:

AdapTable API

AdapTable Events

The following changes have been made to the Adaptable Events:

Documentation Changes

  • We have made some cosmetic, but hopefully useful, changes to this Documentation
  • Sections have been added to the Sidebar to group similar pages together

Change Log

KeyTypeDescription
AT-2443Enhancement✅ Add Data Validation as new Alert Type
AT-2435Bug✅ Cannot pin the Tree View column
AT-2433Enhancement✅ Add scrolling to Columns list in Expression Editor
AT-2430Task✅ Upgrade RxJS version to ^7.4.0
AT-2429Task✅ Upgrade Typescript minimum version to 4.9.5
AT-2427Enhancement✅ Add option whether to show a Column in Action Row Form
AT-2420Enhancement✅ Layout UI should take Column & Grid Filter entitlements into account
AT-2418Enhancement✅ Replace useAdaptableQuickFilter & useAdaptableFilterForm properties in Column Filter Options with single property
AT-2410Enhancement✅ Add Values and ExcludeValues predicates for FlashingCell
AT-2407Enhancement✅ Add a REGEX Expression Function
AT-2406Enhancement✅ Add IS_NUMERIC Expression Function
AT-2404Enhancement✅ Add IS_NOT_BLANK Expression Function
AT-2403Enhancement✅ Remove the "PrimaryKeyDuplicate" Predicate
AT-2402Task✅ Upgrade to React 18
AT-2400Enhancement✅ Update Layout Wizard to add a Grid Filter step
AT-2391Enhancement✅ Update & enhance Openfin Notifications
AT-2381Task✅ Support Angular LTS versioning (currently 15 minimum)
AT-2380Enhancement✅ Add DeleteAllFormatColumn api method
AT-2377Enhancement✅ Add Menu Items for (un)suspending ColumnFilters
AT-2371Study✅ Add new Grid Filter module (to replace Queries)
AT-2368Bug✅ Fix DashboardChanged event handling for Custom Toolbars
AT-2365Bug✅ Custom Toolbars are rendered incorrectly in framework versions
AT-2364Enhancement✅ Allow devs to provide a function which will create the report name
AT-2362Task✅ Provide UI Query Builder (to create boolean expressions)
AT-2359Task✅ Create new Select control with autocomplete and Column selection
AT-2353Enhancement✅ Create a new Data Imported Event
AT-2348Task✅ Create Pinned Toolbars to sit above Grid
AT-2336Task✅ Refactor Column & Context Menus to merge functions into 1 property
AT-2335Task✅ Create "Import Data" Module allowing run time users to upload data
AT-2314Study✅ Improve support for external Charting libraries
AT-2310Task✅ Refactor Grid Info and Column Info Modules
AT-2254Task✅ Enable Badges in String Array columns
AT-2247Bug✅ Filter Form closes after selecting first date in Range
AT-2222Enhancement✅ Add separate Cell and Row Selection Changed Events
AT-2214Task✅ Add Calculated Column Type step to wizard
AT-2209Enhancement✅ Extend Quick Search to Pivot Layouts
AT-2187Enhancement✅ Custom Predicates with same ID should override System ones
AT-1535Task✅ ADDED_ROW & REMOVED_ROW Observable Expression Functions