Version 11 Release Note
Summary
- The document describes the changes in Version 11 of AdapTable
- It was released on 14 March 2022 and supports AG Grid version 27
- AdapTable React includes full coverage for AG Grid's new React UI
- Version 11 provides a new Settings Panel which replaces the individual popup windows
- Adaptable Charting has been removed
Breaking Change
There are a few, unavoidable, breaking changes in Version 11 (see below for more details):
- The Charting plugin has been removed from AdapTable altogether
- Flashing Cells is a new property in Initial Adaptable State (was previously in Alert Initial State)
- Alert related properties have moved from Notification Options into a separate class
- Flashing Cell properties have moved from Notification Options to a new Flashing Cell Options class
- Instantiating AdapTable Vanilla requires separate
gridOptionsandmodulesproperties - The vendorContainer property in Container Options was renamed to
agGridContainer
Key Changes
These are the key changes in AdapTable Version 11 - listed by topic.
React UI
-
Version 11 of AdapTable React provides full suppport for the new AG Grid React UI
Note
This is now the default behaviour when using AdapTable React so there is nothing you need to do
Adaptable Instantiation
- The instantiation of AdapTable 'Core' (but not AdapTable React or AdapTable Angular) has changed:
- the
vendorGridproperty has been renamedgridOptions(and receives an AG Grid GridOptions object) - there is a new
modulesproperty which should receive any AG Grid Enterprise Modules that you require
- the
const adaptableOptions: AdaptableOptions = {
licenseKey: '<ADAPTABLE_LICENSE_KEY_HERE>',
primaryKey: 'model',
adaptableId: 'Basic Setup',
initialState: initialState,
gridOptions: gridOptions, // this is the AG Grid Grid Options
modules: [...AllEnterpriseModules], // any AG Grid Modules required
};Scalar Aggregations
-
Adaptable Rx has extended the range of Aggregation Expressions
-
The previous
AdaptableAggregationQueryhas been replaced by 2 types each of which run aggregations over a whole column or a set of column data:- Aggregation Boolean Expressions which return true / false and used in Alerts and Calculated Columns
- Aggregation Scalar Expressions which return any value; initially only used in Calculated Columns but will be extended to other Modules if use cases demand it
Breaking Change
The
AdaptableAggregationQuerythat used anAggregationExpressionno longer exists in place of:- an
AdaptableAggregatedBooleanQuerywhich usesAggregatedBooleanExpression - an
AdaptableAggregatedScalarQuerywhich usesAggregatedScalarExpression
Flashing Cells
-
Flashing Cells are now a separate Module (they were previously part of Alerts)
-
Flashing Cell Options have been moved from Notification Options into a new Flashing Cell Options class
-
Flashing has been extended to Aggregated Cells (in Grouped Rows)
-
They have their own section in Initial Adaptable State (and no longer in Alert Initial State)
Breaking Change
This is a breaking change. However the Flashing Cell Definition is not changed and existing Flashing Cell definitions will be automatically upgraded by AdapTable on application start up
Alerts
-
Alerts are no longer responsible for Flashing Cells - which is now a separate Module
-
Highlight Row Action added and both it and Highlight Cell can use a CSS Class Name
-
An optional
AlertMessagecan be added to the Alert Definition (in place of creating one dynamically) -
The Application Icon will display in the Alert (if one has been provided in User Interface Options)
-
2 new Row-related Predicates have been added for Alerts (in Version 11.1)
Breaking Change
Aggregation Expressions previously used in Alerts have been redefined as Aggregation Boolean Expressions (in order to differentiate from the new
ScalarAggregationExpressions)
Calculated Columns
- Have been extended to support Scalar Aggregation Expressions for more advanced use cases
Charts
- The Charting Plugin - which was using Infragistics Charting has been removed
- Sparkline Columns are still available and supported - but require AG Grid charting to be enabled
Note
AdapTable provided charting before AG Grid introduced a charting package and is now rarely used.
AG Grid charts now has a very powerful and mature feature set and so, going forward, we will be concentrating on how we can add value to that.
Breaking Change
This is a breaking change. All previous Adaptable Charting functionality has been fully removed
Settings Panel
-
There is now a single Settings Panel which contains all the previous standalone popups
-
It is fully resizable and configurable
-
No code changes are required to activate this
-
The
alwaysShowInDashboardandalwaysShowInToolPanelproperties in Settings Panel Options ensure that the Module Button to open the Settings Panel is always visible in the Dashboard and ToolPanel respectivelyDeep Dive
Where is the Home Button and what has happened to my Module Buttons?
Dashboard
- 2 changes have been made to the Default Properties used in Dashboard State:
-
SettingsPanelis now the only default item in theModuleButtonsproperty -
Tabsnow contains an empty array by default (in place of the set that AdapTable used to provide)Caution
This means that AdapTable no longer provides a default Tab called Toolbars if not Tabs are supplied in Initial Adaptable State
-
General UI Improvements
- Multiple Columns can be selected (via Column Menu)
- The tabs displayed in Grid Info section of Settings Panel can be configured in User Interface Options
- A new State Management Toolbar and ToolPanel have been added
- The Export Selected Cells Context Menu item now includes a list of available Export Destinations
- Columns can be given a different Caption / Header (per Layout)
customSortComparersin Custom Sort Options now use Scope (instead ofcolumnId)Breaking Change
This is a breaking change
Coding Reference
These are the main code and class changes in AdapTable 11 you need to be aware of:
Initial Adaptable State
- New
FlashingCellsection introduced to Initial Adaptable State - contains a collection of FlashingCellDefinitions (previously part of Alert Initial State) - Calculated Columns and FreeText Columns include a
SpecialColumnSettingsproperty enabling them to be configured with more properties (e.g. width, sortable etc) - DataType Scope in Shortcuts is limited to
NumericDataType only
Adaptable Options
-
The
vendorGridproperty has been renamed togridOptions(and takes an AG Grid GridOptions object) -
There is a new
modulesproperty which should receive any AG Grid Enterprise Modules that you requireNote
This only affects instantiation of AdapTable 'vanilla' version - AdapTable React and AdapTable Angular are unaffected
-
The vendorContainer property in Container Options was renamed to
agGridContainer -
3 new Adaptable Options Classes has been added
- Alert Options - includes the Alert-specific properties previously in Notification Options
- Flashing Cell Options - contains the Flashing Cell related properties previously in Notification Options
- Settings Panel Options - contains options for configuring the new Settings Panel
- in Expression Options - used for managing AdapTableQL (includes an
ExpressionOptionssection)
-
Custom Sort Comparers now use the Scope object (instead of a single
columnId)
Adaptable API
-
2 new Adaptable API Classes have been added:
-
The
addGridDataupdateGridDataanddeleteGridDatamethods in Grid API are now asynchronous and return an array of affected AG Grid Row Nodes -
A new
setCellValuesmethod in Grid API enables multiple AG Grid cells to be updated in one go
Plugins
- Charting Plugin has been removed completely
Modules
- There are 3 new Modules introduced in Version 11
- Settings Panel
- Flashing Cell
- Charting - currently contains no functionality but will offer Charting Extensions in future releases
Events
- The
vendorGridproperty returned by theAdaptableReadyInfoargs in the Adaptable Ready Event has been renamedgridOptions
AdaptableRx
-
Adaptable Rx has a new Expression type: Aggregation Scalar Expressions
-
It aggregates a group of cells and returns a single value and is used initially in Calculated Columns
-
The previous AggregateExpression has been replaced with an Aggregation Boolean Expression
Breaking Change
The
AggregateExpressionused in Alerts is replaced with an Aggregation Boolean Expression
Change Logs
| AdapTable Version | Release Date | AG Grid Compatibility |
|---|---|---|
| 11.3 | 26 May 2022 | 27.2.0 |
| 11.2 | 11 May 2022 | 27.2.0 |
| 11.1 | 25 March 2022 | 27.1.0 |
| 11.0 | 14 March 2022 | 27.0.0 |
Version 11.3 Changelog
| Key | Type | Description |
|---|---|---|
| AT-1653 | Bug | ✅ No Format Column is applied if the first definition is suspended (even if there are other available active) |
| AT-1647 | Enhancement | ✅ Add Scrolling to columns list to Expression Editor when used in wizard in Settings Panel |
| AT-1640 | Enhancement | ✅ Add ShareEntity method to TeamSharingApi |
| AT-1638 | Bug | ✅ Cannot add a new Conditional Style if Settings Panel opened via api |
| AT-1635 | Bug | ✅ Adaptable errors when it gets destroyed and recreated |
| AT-1629 | Bug | ✅ Active Filter Icon does not appear in Column header if using AG Grid Filter Form |
| AT-1627 | Bug | ✅ Fix expression evaluation of complex column values (nested fields, special columns etc.) |
| AT-1614 | Bug | ✅ Aggregated CalculatedColumn displays NaN instead of numerical values |
| AT-1587 | Bug | ✅ Filter icon doesnt clear when removing filter on a column with a cell renderer |
| AT-1586 | Bug | ✅ Filters dont work for non-numeric columns that use a Value Formatter |
| AT-1484 | Bug | ✅ Fix Server Validation |
| AT-1415 | Enhancement | ✅ Dont show missing Primary Key warning if its in the data (but not a Column) |
| AT-1373 | Enhancement | ✅ Create a nicer UI visualisation of a Column Filter |
Version 11.2 Changelog
| Key | Type | Description |
|---|---|---|
| AT-1621 | Enhancement | ✅ Update Angular Demo app to show how to access Adaptable API |
| AT-1611 | Bug | ✅ Add support for AG Grid 27.2.x |
| AT-1610 | Bug | ✅ Docs: TOC links for Technical Reference pages don't work |
| AT-1608 | Bug | ✅ Runtime error (crash) on 'Export All Adaptable State' |
| AT-1602 | Enhancement | ✅ Add boolean property to LayoutOptions to add Layout names to tag list |
| AT-1600 | Enhancement | ✅ Add Highlight Row as an option for ALL Alerts |
| AT-1597 | Enhancement | ✅ Add 'IN' to the Default Filter Predicate list |
| AT-1596 | Enhancement | ✅ Allow Labels to show US English |
| AT-1595 | Bug | ✅ Column editability (true/false) should affect only user(UI), but NOT programmatic(API) operations |
| AT-1593 | Bug | ✅ showDocumentationLinks ignored in Settings Panel |
| AT-1588 | Bug | ✅ Percent Bar crashes if no Min Value provided when using a Column Comparison |
| AT-1574 | Enhancement | ✅ Extend scope for FormatColumn.CheckboxStyle |
| AT-1568 | Enhancement | ✅ Add AdaptableStyle style editor to Alerts Wizard |
| AT-1564 | Bug | ✅ Filtering by date values bug when column has a value formatter |
| AT-1563 | Bug | ✅ Add and Delete Row predicates do not use a Custom Header Message is provided |
| AT-1560 | Bug | ✅ Apply AdaptableStyle.ClassName for FlashingCells |
| AT-1556 | Enhancement | ✅ Keep custom toolbar buttons rendering in sync |
| AT-1555 | Enhancement | ✅ List the Bespoke Columns when describing a User Report |
| AT-1554 | Bug | ✅ Check for existing row when editing cell |
| AT-1551 | Enhancement | ✅ Add key based editing to number editor |
| AT-1550 | Enhancement | ✅ Allow CSS Variables to be referenced in colorPalette |
| AT-1548 | Enhancement | ✅ Optimise grid performance for high frequency updates |
| AT-1544 | Enhancement | ✅ Expand colorPalette property in UserInterfaceOptions to receive name of current theme |
| AT-1517 | Bug | ✅ AdaptableReady gets called continuously when using a view |
| AT-1393 | Bug | ✅ Misalignment of checkboxes in Alerts / Behaviour Wizard Step |
| AT-1266 | Enhancement | ✅ Reduce `persistState` calls |
| AT-1212 | Enhancement | ✅ Add a 'NOT IN' (Exclude Values) predicate |
| AT-791 | Enhancement | ✅ Make pivoting in Layout Editor a bit more intuitive |
| AT-488 | Enhancement | ✅ Enable ability for user to add custom Cell Edits |
| AT-298 | Enhancement | ✅ Create a Summary Tab in Grid Info section of Settings Panel |
Version 11.1 Changelog
| Key | Type | Description |
|---|---|---|
| AT-1534 | Bug | ✅ AG Grid Filter Form is displayed for columns with saved Filters |
| AT-1530 | Enhancement | ✅ Enable LayoutEditor to be displayed without Settings Panel |
| AT-1529 | Enhancement | ✅ Implement getRowId as well as getRowNodeId |
| AT-1525 | Bug | ✅ Percent Bar doesnt automatically re-render when cell value changes |
| AT-1519 | Documentation | ✅ Add Algolia search to documentation |
| AT-1516 | Enhancement | ✅ Enable multiple cells to be updated in AdapTable via OpenFin Excel |
| AT-1515 | Enhancement | ✅ Use the current Layout's column sorts for grouped columns |
| AT-1510 | Bug | ✅ Grid crashes (sometimes) when cell selection includes empty cells or grouped rows |
| AT-1507 | Bug | ✅ Percent Bar Column is not working in the AdapTable React |
| AT-1497 | Enhancement | ✅ Add quickFilterHeight property to FilterOptions |
| AT-1491 | Bug | ✅ Conditional Styles dont show in Pivot Layouts if they are Current Layout |
| AT-1486 | Bug | ✅ Cannot see the bar in Percent Bar Style when showing cell value |
| AT-1482 | Bug | ✅ Filter Icon appears inconsistently in column header and filter tool panel |
| AT-1472 | Bug | ✅ Ag-Grid api.setFloatingFiltersHeight does not work in AdaptableReady |
| AT-1470 | Enhancement | ✅ Add GridAPI method to select cells based on rowindex |
| AT-1446 | Enhancement | ✅ Show first current Grid Row in Expression Editor |
| AT-1370 | Enhancement | ✅ Add option to automatically Expand or Collapse Groups |
| AT-1302 | Task | ✅ Provide Alerts for 'Added/Removed Row(s)' events |
| AT-1248 | Enhancement | ✅ Set Grouped Column to be sorted in Layout |
| AT-1231 | Enhancement | ✅ Use AdapTable FilterForm in grouped columns also |
Version 11.0 Changelog
| Key | Type | Description |
|---|---|---|
| AT-1466 | Bug | ✅ Layout Editor shows all behaviours as grayed out |
| AT-1458 | Enhancement | ✅ Add a Settings Stage to Conditional Style Wizard |
| AT-1455 | Enhancement | ✅ Improve date handling for quick-search, filter form and diff queries |
| AT-1451 | Task | ✅ Add support for AG Grid v27 |
| AT-1445 | Task | ✅ Add support for cumulated aggregations to Calculated Column |
| AT-1442 | Bug | ✅ Fix packaging info in published releases |
| AT-1439 | Bug | ✅ Flashing cells defaults not correctly set |
| AT-1436 | Bug | ✅ ToolPanel items can be edited in Settings Panel when it has a Readonly entitlement |
| AT-1433 | Bug | ✅ Can no longer open wizard directly from query and column menus |
| AT-1431 | Bug | ✅ Ignore Case in Queries no longer being applied |
| AT-1423 | Bug | ✅ Prevent dashboard tab buttons from submitting forms |
| AT-1422 | Bug | ✅ Datepicker navigation bars (year & month) are not working |
| AT-1419 | Bug | ✅ Dates are not included in Quick search |
| AT-1418 | Enhancement | ✅ Add possibility to configure FlashingTarget in Flashing Cell Wizard |
| AT-1417 | Study | ✅ Extend Conditional Styles to Pivot groups |
| AT-1410 | Bug | ✅ IN filter works strangely with Server Side Row Model |
| AT-1406 | Enhancement | ✅ Toast Notifications image on left side should be better defined |
| AT-1405 | Bug | ✅ Cannot reopen a Master Detail row |
| AT-1403 | Task | ✅ Remove Charting from AdapTable and replace with better support for AG Grid Charting |
| AT-1402 | Enhancement | ✅ Add a Highlight Row method to Grid API |
| AT-1401 | Enhancement | ✅ Improve AddData, UpdateData, DeleteData GridApi methods to return relevant RowNodes |
| AT-1400 | Enhancement | ✅ Make Column Info link in Layout Editor contingent on Column Info being set |
| AT-1399 | Enhancement | ✅ Add Options to set which Grid Info sections are visible |
| AT-1398 | Enhancement | ✅ Toast Notifications Progress Bar is not visible on Info and Error Messages |
| AT-1394 | Bug | ✅ Use aggregation information in GridOptions if no Layout in Config |
| AT-1391 | Enhancement | ✅ Add Column Properties Section to Free Text Column Wizard |
| AT-1389 | Bug | ✅ Editing a FreeText Column shows the DataType is missing |
| AT-1388 | Bug | ✅ Use pinning information in GridOptions if no Layout in Config |
| AT-1382 | Enhancement | ✅ Licence fee box should show even when page is dark |
| AT-1378 | Enhancement | ✅ Update 'react-toastify' & 'react-day-picker' dependency versions |
| AT-1377 | Enhancement | ✅ Reduce Scope used in Shortcut so it can only take DataType of Number |
| AT-1376 | Enhancement | ✅ Use different Column and Context Menu context objects |
| AT-1375 | Bug | ✅ Filter components don't show Values dropdown if Column has Cell Renderer |
| AT-1374 | Bug | ✅ Filter Form doesnt work when autoApplyFilter is false in Filter Options |
| AT-1372 | Enhancement | ✅ Add Save button to the Query ToolPanel |
| AT-1371 | Bug | ✅ Clear Query button doesnt work in Query tool panel |
| AT-1369 | Study | ✅ See if Flashing can be enabled for Grouped Rows |
| AT-1366 | Enhancement | ✅ Add a 'Change Caption' Column Menu Item |
| AT-1364 | Enhancement | ✅ Update Highlight Cell for Alerts to optionally use Style Object |
| AT-1363 | Enhancement | ✅ Add a Highlight Row Behaviour for Alerts |
| AT-1361 | Enhancement | ✅ Allow special columns to use provided Column Types |
| AT-1358 | Bug | ✅ Ensure 'cssClassName' can be applied whenever AdaptableStyle is used |
| AT-1357 | Enhancement | ✅ Update Custom Sort Comparers to use Scope |
| AT-1351 | Bug | ✅ Calculated Columns dont re-evaluate when FreeText Column in the Expresssion changes |
| AT-1340 | Enhancement | ✅ Add default Column Filter Predicate option per column |
| AT-1333 | Bug | ✅ Conditional styles with Date predicates are not correctly applied on string values |
| AT-1332 | Bug | ✅ `Classname` is not applied for ReadOnly and Editable Cell Styles |
| AT-1331 | Enhancement | ✅ Add AdaptableApi in contextMenuItems under 'api' key |
| AT-1330 | Enhancement | ✅ Add a method to the gridApi to retrieve rowData |
| AT-1329 | Bug | ✅ Cannot clear a date when using Date Picker |
| AT-1326 | Enhancement | ✅ Add `setCellsValue` method to gridApi to allow updating multiple cells with one call |
| AT-1325 | Enhancement | ✅ Add `refreshRow` method on gridApi |
| AT-1324 | Enhancement | ✅ Allow customization of special (Calculated, FreeText, Action) columns e.g. `width`, `showMenu` |
| AT-1322 | Task | ✅ Fix 'critical issue' that appears in console when installing AdapTable |
| AT-1321 | Enhancement | ✅ Add optional AlertMessage property to Alert Definition |
| AT-1319 | Enhancement | ✅ Add destinations to 'Export Selected Cells' Context Menu item |
| AT-1313 | Enhancement | ✅ Add a FilterValues Trigger |
| AT-1304 | Enhancement | ✅ Add addIndex option to DataUpdateConfig |
| AT-1301 | Bug | ✅ Action Column Buttons only get rendered when they become visible |
| AT-1300 | Enhancement | ✅ Pass in current row to Edit Look Up Item function |
| AT-1299 | Enhancement | ✅ Add 'isDisplayed' and 'isSelected' properties to Row Info object |
| AT-1285 | Bug | ✅ Documentation links for modules are all wrong |
| AT-1283 | Enhancement | ✅ Fix font family for dashboard |
| AT-1270 | Enhancement | ✅ Show a Message when Loading a View |
| AT-1269 | Bug | ✅ Unmounting Adaptable before loadState resolves throws an error |
| AT-1268 | Bug | ✅ When `loadState` resolves to a false value `predefinedConfig` it is not used |
| AT-1267 | Bug | ✅ If the row-data has invalid Date string it fails inside QueryEditor |
| AT-1264 | Bug | ✅ Many State events published in Audit Log before user has done anything |
| AT-1249 | Bug | ✅ Filter Form doesnt show values for Columns with Cell Renderers |
| AT-1229 | Enhancement | ✅ Create a Manage State Module Toolbar and ToolPanel |
| AT-1216 | Enhancement | ✅ Display Application Icon in Alerts if one provided |
| AT-1210 | Task | ✅ Improve Modal Container Options |
| AT-1183 | Documentation | ✅ Document how FilterActionOnDataChange works |
| AT-1169 | Bug | ✅ Format column custom header name remains in wizard after format column deleted |
| AT-1162 | Task | ✅ Add support for grouped aggregations to Calculated Column |
| AT-1161 | Task | ✅ Add support for aggregated Calculated Columns |
| AT-1152 | Task | ✅ Allow Permitted Values function to accept a string to filter results |
| AT-1027 | Study | ✅ Provide Adaptable Options tab in Grid Info popup dynamically |
| AT-383 | Task | ✅ Make the "Click New" text in empty popups dependent on it not being read only. |
| AT-267 | Study | ✅ Enable multiple column selection |
| AT-189 | Task | ✅ Build a Modules overview window |