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
- There are no breaking changes in Version 15 to Initial Adaptable State which all works as previously
- However AG Grid styles need to be imported differently
- Functions in Team Sharing have been improved to facilitate advanced sharing use cases
Functionality Changes
- New
COUNTfunction 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:
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:
loadSharedEntitiesapplySharedEntitiespersistSharedEntitiessaveSharedEntities
Hint
These 4 functions mirror exactly those used to save Adaptable State remotely
Breaking Change
- Previously
getSharedEntitiesandsetSharedEntitieswere 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
IRowNodeinterface (instead of RowNode) - New
agGridContainerNameproperty in Charting Options to re-name AG Grid window - New
isColumnExportableproperty in Export Options to set which Columns are exported in System Reports
Events
- New Chart Changed Event which fires when Chart state changes
- The Dashboard Changed Event has been improved
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
- Added the ability to see each Demo in AdapTable React and AdapTable Angular (as well as Vanilla)
- Many more Videos added
- Updated Charting and Team Sharing documentation
Change Logs
| AdapTable Version | Release Date | AG Grid Compatibility |
|---|---|---|
| 15.4 | June 2023 | AG Grid v.29.3.0 |
| 15.3 | May 2023 | AG Grid v.29.3.0 |
| 15.2 | April 2023 | AG Grid v.29.2.0 |
| 15.1 | March 2023 | AG Grid v.29.1.0 |
| 15.0 | February 2023 | AG Grid v.29.0.0 |
Version 15.4 Change Log
| Key | Type | Description |
|---|---|---|
| AT-2208 | Bug | ✅ Timezone issues when exporting Visual Data Report |
| AT-2203 | Enhancement | ✅ Add Vertical Alignment property to Cell Text on Percent Bar |
| AT-2202 | Bug | ✅ Edit Layout menu item opens New Layout wizard |
| AT-2201 | Enhancement | ✅ Show Column's Caption (not ColumnId) in Layout Editor |
| AT-2198 | Bug | ✅ Aggregated data (using AG Grid agg funcs) are not displayed correctly for Aggregated Calculated Columns |
| AT-2191 | Enhancement | ✅ Add ServerValidationContext to validateOnServer function |
| AT-2172 | Enhancement | ✅ Use Format Columns when showing cell value in Percent Bar |
Version 15.3 Change Log
| Key | Type | Description |
|---|---|---|
| AT-2184 | Bug | ✅ Preprocessed 'All Data' Report not exported correctly for CSV and Clipboard |
| AT-2180 | Enhancement | ✅ Remove Items property from Dashboard Config |
| AT-2174 | Enhancement | ✅ Add Ceiling, Floor, Round and Abs to Format Column |
| AT-2173 | Bug | ✅ Filter Bar crashes if Permitted Values function returns empty array |
| AT-2171 | Bug | ✅ Quick Filter Debounce creates strange effect when typing in Filter |
| AT-2169 | Bug | ✅ Cannot reselect values in Filter Bar Values Filter when trigger is Click |
| AT-2168 | Task | ✅ Support AG Grid 29.3 |
| AT-2166 | Enhancement | ✅ Make Adaptable Column Types available in Details Grids |
| AT-2165 | Enhancement | ✅ Add Master Grid Node / Data to DetailInitContext |
| AT-2164 | Enhancement | ✅ Add 'Export Selected Rows' method to Context Menu |
| AT-2161 | Enhancement | ✅ Hide Adaptable Tool Panel if Entitlement is hidden |
| AT-2157 | Enhancement | ✅ Add Scope to SystemPredicatesContext |
| AT-2145 | Task | ✅ Make some functions private in partner api classes |
Version 15.2 Change Log
| Key | Type | Description |
|---|---|---|
| AT-2156 | Enhancement | ✅ Show only supported columns in column sort wizard |
| AT-2148 | Enhancement | ✅ Add support for exporting ServerSideRowModel data |
| AT-2147 | Bug | ✅ Server Report with Table Destination renders invalid headers |
| AT-2140 | Study | ✅ Support nested Master Detail grids |
| AT-2138 | Enhancement | ✅ Add option to set Values Filter to width of column |
| AT-2136 | Enhancement | ✅ Add option to run Quick Search on grouped rows |
| AT-2135 | Bug | ✅ Close button doesn't work in No Code wizard |
| AT-2134 | Task | ✅ Support AG Grid 29.2 |
| AT-2131 | Enhancement | ✅ Refactor how Quick Filter caches column values |
| AT-2129 | Bug | ✅ Filter values are NOT updated on DataSet change |
| AT-2127 | Enhancement | ✅ Remove RangeSelection Module requirement to provide selected row info |
| AT-2125 | Bug | ✅ Clear Custom Sort's Order values when Column is changed |
| AT-2119 | Bug | ✅ Flashing Cells are not clearing |
| AT-2107 | Enhancement | ✅ Improve loading custom theme warning |
| AT-2098 | Enhancement | ✅ Change Theme Window button to dropdown with Light & Dark options |
| AT-1153 | Enhancement | ✅ Add Option to Percent Bar to show cell value on top of the Bar |
Version 15.1 Change Log
| Key | Type | Description |
|---|---|---|
| AT-2143 | Enhancement | ✅ Consolidate GridApi `setGridData()` and `loadGridData()` methods |
| AT-2137 | Enhancement | ✅ Add option to suppress override config warning in Team Sharing |
| AT-2128 | Enhancement | ✅ Add optional info property to the DataSet object |
| AT-2123 | Task | ✅ Support AG Grid 29.1 |
| AT-2122 | Enhancement | ✅ Add option to show count in Values Filter |
| AT-2116 | Enhancement | ✅ Add / remove Adaptable Objects from current Layout |
| AT-2115 | Enhancement | ✅ Add support for array columns in MIN, MAX, AVG & COALESCE functions |
| AT-2113 | Enhancement | ✅ Add ROUND mathematical function to AdaptableQL |
| AT-2112 | Enhancement | ✅ Add FLOOR mathematical function to AdaptableQL |
| AT-2111 | Enhancement | ✅ Add CEILING mathematical function to AdaptableQL |
| AT-2110 | Enhancement | ✅ Add ABS mathematical function to AdaptableQL |
| AT-2108 | Enhancement | ✅ Add NULL literal to AdaptableQL |
| AT-2106 | Enhancement | ✅ Improve ReadOnly Layout behaviour |
Version 15.0 Change Log
| Key | Type | Description |
|---|---|---|
| AT-2101 | Task | ✅ Enrich Team Sharing functions to mirror those used in State Options |
| AT-2100 | Enhancement | ✅ Update Team Sharing to facilitate sharing bespoke objects |
| AT-2099 | Enhancement | ✅ Allow users to select / add Quick Filter wildcards |
| AT-2097 | Bug | ✅ Zero Filter is returning true for null values |
| AT-2093 | Enhancement | ✅ Add support for TeamSharing state hydration/customisation |
| AT-2085 | Enhancement | ✅ Increase width of Alert Header and Message in Wizard |
| AT-2080 | Enhancement | ✅ Show Theme Description in Theme Status Bar |
| AT-2076 | Enhancement | ✅ Allow exporting row group footers to Visual Report |
| AT-2073 | Enhancement | ✅ Jump to Style Step when editing Styled Column from Column Menu |
| AT-2067 | Enhancement | ✅ Create Chart Changed Event |
| AT-2066 | Enhancement | ✅ Add Table as a new Export Destination |
| AT-2057 | Study | ✅ Update to AG Grid 29 |
| AT-2051 | Task | ✅ Refactor Alert Wizard to better show different Alert types |
| AT-2023 | Enhancement | ✅ Memoise Row Node lookups |
| AT-2012 | Enhancement | ✅ Make DashboardChanged Event easier to use |
| AT-1912 | Enhancement | ✅ Add TypeScript generics to AdaptableOptions |
| AT-1751 | Task | ✅ Add a Suspend / Unsuspend All toggle in Settings Panel |
| AT-1746 | Enhancement | ✅ Add 'COUNT' AggregatedBoolean function |
| AT-1693 | Enhancement | ✅ Add Exportable Columns |
| AT-1359 | Study | ✅ Add options to change some elements of the theme at run-time |