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 gridOptions and modules properties
  • 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

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

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 AlertMessage can 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 alwaysShowInDashboard and alwaysShowInToolPanel properties in Settings Panel Options ensure that the Module Button to open the Settings Panel is always visible in the Dashboard and ToolPanel respectively

    Deep 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:
    • SettingsPanel is now the only default item in the ModuleButtons property

    • Tabs now 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

Coding Reference

These are the main code and class changes in AdapTable 11 you need to be aware of:

Initial Adaptable State

Adaptable Options

Adaptable API

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

AdaptableRx

Change Logs

AdapTable VersionRelease DateAG Grid Compatibility
11.326 May 202227.2.0
11.211 May 202227.2.0
11.125 March 202227.1.0
11.014 March 202227.0.0

Version 11.3 Changelog

KeyTypeDescription
AT-1653Bug✅ No Format Column is applied if the first definition is suspended (even if there are other available active)
AT-1647Enhancement✅ Add Scrolling to columns list to Expression Editor when used in wizard in Settings Panel
AT-1640Enhancement✅ Add ShareEntity method to TeamSharingApi
AT-1638Bug✅ Cannot add a new Conditional Style if Settings Panel opened via api
AT-1635Bug✅ Adaptable errors when it gets destroyed and recreated
AT-1629Bug✅ Active Filter Icon does not appear in Column header if using AG Grid Filter Form
AT-1627Bug✅ Fix expression evaluation of complex column values (nested fields, special columns etc.)
AT-1614Bug✅ Aggregated CalculatedColumn displays NaN instead of numerical values
AT-1587Bug✅ Filter icon doesnt clear when removing filter on a column with a cell renderer
AT-1586Bug✅ Filters dont work for non-numeric columns that use a Value Formatter
AT-1484Bug✅ Fix Server Validation
AT-1415Enhancement✅ Dont show missing Primary Key warning if its in the data (but not a Column)
AT-1373Enhancement✅ Create a nicer UI visualisation of a Column Filter

Version 11.2 Changelog

KeyTypeDescription
AT-1621Enhancement✅ Update Angular Demo app to show how to access Adaptable API
AT-1611Bug✅ Add support for AG Grid 27.2.x
AT-1610Bug✅ Docs: TOC links for Technical Reference pages don't work
AT-1608Bug✅ Runtime error (crash) on 'Export All Adaptable State'
AT-1602Enhancement✅ Add boolean property to LayoutOptions to add Layout names to tag list
AT-1600Enhancement✅ Add Highlight Row as an option for ALL Alerts
AT-1597Enhancement✅ Add 'IN' to the Default Filter Predicate list
AT-1596Enhancement✅ Allow Labels to show US English
AT-1595Bug✅ Column editability (true/false) should affect only user(UI), but NOT programmatic(API) operations
AT-1593Bug✅ showDocumentationLinks ignored in Settings Panel
AT-1588Bug✅ Percent Bar crashes if no Min Value provided when using a Column Comparison
AT-1574Enhancement✅ Extend scope for FormatColumn.CheckboxStyle
AT-1568Enhancement✅ Add AdaptableStyle style editor to Alerts Wizard
AT-1564Bug✅ Filtering by date values bug when column has a value formatter
AT-1563Bug✅ Add and Delete Row predicates do not use a Custom Header Message is provided
AT-1560Bug✅ Apply AdaptableStyle.ClassName for FlashingCells
AT-1556Enhancement✅ Keep custom toolbar buttons rendering in sync
AT-1555Enhancement✅ List the Bespoke Columns when describing a User Report
AT-1554Bug✅ Check for existing row when editing cell
AT-1551Enhancement✅ Add key based editing to number editor
AT-1550Enhancement✅ Allow CSS Variables to be referenced in colorPalette
AT-1548Enhancement✅ Optimise grid performance for high frequency updates
AT-1544Enhancement✅ Expand colorPalette property in UserInterfaceOptions to receive name of current theme
AT-1517Bug✅ AdaptableReady gets called continuously when using a view
AT-1393Bug✅ Misalignment of checkboxes in Alerts / Behaviour Wizard Step
AT-1266Enhancement✅ Reduce `persistState` calls
AT-1212Enhancement✅ Add a 'NOT IN' (Exclude Values) predicate
AT-791Enhancement✅ Make pivoting in Layout Editor a bit more intuitive
AT-488Enhancement✅ Enable ability for user to add custom Cell Edits
AT-298Enhancement✅ Create a Summary Tab in Grid Info section of Settings Panel

Version 11.1 Changelog

KeyTypeDescription
AT-1534Bug✅ AG Grid Filter Form is displayed for columns with saved Filters
AT-1530Enhancement✅ Enable LayoutEditor to be displayed without Settings Panel
AT-1529Enhancement✅ Implement getRowId as well as getRowNodeId
AT-1525Bug✅ Percent Bar doesnt automatically re-render when cell value changes
AT-1519Documentation✅ Add Algolia search to documentation
AT-1516Enhancement✅ Enable multiple cells to be updated in AdapTable via OpenFin Excel
AT-1515Enhancement✅ Use the current Layout's column sorts for grouped columns
AT-1510Bug✅ Grid crashes (sometimes) when cell selection includes empty cells or grouped rows
AT-1507Bug✅ Percent Bar Column is not working in the AdapTable React
AT-1497Enhancement✅ Add quickFilterHeight property to FilterOptions
AT-1491Bug✅ Conditional Styles dont show in Pivot Layouts if they are Current Layout
AT-1486Bug✅ Cannot see the bar in Percent Bar Style when showing cell value
AT-1482Bug✅ Filter Icon appears inconsistently in column header and filter tool panel
AT-1472Bug✅ Ag-Grid api.setFloatingFiltersHeight does not work in AdaptableReady
AT-1470Enhancement✅ Add GridAPI method to select cells based on rowindex
AT-1446Enhancement✅ Show first current Grid Row in Expression Editor
AT-1370Enhancement✅ Add option to automatically Expand or Collapse Groups
AT-1302Task✅ Provide Alerts for 'Added/Removed Row(s)' events
AT-1248Enhancement✅ Set Grouped Column to be sorted in Layout
AT-1231Enhancement✅ Use AdapTable FilterForm in grouped columns also

Version 11.0 Changelog

KeyTypeDescription
AT-1466Bug✅ Layout Editor shows all behaviours as grayed out
AT-1458Enhancement✅ Add a Settings Stage to Conditional Style Wizard
AT-1455Enhancement✅ Improve date handling for quick-search, filter form and diff queries
AT-1451Task✅ Add support for AG Grid v27
AT-1445Task✅ Add support for cumulated aggregations to Calculated Column
AT-1442Bug✅ Fix packaging info in published releases
AT-1439Bug✅ Flashing cells defaults not correctly set
AT-1436Bug✅ ToolPanel items can be edited in Settings Panel when it has a Readonly entitlement
AT-1433Bug✅ Can no longer open wizard directly from query and column menus
AT-1431Bug✅ Ignore Case in Queries no longer being applied
AT-1423Bug✅ Prevent dashboard tab buttons from submitting forms
AT-1422Bug✅ Datepicker navigation bars (year & month) are not working
AT-1419Bug✅ Dates are not included in Quick search
AT-1418Enhancement✅ Add possibility to configure FlashingTarget in Flashing Cell Wizard
AT-1417Study✅ Extend Conditional Styles to Pivot groups
AT-1410Bug✅ IN filter works strangely with Server Side Row Model
AT-1406Enhancement✅ Toast Notifications image on left side should be better defined
AT-1405Bug✅ Cannot reopen a Master Detail row
AT-1403Task✅ Remove Charting from AdapTable and replace with better support for AG Grid Charting
AT-1402Enhancement✅ Add a Highlight Row method to Grid API
AT-1401Enhancement✅ Improve AddData, UpdateData, DeleteData GridApi methods to return relevant RowNodes
AT-1400Enhancement✅ Make Column Info link in Layout Editor contingent on Column Info being set
AT-1399Enhancement✅ Add Options to set which Grid Info sections are visible
AT-1398Enhancement✅ Toast Notifications Progress Bar is not visible on Info and Error Messages
AT-1394Bug✅ Use aggregation information in GridOptions if no Layout in Config
AT-1391Enhancement✅ Add Column Properties Section to Free Text Column Wizard
AT-1389Bug✅ Editing a FreeText Column shows the DataType is missing
AT-1388Bug✅ Use pinning information in GridOptions if no Layout in Config
AT-1382Enhancement✅ Licence fee box should show even when page is dark
AT-1378Enhancement✅ Update 'react-toastify' & 'react-day-picker' dependency versions
AT-1377Enhancement✅ Reduce Scope used in Shortcut so it can only take DataType of Number
AT-1376Enhancement✅ Use different Column and Context Menu context objects
AT-1375Bug✅ Filter components don't show Values dropdown if Column has Cell Renderer
AT-1374Bug✅ Filter Form doesnt work when autoApplyFilter is false in Filter Options
AT-1372Enhancement✅ Add Save button to the Query ToolPanel
AT-1371Bug✅ Clear Query button doesnt work in Query tool panel
AT-1369Study✅ See if Flashing can be enabled for Grouped Rows
AT-1366Enhancement✅ Add a 'Change Caption' Column Menu Item
AT-1364Enhancement✅ Update Highlight Cell for Alerts to optionally use Style Object
AT-1363Enhancement✅ Add a Highlight Row Behaviour for Alerts
AT-1361Enhancement✅ Allow special columns to use provided Column Types
AT-1358Bug✅ Ensure 'cssClassName' can be applied whenever AdaptableStyle is used
AT-1357Enhancement✅ Update Custom Sort Comparers to use Scope
AT-1351Bug✅ Calculated Columns dont re-evaluate when FreeText Column in the Expresssion changes
AT-1340Enhancement✅ Add default Column Filter Predicate option per column
AT-1333Bug✅ Conditional styles with Date predicates are not correctly applied on string values
AT-1332Bug✅ `Classname` is not applied for ReadOnly and Editable Cell Styles
AT-1331Enhancement✅ Add AdaptableApi in contextMenuItems under 'api' key
AT-1330Enhancement✅ Add a method to the gridApi to retrieve rowData
AT-1329Bug✅ Cannot clear a date when using Date Picker
AT-1326Enhancement✅ Add `setCellsValue` method to gridApi to allow updating multiple cells with one call
AT-1325Enhancement✅ Add `refreshRow` method on gridApi
AT-1324Enhancement✅ Allow customization of special (Calculated, FreeText, Action) columns e.g. `width`, `showMenu`
AT-1322Task✅ Fix 'critical issue' that appears in console when installing AdapTable
AT-1321Enhancement✅ Add optional AlertMessage property to Alert Definition
AT-1319Enhancement✅ Add destinations to 'Export Selected Cells' Context Menu item
AT-1313Enhancement✅ Add a FilterValues Trigger
AT-1304Enhancement✅ Add addIndex option to DataUpdateConfig
AT-1301Bug✅ Action Column Buttons only get rendered when they become visible
AT-1300Enhancement✅ Pass in current row to Edit Look Up Item function
AT-1299Enhancement✅ Add 'isDisplayed' and 'isSelected' properties to Row Info object
AT-1285Bug✅ Documentation links for modules are all wrong
AT-1283Enhancement✅ Fix font family for dashboard
AT-1270Enhancement✅ Show a Message when Loading a View
AT-1269Bug✅ Unmounting Adaptable before loadState resolves throws an error
AT-1268Bug✅ When `loadState` resolves to a false value `predefinedConfig` it is not used
AT-1267Bug✅ If the row-data has invalid Date string it fails inside QueryEditor
AT-1264Bug✅ Many State events published in Audit Log before user has done anything
AT-1249Bug✅ Filter Form doesnt show values for Columns with Cell Renderers
AT-1229Enhancement✅ Create a Manage State Module Toolbar and ToolPanel
AT-1216Enhancement✅ Display Application Icon in Alerts if one provided
AT-1210Task✅ Improve Modal Container Options
AT-1183Documentation✅ Document how FilterActionOnDataChange works
AT-1169Bug✅ Format column custom header name remains in wizard after format column deleted
AT-1162Task✅ Add support for grouped aggregations to Calculated Column
AT-1161Task✅ Add support for aggregated Calculated Columns
AT-1152Task✅ Allow Permitted Values function to accept a string to filter results
AT-1027Study✅ Provide Adaptable Options tab in Grid Info popup dynamically
AT-383Task✅ Make the "Click New" text in empty popups dependent on it not being read only.
AT-267Study✅ Enable multiple column selection
AT-189Task✅ Build a Modules overview window