Version 9 Developer Release Note

Version 9 of Adaptable was released in July 2021.

Module Changes

• Cell Validation and Updated Row have been merged into Alerts
• Gradient Column and Percent Bar are now available in Format Column
• A new Checkbox Column style present for Format Column (since removed in AdapTable 16)

Module Improvements

• Alerts can now be triggered by Obsevable and Aggregation expressions
• Alerts can include Actions and Notifications can display buttons
• Format Column Rules can use Expressions
• Export provides a new Visual Data report which is WYSIWYG

AdaptableRX

• AdapTableQL now offers Reactive-type functionality
• Observable Expressions - which react to changes in data (either per row or for grid)
• Aggregation Expressions - provide a way to sum numeric columns and then query them
• WHERE clause enables data set used in the Expression to be limited
• QUERY function allows a Named Query to be used as an Expression argument

Team Sharing

• Updated to include Active Sharing - in addition to Snapshot Sharing
• Referenced Sharing added so that objects with other objects are recursively shared

New Adaptable Options Sections

• Dashboard Options
• Entitlements Options
• Menu Options
• Tool Panel Options

New Adaptable Events

• Adaptable State Changed - Any state changes in Adaptable
• Cell Changed - Any cell in AdapTable is updated (either by user or ticking data)
• Dashboard Changed - Any change is made to Dashboard toolbars, visibility, or mode
• Row Changed - The rows collection is changed in the Grid's Data Source
• Layout Changed - A Layout changes
• System Status Message Displayed - A System Status message is shown
• Team Shared Entity Changed - An Active Shared Entity in Team Sharing has changed

AdapTable Angular

• Only one Component is required: ag-grid-angular
• This receives an AdaptableOptions object as an extra property

UI Improvements

• Adaptable Form - can be dynamically generated when required (used in Custom Destinations & Alerts)
• Adaptable Button - replaces other buttons in Adaptable (used in Action Column, Dashboard & Alerts)
• Wizard has been changed to be vertical and is more intuitive with context-sensitivie instructions
• Numeric Cell Editor will be used when Adaptable when editing a numeric cell
• New configurable Date Picker will be used when editing Date cells and in Filter components

Change Logs

Version	Release Date	AG Grid Compatibility
9.1	2021-08-31	>= 25.3.0
9.0	2021-07-14	>= 25.2.0

9.1 Release

Key	Type	Description
AT-1194	Bug	✅ Error when exporting Grouped Data
AT-1193	Bug	✅ Error when exporting Visual Data Report
AT-1192	Bug	✅ Error when opening ipushpull demo
AT-1191	Enhancement	✅ Add ExcludeGroupedRows check for Conditional Style automatic upgrade
AT-1190	Bug	✅ IsSuspended Toggle button not displaying in Angular Wrapper
AT-1189	Bug	✅ Toast notifications not displaying in Angular Wrapper
AT-1187	Bug	✅ Remove 'Close' button from Dashboard Toolbar (in Inline View)
AT-1185	Enhancement	✅ Add a 'Suspend' Action for Alerts
AT-1179	Documentation	✅ Update Entitlements documentation
AT-1172	Enhancement	✅ Log to Console when updating old Predefined Config
AT-1168	Bug	✅ Free Text Column doesnt refresh the last cell after a Bulk Update
AT-1167	Enhancement	✅ Refresh row after editing column which is referenced in a Column Comparison
AT-1166	Enhancement	✅ Add Dashboard Context Menu item
AT-1165	Enhancement	✅ Add "Clear Selection" Context Menu option
AT-1164	Enhancement	✅ Add option to hide column when row-grouping on it
AT-1158	Enhancement	✅ Make functions button in the Expression Editor a dropdown button
AT-1157	Enhancement	✅ Make the Between Filter show the 2 boxes vertically
AT-1156	Task	✅ Allow users to provide their own Quick Filter on per-column basis
AT-1155	Task	✅ Allow Live Adaptable Objects to be suspended
AT-1154	Bug	✅ Cannot Export to Excel if a dot in column name
AT-1151	Task	✅ Allow users to provide their own Filter Form on per-column basis
AT-1149	Bug	✅ A provided defaultGroupSortComparator gets overriden
AT-1146	Enhancement	✅ Dashboard should allow Floating / Hiding / Collapsing when ReadOnly
AT-1145	Bug	✅ Column Menu doesnt work for Grouped Column in Charting
AT-1142	Bug	✅ OpenFin crashes if referenced but plugin not provided
AT-1139	Bug	✅ Query performance noticeably slower when row is grouped
AT-1138	Task	✅ Add ipushpull ToolPanel (to match ipushpull Toolbar)
AT-1137	Task	✅ Add OpenFin ToolPanel (to match OpenFin Toolbar)
AT-1136	Enhancement	✅ Use the new listbox chooser in Dashboard
AT-1135	Enhancement	✅ Show Adaptable Column and Context menus in Grouped Columns
AT-1134	Enhancement	✅ Change the icon for Export button
AT-1132	Task	✅ Refactor ToolPanel and Toolbar to use same code
AT-1131	Enhancement	✅ Add ability to provide custom buttons to ToolPanel
AT-1130	Enhancement	✅ Use the new listbox chooser in Tool Panel Config
AT-1129	Bug	✅ Export Destination property is being reset
AT-1128	Bug	✅ React warning when using column comparison in Gradient Style Format Column
AT-1126	Bug	✅ The "Clear Alerts" button needs to be pressed multiple times
AT-1125	Bug	✅ Changing plugin order causes side-effects
AT-1124	Bug	✅ Opening Alerts Panel triggers a React warning in the console
AT-984	Enhancement	✅ Add ability to create Custom Tool Panels
AT-917	Task	✅ Enable all Adaptable Objects to be suspended (without need to delete/create)
AT-689	Task	✅ Ensure Entitlements behave appropriately for all Modules

9.0 Release

Key	Type	Description
AT-1114	Enhancement	✅ Allow Calculated Columns to reference other Calculated Columns in Expressions
AT-1102	Enhancement	✅ Add Date buttons to Date Picker
AT-1095	Task	✅ Add a 'source' for Adaptable Objects in State - config or user
AT-1089	Enhancement	✅ Create a 'Current Data' System Report to export only data in the Grid
AT-1088	Enhancement	✅ Rename 'Visible Data' to 'Visual Data' and make it always return styles
AT-1087	Task	✅ Upgrade to ag-Grid 25.3.0
AT-1085	Enhancement	✅ Add Event when an Active Team Shared Entity has updated
AT-1084	Study	✅ Use external Grid for when need to show Tabular Data
AT-1079	Enhancement	✅ Move CheckBox Columns into Format Column as a ColumnStyle
AT-1067	Bug	✅ Selecting 2 filter types in quick filter dropdown reverts to default type - not 2nd one
AT-1066	Bug	✅ Wrong message appearing when deleting a custom report via Export Toolbar
AT-1065	Enhancement	✅ Dashboard item is duplicated in the main Functions menu
AT-1064	Enhancement	✅ Add custom caption component to Datepicker to allow easy navigation for years
AT-1061	Enhancement	✅ Add option to allow switching between exporting Display / Raw cell values
AT-1060	Study	✅ Add Weighted Average aggregation in Finance plugin
AT-1058	Study	✅ See if can make Team Sharing 'Live'
AT-1057	Task	✅ Enable Team Sharing of 'Complex' objects
AT-1055	Enhancement	✅ Refactor Wizard to display steps vertically
AT-1054	Enhancement	✅ Use Vertical Wizard for Alerts
AT-1053	Enhancement	✅ Add new string AdapTableQL functions: LEN, UPPER, LOWER, CONCAT
AT-1048	Enhancement	✅ Create new event for when rows are added / deleted from the grid
AT-1047	Enhancement	✅ Rename GridDataChanged Event to CellChanged
AT-1046	Documentation	✅ Rename 'Functions' as Modules in Documentation
AT-1045	Enhancement	✅ Add ability to exclude grouped rows from action columns
AT-1044	Task	✅ Move Calendar from a Strategy to an Option
AT-1043	Enhancement	✅ Merge Predicate and Query into a Rule property in Plus Minus
AT-1042	Enhancement	✅ Merge Predicate and Query into a Rule property in Alert
AT-1041	Enhancement	✅ Merge Predicate and Query into a Rule property in Conditional Style
AT-1040	Enhancement	✅ Enable users to turn on / off flashing for a column through column menu
AT-1039	Enhancement	✅ Provide way for users to remove Flashing Alerts which have not timeframe
AT-1036	Enhancement	✅ Add a QUERY function to AdapTableQL
AT-1035	Task	✅ Make it easier to share / reuse Queries
AT-1034	Bug	✅ Adaptable Menus doesnt appear if its a Grouped Column
AT-1031	Enhancement	✅ Add presets for common numeric Format Columns
AT-1028	Enhancement	✅ Replace DualListBoxEditor and Column Chooser with single component
AT-1026	Enhancement	✅ Integrate Adaptable Filter Form better into Filter Tool Panel
AT-1025	Task	✅ Move Custom Export Destinations from Predefined Config to Export Options
AT-1024	Enhancement	✅ Refactor Plus Minus to use either Predicate or Query
AT-1023	Task	✅ Move Entitlements from Predefined Config to Adaptable Options
AT-1022	Enhancement	✅ Ensure that a DataType is provided for a Calculated Column
AT-1021	Bug	✅ Fix Add All button not working in DualListBoxEditor
AT-1018	Enhancement	✅ Move Column & Context Menus from Predefined Config into Menu Options
AT-1017	Enhancement	✅ Provide date picker editor for date columns
AT-1016	Enhancement	✅ Provide numeric cell editor for numeric columns
AT-1014	Enhancement	✅ Assign cell editor automatically for FreeTextColumn datatype
AT-1013	Enhancement	✅ Add a data type property to Free Text Columns
AT-1009	Enhancement	✅ Add aggregated Alerts
AT-1008	Enhancement	✅ Add historical Alerts
AT-1007	Enhancement	✅ Add time-based Alerts
AT-1006	Enhancement	✅ Alert should use either Predicate or Query (but not both) - like Conditional Style
AT-1005	Task	✅ Merge Query, Search and Filter Options together
AT-1003	Enhancement	✅ Merge all the different buttons used in AdapTable into one common object
AT-1000	Task	✅ Refactor LayoutUpdated event into LayoutChanged
AT-999	Task	✅ Enable React Wrapper to show Custom Toolbars via Framework Components
AT-998	Enhancement	✅ Enable ReadOnly Cells to be styled
AT-997	Enhancement	✅ Add BorderColor to Adaptable Style
AT-996	Enhancement	✅ Enable Editable Cells to be styled
AT-992	Documentation	✅ Create automated documentation for all Redux Action names
AT-990	Enhancement	✅ Only check Bulk Edit & Smart Edit selection if visible
AT-988	Study	✅ Refactor Chart-related code from core to plugin
AT-987	Task	✅ Make sure all Redux Actions are consistently named
AT-986	Study	✅ Replace Audit Log with new AuditStateChanged Event
AT-985	Study	✅ Merge Flashing Cells and Updated Rows into Alerts
AT-983	Documentation	✅ Add page on Framework Components to Documentation
AT-982	Task	✅ Remove ValidationFailed Event (as now covered by AlertFired)
AT-981	Task	✅ Refactor ToolbarVisibilityChanged event into DashboardChanged
AT-980	Enhancement	✅ Make Dashboard non-configurable if Entitlement is 'ReadOnly'
AT-977	Enhancement	✅ Refactor Action Columns to use Adaptable (Form) buttons
AT-976	Documentation	✅ Add Custom Toolbars page to Angular Wrapper documentation
AT-974	Task	✅ Refactor Angular Wrapper to be more naturally Angular
AT-973	Enhancement	✅ Update Custom Destination Form to use Form Buttons
AT-972	Task	✅ Improve debugging in AdapTable
AT-967	Enhancement	✅ Add Support for Boolean Columns in Quick Filter
AT-939	Enhancement	✅ Refactor Adaptable Events args / info objects
AT-936	Task	✅ Replace browser date picker with themable 3rd party component
AT-811	Bug	✅ Flashing Cell timers are not destroyed properly
AT-785	Enhancement	✅ Add checks for Columns in Expressions when deleting special columns
AT-777	Enhancement	✅ Add Query ToolPanel
AT-745	Enhancement	✅ Add option to include a Close button in each Toolbar
AT-744	Enhancement	✅ Add option to stack toolbars in dashboard
AT-737	Enhancement	✅ Add option to remove Alert cell colouring when Alert no longer required
AT-722	Study	✅ Provide an auto-generated Primary Key if one cannot be provided
AT-679	Enhancement	✅ Add time-based & historical functions to Parser
AT-661	Enhancement	✅ Agree a common UI Look and Feel for wizard screens
AT-604	Enhancement	✅ Add option to choose between Formatted Value and Raw Value data changes
AT-603	Enhancement	✅ Enable Flashing Cell for non numeric columns
AT-546	Task	✅ Remove deprecated React methods
AT-514	Enhancement	✅ Run reports on 'background' thread
AT-459	Enhancement	✅ Provide error handling and proper messages when state fails
AT-444	Enhancement	✅ Add Option to fire Alert if no / wrong PK Column
AT-434	Enhancement	✅ Add ability in Export Options to select a destination