Version 15 Release Note

Summary

  • The Release Note outlines the key features and updates in Version 15 of AdapTable
  • It was released in February 2023 and supports AG Grid version 29

Breaking Change

Functionality Changes

  • New COUNT function to be used in Aggregation Expressions
  • Footers can be exported to Excel when running the Visual Data Report" link="
  • Columns can be set to be excluded from Reports
  • New System Destination for Export of Table
  • Extra Filter Bar Wildcards can be provided (or existing ones removed)

UI Changes

  • Custom Themes can be created in the UI (using the Theme Wizard)
  • The Alert Wizard has an improved set of steps, to make it easier to create an Alert
  • Suspend All / Unsuspend All button toggle been added to the Settings Panel

CSS Styles

AG Grid v.29 has made some important changes to how it manages styling.

One important consequence is that the styles import path has to be updated.

Previously (assuming you are using Balham theme and wanted both light and dark) you would do:

import '@ag-grid-community/core/dist/styles/ag-grid.css';
import '@ag-grid-community/core/dist/styles/ag-theme-balham.css';
import '@ag-grid-community/core/dist/styles/ag-theme-balham-dark.css';

Now the styles are imported as:

import 'ag-grid-enterprise/styles/ag-grid.css';
import 'ag-grid-enterprise/styles/ag-theme-balham.css';

Note

In AG Grid 29 the dark and light themes have been merged into one file

This requires an additional AG Grid import - for the styles:

Terminal
npm install @ag-grid-community/styles

Team Sharing

  • It is now possible to share custom object structures and values

    Note

    This means you can share any data and not solely standard Adaptable Objects like FormatColumns, Layouts, etc.

  • The state management functions have been updated and extended with 4 new functions which allow complex customised state management configurations and customisations:

    • loadSharedEntities
    • applySharedEntities
    • persistSharedEntities
    • saveSharedEntities

Hint

These 4 functions mirror exactly those used to save Adaptable State remotely

Breaking Change

  • Previously getSharedEntities and setSharedEntities were used to save and fetch data into Team Sharing
  • These 2 functions have now been removed from Team Sharing Options
Deep Dive

Understanding the new Team Sharing Functions

Code Changes

  • Many Adaptable API functions have been updated to reference the IRowNode interface (instead of RowNode)
  • New agGridContainerName property in Charting Options to re-name AG Grid window
  • New isColumnExportable property in Export Options to set which Columns are exported in System Reports

Events

TypeScript Generics

  • AdapTable now supports TypeScript Generics for Adaptable Options
  • This allows for improved type safety and developer experience just by providing the row data type to the Adaptable Options definition

Hint

This integrates seamlessly with the AG Grid TypeScript Generics for Row Data

Documentation Changes

Change Logs

AdapTable VersionRelease DateAG Grid Compatibility
15.4June 2023AG Grid v.29.3.0
15.3May 2023AG Grid v.29.3.0
15.2April 2023AG Grid v.29.2.0
15.1March 2023AG Grid v.29.1.0
15.0February 2023AG Grid v.29.0.0

Version 15.4 Change Log

KeyTypeDescription
AT-2208Bug✅ Timezone issues when exporting Visual Data Report
AT-2203Enhancement✅ Add Vertical Alignment property to Cell Text on Percent Bar
AT-2202Bug✅ Edit Layout menu item opens New Layout wizard
AT-2201Enhancement✅ Show Column's Caption (not ColumnId) in Layout Editor
AT-2198Bug✅ Aggregated data (using AG Grid agg funcs) are not displayed correctly for Aggregated Calculated Columns
AT-2191Enhancement✅ Add ServerValidationContext to validateOnServer function
AT-2172Enhancement✅ Use Format Columns when showing cell value in Percent Bar

Version 15.3 Change Log

KeyTypeDescription
AT-2184Bug✅ Preprocessed 'All Data' Report not exported correctly for CSV and Clipboard
AT-2180Enhancement✅ Remove Items property from Dashboard Config
AT-2174Enhancement✅ Add Ceiling, Floor, Round and Abs to Format Column
AT-2173Bug✅ Filter Bar crashes if Permitted Values function returns empty array
AT-2171Bug✅ Quick Filter Debounce creates strange effect when typing in Filter
AT-2169Bug✅ Cannot reselect values in Filter Bar Values Filter when trigger is Click
AT-2168Task✅ Support AG Grid 29.3
AT-2166Enhancement✅ Make Adaptable Column Types available in Details Grids
AT-2165Enhancement✅ Add Master Grid Node / Data to DetailInitContext
AT-2164Enhancement✅ Add 'Export Selected Rows' method to Context Menu
AT-2161Enhancement✅ Hide Adaptable Tool Panel if Entitlement is hidden
AT-2157Enhancement✅ Add Scope to SystemPredicatesContext
AT-2145Task✅ Make some functions private in partner api classes

Version 15.2 Change Log

KeyTypeDescription
AT-2156Enhancement✅ Show only supported columns in column sort wizard
AT-2148Enhancement✅ Add support for exporting ServerSideRowModel data
AT-2147Bug✅ Server Report with Table Destination renders invalid headers
AT-2140Study✅ Support nested Master Detail grids
AT-2138Enhancement✅ Add option to set Values Filter to width of column
AT-2136Enhancement✅ Add option to run Quick Search on grouped rows
AT-2135Bug✅ Close button doesn't work in No Code wizard
AT-2134Task✅ Support AG Grid 29.2
AT-2131Enhancement✅ Refactor how Quick Filter caches column values
AT-2129Bug✅ Filter values are NOT updated on DataSet change
AT-2127Enhancement✅ Remove RangeSelection Module requirement to provide selected row info
AT-2125Bug✅ Clear Custom Sort's Order values when Column is changed
AT-2119Bug✅ Flashing Cells are not clearing
AT-2107Enhancement✅ Improve loading custom theme warning
AT-2098Enhancement✅ Change Theme Window button to dropdown with Light & Dark options
AT-1153Enhancement✅ Add Option to Percent Bar to show cell value on top of the Bar

Version 15.1 Change Log

KeyTypeDescription
AT-2143Enhancement✅ Consolidate GridApi `setGridData()` and `loadGridData()` methods
AT-2137Enhancement✅ Add option to suppress override config warning in Team Sharing
AT-2128Enhancement✅ Add optional info property to the DataSet object
AT-2123Task✅ Support AG Grid 29.1
AT-2122Enhancement✅ Add option to show count in Values Filter
AT-2116Enhancement✅ Add / remove Adaptable Objects from current Layout
AT-2115Enhancement✅ Add support for array columns in MIN, MAX, AVG & COALESCE functions
AT-2113Enhancement✅ Add ROUND mathematical function to AdaptableQL
AT-2112Enhancement✅ Add FLOOR mathematical function to AdaptableQL
AT-2111Enhancement✅ Add CEILING mathematical function to AdaptableQL
AT-2110Enhancement✅ Add ABS mathematical function to AdaptableQL
AT-2108Enhancement✅ Add NULL literal to AdaptableQL
AT-2106Enhancement✅ Improve ReadOnly Layout behaviour

Version 15.0 Change Log

KeyTypeDescription
AT-2101Task✅ Enrich Team Sharing functions to mirror those used in State Options
AT-2100Enhancement✅ Update Team Sharing to facilitate sharing bespoke objects
AT-2099Enhancement✅ Allow users to select / add Quick Filter wildcards
AT-2097Bug✅ Zero Filter is returning true for null values
AT-2093Enhancement✅ Add support for TeamSharing state hydration/customisation
AT-2085Enhancement✅ Increase width of Alert Header and Message in Wizard
AT-2080Enhancement✅ Show Theme Description in Theme Status Bar
AT-2076Enhancement✅ Allow exporting row group footers to Visual Report
AT-2073Enhancement✅ Jump to Style Step when editing Styled Column from Column Menu
AT-2067Enhancement✅ Create Chart Changed Event
AT-2066Enhancement✅ Add Table as a new Export Destination
AT-2057Study✅ Update to AG Grid 29
AT-2051Task✅ Refactor Alert Wizard to better show different Alert types
AT-2023Enhancement✅ Memoise Row Node lookups
AT-2012Enhancement✅ Make DashboardChanged Event easier to use
AT-1912Enhancement✅ Add TypeScript generics to AdaptableOptions
AT-1751Task✅ Add a Suspend / Unsuspend All toggle in Settings Panel
AT-1746Enhancement✅ Add 'COUNT' AggregatedBoolean function
AT-1693Enhancement✅ Add Exportable Columns
AT-1359Study✅ Add options to change some elements of the theme at run-time