Version 12 Release Note

Key Changes

These are the key changes in AdapTable Version 12 - listed by topic.

Status Bar

• AdapTable content can now be displayed in the AG Grid Status Bar
• This provides quick access to key functionality and is an alternative to Dashboard and Tool Panel
• Users can configure unlimited AdapTable Status Panels
• Each can be provided, and placed in 3 locations on the Status Bar: left, right and centre
• An AdapTable Status Panel can include multiple Module Status Panels
• AdapTable provides one Status Panel per Module - some contain rich functionality like dropdowns and selectors (e.g. Layout, Export, Theme), others consist of a link to the Module' page in the Settings Panel

FDC3 Columns

• AdapTable provides 5 FDC3 column types that can be set up as required
• Additionally developers can provide custom FDC3 columns
• Each FDC3 Column can be configured to:
  • Broadcast FDC3 Messages
  • Raise FDC3 Intents

Layout Object Scope

• Layouts have been extended so that they can be 'scoped' to include particular objects
• This allows developers to restrict objects like Format Columns to particular Layouts
• This can be automated by AdapTable and will honoured when the Layout is Shared
• Additionally, Column Filters now operate at a per-Layout (rather than global) level

Data Sets

• Data Sources (previously available in DataSource config) have been replaced with DataSets
• These are now provided in Data Set Options
• Data Sets are similar to DataSources they replaced, but can also contain form definitions
• This allows end users to build data sets using dynamic forms with parameterised queries

Custom Smart Edit Operations

• Smart Edit ships with 4 mathematical operations - Add, Subtract, Multiply and Divide
• These can now be extended with custom operations (e.g. Power)
• This allows users to perform bespoke editing operations

AG Grid Definitions for Special Columns

• Previously Special (e.g Calculated, FreeText and Action) Columns could only be defined via AdapTable
• AdapTable then would create an AG Grid column to match the definition
• This meant that you could not add AG Grid elements to the Column or put it in a Column Group
• Now special columns can be pre-defined in AG Grid allowing them to have same richness as other columns

ToolPanel Setup

• The setup of the AdapTable ToolPanel Component has been simplified
• The requirement to reference Component in components section of GridOptions has been removed
• Bespoke ToolPanel properties (e.g. minWidth and ordering of the different Panels) can still be provided
• But this is done by providing a bespoke ToolPanel configuration directly in sideBar property of GridOptions

Saving AG Grid Charts

• AG Grid Charts can now be defined and persisted in Charting Initial State section of Adaptable State
• There are new methods in Charting API to facilitate this

General UI Improvements

• Action Columns can contain multiple buttons

• Custom sections can be displayed in the Settings Panel

• Prefix and Suffix have been added to Display Formats available for string columns

• An Adaptable Button can now inculde Icons - including custom-provided ones

• Custom Display Formatters can now be provided for Format Columns

• The Data Change History grid can take any kind of button

  Breaking Change

  The Undo button that was previously displayed in the form by default has been removed

AdapTable React

• No longer required to reference the AdaptableToolPanelComponent in components section of GridOptions

AdapTable Angular

• No longer required to reference the AdaptableToolPanelComponent in components section of GridOptions
• AdapTable now requires a minimum of version 12 of Angular

Coding Reference

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

Initial Adaptable State

• The DataSource section has been removed
• The Filter section has been removed (but Layouts now have a new ColumnFilters property)
• A new Status Bar section has been added
• A new Charting section has been added

Adaptable Options

• A new Column Options section has been added to Adaptable Options
• The previously standalone customPredicateDefs section has been moved into Predicate Options
• Many properties in Tool Panel Options which configured the ToolPanel have been removed

Adaptable API

• The DataSourceAPI class in Adaptable API has been replaced with DataSet API
• A new Charting API class to aid in the persistence and loading of AG Grid charts
• Some methods (e.g. getFilterState) have been removed from Filter API to reflect that Column Filters are now stored with a Layout

Modules

• The Charting Module has been added
• The DataSource Module has been removed

Events

2 new Adaptable Events have been added:

Event	When Fired
Data Set Selected	A new DataSet has been selected by the User
FDC3 Message Sent	FDC3 message was sent - can be Broadcast Message or an Intent raised

Release History

AdapTable Version	Release Date	AG Grid Compatibility
12.2	29 August 2022	27.3.0
12.1	25 July 2022	27.3.0
12.0	20 June 2022	27.3.0

Version 12.2 Change Log

Version 12.2 was released on 29 August 2022.

The main new features in this version include:

• AdapTable now fully supports Weighted Averages in 3 different ways:
  • can be defined as Aggregations in Layouts
  • or can be created using AdapTableQL Expressions
  • a WeightedAvg Cell Summary Operation has also been added

• The IN (Values) Predicate has been extended to Alerts

• Column Filters can now be suspended (and can be cleared from Filter Toolbar)

• New unbalancedgroupskey property enabling grouping of unbalanced Row Groups

• Usability improvements to the Expression Editor:

  • Additional context-sensitive help when building Expressions
  • Column Friendly Names (i.e. Headers) are used wherever the Expression is referenced in AdapTable
  • A Column Search box has been added to make it easy to find Columns to drag into Expression builder

• Multiple enhancements to AdapTableQL functionality including

  • A new VAR Expression Function which enables variables to be used in Expressions
  • Multiple columns can be included when using GROUP_BY in Aggregation Expressions
  • Extensions to Cumulative Aggregations to support AVG & PERCENTAGE operators and GROUP_BY clauses
  • The MIN and MAX operators can be used in Aggregation Expressions

Full List of Changes

Key	Type	Description
AT-1844	Enhancement	✅ Enable "unbalanced groups" to be grouped using custom name
AT-1843	Bug	✅ Sorting fails in Pivot Layout with No Pivot Columns (Agg Cols only)
AT-1842	Enhancement	✅ Make server-side evaluation of AdaptableQL more flexible
AT-1840	Enhancement	✅ Add Weighted Average cell summary - using the Layout AggFunc
AT-1837	Bug	✅ Expression validation incorrectly fails when test data incomplete
AT-1833	Enhancement	✅ Remove Custom Reports from Export State
AT-1829	Enhancement	✅ Add the Type of Style to Format Column Summary wizard step
AT-1823	Bug	✅ Grid re-renders continuously when switching to a Pivot Layout
AT-1812	Enhancement	✅ Add Weighted Average scalar aggregation
AT-1809	Bug	✅ Adaptable crashes when closed during a pending async load operation
AT-1806	Enhancement	✅ Add Weighted Average Columns sections to a Layout
AT-1802	Bug	✅ 'On' Date Predicate doesnt evaluate to true for edited cells
AT-1799	Enhancement	✅ Add 'IsNotNumeric' Predicate
AT-1798	Bug	✅ Exclude Values Predicate doesn't work with more than one date
AT-1796	Bug	✅ Cell value of 0 doesn't work with Values & Exclude Values Predicates
AT-1795	Bug	✅ Clearing a number cell in AdapTable is treated as Zero in Predicates
AT-1790	Bug	✅ CalculatedColumn with an aggregated scalar value which depends on another CalculatedColumn is not always kept in sync
AT-1787	Enhancement	✅ Add Values (IN) Predicate to Conditional Style & Alert
AT-1785	Enhancement	✅ Re-order the steps in Calculated Column Wizard
AT-1784	Enhancement	✅ Ensure consistent use of AggFuncInHeader
AT-1783	Enhancement	✅ Update Grid when current Layout is updated via API
AT-1782	Enhancement	✅ Add Clear and Suspend buttons to Filter Toolbar, ToolPanel
AT-1781	Enhancement	✅ Make Column Filters suspendable
AT-1767	Enhancement	✅ Add support for multiple grouping in AggregatedScalar Expressions
AT-1763	Enhancement	✅ Add GROUP_BY to CUMUL expressions
AT-1750	Enhancement	✅ Add Cumulative Expression as a special type of Expression in UI
AT-1667	Enhancement	✅ Display Column Friendly Names in the Expression Editor
AT-1648	Enhancement	✅ Add a Column Search box in Expression Editor
AT-1546	Enhancement	✅ Add Alerts for Aggregated MIN & MAX
AT-1478	Enhancement	✅ Add support for cumulated aggregations to Average(AVG) and Percentage operators
AT-1327	Enhancement	✅ Create `VAR` AdapTableQL Expression Function which can read global variables (e.g. `userName`)
AT-1080	Enhancement	✅ Aggregation Expressions to react to changes in WHERE clause columns

Version 12.1 Change Log

Key	Type	Description
AT-1774	Task	✅ Update to latest version of react-toastify
AT-1766	Bug	✅ Layout suppressAggFuncInHeader is not working
AT-1765	Bug	✅ Error thrown when filtering for date in Filter Form searchbox
AT-1761	Bug	✅ Expand All and Collapse All events are ignored for Dynamic Row Groups
AT-1757	Bug	✅ Layout editor fails to display custom FriendlyNames
AT-1756	Bug	✅ CalculatedColumns with AggregatedScalar Expressions are not evaluated if provided in non-standard ways
AT-1753	Bug	✅ ExpandedRowGroups in Layouts don't re-open
AT-1745	Bug	✅ Expression Editor crashes when no data present in the grid
AT-1744	Study	✅ Make Quick Search as Query not use actual queries
AT-1740	Enhancement	✅ Add a Save button to Layout Status Bar control if autoSaveLayouts is false
AT-1739	Study	✅ Running Quick Search as Query is slow
AT-1738	Bug	✅ Running Quick Search as Query includes hidden columns
AT-1735	Enhancement	✅ Add Context to handler function in CustomDisplayFormatter
AT-1728	Bug	✅ Change Caption in Column Menu sometimes throws an error
AT-1726	Bug	✅ Values Filter is not updated when grid data changes
AT-1724	Bug	✅ Some Adaptable menu items do not include the Module
AT-1723	Bug	✅ Column Filters do not autorun if AutoSave Layout is set to False
AT-1722	Enhancement	✅ Save AG Grid Chart definitions in AdapTable State
AT-1717	Enhancement	✅ Add support for HTMLElements in AdaptableIcon
AT-1716	Bug	✅ DashboardButtons with custom internal icons are handled incorrectly
AT-1712	Study	✅ Replace Layout Editor with multi-step Wizard
AT-1711	Enhancement	✅ Add Column Filters info to Layout Summary in Settings Panel
AT-1707	Enhancement	✅ Handle special columns header tooltip consistently
AT-1705	Bug	✅ Inline Dashboard shows tabs dropdown when just 1 Tab provided
AT-1701	Enhancement	✅ Include Tagged Objects when Reference Sharing Layouts in Team Sharing
AT-1691	Bug	✅ Column Filter staying when quick filter bar text is cleared
AT-1690	Bug	✅ Date Filter working on wrong day
AT-1685	Enhancement	✅ Add support for dynamic icons
AT-1683	Enhancement	✅ Refresh custom dashboard buttons on button actions
AT-1681	Enhancement	✅ Add dynamic icon function to AdaptableButton
AT-1668	Task	✅ Add percentile / quartile / quintile etc. Aggregations to AdapTableQL
AT-1562	Enhancement	✅ Upgrade to stable version of react-daypicker
AT-1506	Task	✅ Update to Angular v12 & TypeScript v4.3.5
AT-1477	Enhancement	✅ Allow referencing other Calculated Columns in AggregatedScalar Expression
AT-325	Enhancement	✅ Log warning if AdaptableBlotterOptions contains unknown property

Version 12.0 Change Log

Key	Type	Description
AT-1679	Bug	✅ GridAPI getRowCount() incorrect when row added to grid but not datasource
AT-1671	Enhancement	✅ Add api method to remove a column from a Layout
AT-1669	Enhancement	✅ Improve Team Sharing API controls
AT-1666	Bug	✅ Add an API DeleteConditionalStyle method
AT-1664	Study	✅ Improve definition and public API for column types
AT-1662	Enhancement	✅ Give all Popovers consistent look and feel
AT-1661	Enhancement	✅ Add a function in AdaptableOptions to set Column Friendly Name
AT-1657	Enhancement	✅ Provide support for AG Grid v27.3.x
AT-1652	Enhancement	✅ Allow server evaluation for CalculatedColumns
AT-1645	Task	✅ Allow users to provide Custom FDC3 Columns
AT-1642	Task	✅ Replace DataSource in Config with improved DataSet (via Options)
AT-1639	Enhancement	✅ Allow users to provide custom format functions for Format Columns
AT-1605	Task	✅ Provide popup Form for Action Rows
AT-1604	Enhancement	✅ Move Column Filters into Layout State
AT-1603	Enhancement	✅ Remove requirement to reference ToolPanel Component when using Adaptable React or Angular
AT-1590	Enhancement	✅ Add Prefix and Suffix as options for String columns in Format column
AT-1589	Enhancement	✅ Enable Adaptable Objects to be scoped to particular Layout(s)
AT-1573	Bug	✅ Programmatic updates on custom toolbars are not handled correctly
AT-1569	Enhancement	✅ Provide FDC3 columns to broadcast and raise intents
AT-1545	Enhancement	✅ Enable special columns (Action, Freetext, Calculated) to be referenced in standard AG Grid column definitions
AT-1396	Task	✅ Allow devs to provide Custom Sections to display in Settings Panel
AT-1341	Task	✅ Make AdapTable content available in Status Bar
AT-1323	Enhancement	✅ Extend Action Columns to display multiple buttons
AT-1277	Enhancement	✅ Make button in Data Change History more configurable
AT-948	Enhancement	✅ Provide Action Rows - for Create, Edit (and buttons also for Clone, Delete)
AT-395	Enhancement	✅ Add column / context menu options to select and summarise a column