Support
Release Notes

Version 7 Developer Release Note

Version 7 of Adaptable was released in September 2020.

AG Grid

  • Support for AG Grid Version 23
  • Support for AG Alpine Theme
  • Support for Master-Detail Grids (as a Plugin)

Layouts

  • New Edit Layout screen to replace the Layout wizard
  • Layouts include Aggregations and Column Widths
  • New LayoutChangedEvent to fire whenever a Layout changes

AdapTableQL

  • New custom built expression syntax
  • Will be used in Calculated Columns (replacing math.js)
  • Comes with an intuive Expression Editor
  • New Query Module which allows for run-time querying
  • Named Queries allow for Queries to be saved and re-used

Filters and Predicates

  • Introduction of a new Predicate object for boolean use cases
  • Are evaluated by AdapTableQL also
  • Used in Filters, Format Columns and Alerts
  • Developers can provide Custom Predicate definitions
  • Major usability improvements to Filter Form and Filter Bar

Scope

  • New construct which defines where an Object can be used
  • Possibilities are: Everywhere, Column(s), DataType(s)
  • Available in Format Column, Alert, Export

Percent Bar Improvements

  • Can now include a set of Ranges
  • Alternatively you can use a Column Comparison
  • Other properties to show column values, tooltips etc

New Partner Integration Plugins

  • ipushpull
  • Glue42
  • OpenFin
  • Finsemble

AdapTable React Changes

  • AgGridReact Component now needs to be rendered explicitly
  • AG Grid Enterprise Modules should be be passed as an input
  • Theming is now set explicitly (and not via prop) by wrapping component in a div
  • Tool Panel Component needs to be explicitly imported and referenced

AdapTable Angular Changes

  • ag-grid-angular Component now needs to be provided explicitly
  • AG Grid Enterprise Modules should be be passed as an input
  • onAdaptableReady input replaced by an AdaptableReady event
  • Tool Panel Component needs to be explicitly imported and referenced

Other Improvements

  • Constructor is now asynchronous, returning Adaptale API via a promise
  • All schedule-state related state is now stored in Schedule Config
  • Export allows users to provide Custom Reports and Custom Export Destinations
  • semantic class names were added to all UI elements to facilitate custom styling
  • The size of the Adaptable Package has decreased by 30%

Change Logs

VersionDate ReleasedAG Grid Compatibility
7.42021-01-26>= 24.1.0
7.32021-01-04>= 24.1.0
7.22020-11-19>= 24.1.0
7.12020-11-11>= 24.0.0
7.02020-09-20>= 23.2.1

7.4 Release

KeyTypeDescription
AT-907Enhancement✅ Container Options should allow adaptable div to be provided as HTML Element as well as by name
AT-905Enhancement✅ Make OpenFin toolbar available in Dashboard (when using OpenFin)
AT-903Bug✅ Column Groups get flattened when a layout loads
AT-902Bug✅ Layout editor only allows Drag n Drop into columns that are visible when it opens
AT-901Enhancement✅ Add option to not show groups when no columns are visible
AT-900Enhancement✅ Add more State type and Destination Options to Manage State function
AT-898Enhancement✅ Make list of Functions available in Expression Editor configurable
AT-897Bug✅ Conditional Style classnames dont work if scope is whole row
AT-894Task✅ Look at adding an IsReadOnly property to base Adaptable Object class
AT-893Enhancement✅ Make PrimaryKeyDuplicate only way to prevent duplicates (remove Options property)
AT-892Enhancement✅ Create 'Existing Values Only' predicate for Alert and Validation
AT-891Enhancement✅ Create 'No Duplicate Values' predicate for Alert and Validation
AT-890Enhancement✅ Add IncludeStyleWhenExportToExcel option to Export Options
AT-889Enhancement✅ Include Adaptable styles when exporting Visible Data to Excel
AT-888Enhancement✅ Add Option to open Quick Filter dropdown on click (default to remain mouseover)
AT-887Enhancement✅ Add an 'Any_Contains' Expression function - similar to how Quick Search works
AT-878Enhancement✅ Add Option to run a Query straight after Quick Search is run
AT-807Enhancement✅ Allow users to provide list of Queryable columns (for running Expressions remotely)
AT-806Enhancement✅ Allow developers to provide custom AdapTableQL functions
AT-802Enhancement✅ Add substring() AdapTableQL function
AT-775Enhancement✅ Add Column Group support in Layout Editor
AT-209Bug✅ If groupMultiAutoColumn is true, Pivot Layout reverses columns when loading

7.3 Release

KeyTypeDescription
AT-885Enhancement✅ Add a separator in Column Menu before Adaptable Menu Items
AT-884Task✅ Merge ColumnInfo and GridInfo Functions into one - no need for 2
AT-883Enhancement✅ Add Configure Dashboard Column Menu Item
AT-882Enhancement✅ Put all Dashboard related column menu items into one sub-menu
AT-881Task✅ Enable Adaptable Menu Items to contain sub menus
AT-880Bug✅ Filter on Cell Value context menu option should filter on cell's normalised, not display, value
AT-879Bug✅ Remove Save as User Filter button in Filter popup as no longer used
AT-877Enhancement✅ Add CSS variable for Menu Item in Filter form
AT-876Enhancement✅ Enable a default predicate for each Column Data Type
AT-875Bug✅ Calculated Columns cannot display string values
AT-874Enhancement✅ Capitalise Tooltips in Team Share window
AT-873Enhancement✅ Add Render Notification function to OpenFin options
AT-869Enhancement✅ Remove requirement to provide the ColumnTypes array at start-up
AT-868Bug✅ Grid flickers when a new column is added after other columns have loaded
AT-867Enhancement✅ Provide API methods to hide / show Dashboard Custom Buttons
AT-866Enhancement✅ Provide API methods to hide / show Custom Toolbar Buttons
AT-865Bug✅ Selected Cell Info is wrong if context menu clicked very quickly
AT-864Task✅ Add Release section to Documentation
AT-863Enhancement✅ Allow alternative names to be provided for Functions
AT-862Bug✅ Row Groupings are being passed between Layouts
AT-861Task✅ Refactor and improve Audit Log messages
AT-860Bug✅ Reports are not exporting Columns in Order defined in Scope
AT-859Bug✅ Cannot change selected column order in Scope Component Wizard
AT-856Task✅ Create a standalone OpenFin demo app
AT-855Enhancement✅ Allow OpenFin notifications to be enhanced at design-time
AT-854Bug✅ Cell Renderer is removed from a Calculated Column after edit
AT-853Enhancement✅ Add option to provide an icon for Application - will appear in Grid top corner
AT-850Enhancement✅ Remove span from Button generated in Action Column
AT-825Enhancement✅ Reduce amount of times SearchChanged event is fired
AT-818Bug✅ Export looks strange for columns with a checkbox
AT-814Enhancement✅ Create GridDataChanged Event to fire when data edits or ticks
AT-813Bug✅ EditLookUp Column fails when not using All Enterprise Modules
AT-753Enhancement✅ Format Column - show example of a negative number in Wizard Summary
AT-751Enhancement✅ Show current Format Column properties in the Editor (and not defaults as they can override)
AT-511Enhancement✅ Add ability to show Alerts in OpenFin notification area
AT-263✅ Copy and paste in grid ignores Cell Validation
AT-247AG Grid general✅ Styles in agGrid which reference a Css class name dont get cleared when style is deleted

7.2 Release

KeyTypeDescription
AT-858Enhancement✅ Include ADD_DAYS and DATE_DIFF functions to AdapTableQL
AT-849Enhancement✅ Add Debounce State Delay property to State Options
AT-846Enhancement✅ Add Custom Destinations to Schedule Popup
AT-841Enhancement✅ LayoutUpdated event should fire also when a Layout is created and deleted
AT-840Bug✅ Empty values appearing as NaN in Calculated Column
AT-839Enhancement✅ Add a Coalesce function to AdapTableQL
AT-833Task✅ Improve how ClearStorage works in Config Api
AT-832Enhancement✅ Add 'Clear Storage' function to User State functions
AT-823Bug✅ Last value in Column Filter list doesnt appear when scrolling
AT-822Enhancement✅ Update Custom Reports to send back data as ReportData object
AT-820Task✅ Improve JSON export destination so its proper JSON
AT-817Task✅ Add Option to include Primary Key column when exporting
AT-815Enhancement✅ Create dynamic forms - initially to use in Export Custom Destinations
AT-812Enhancement✅ Allow order of sections in Column and Context Menus to be configurable
AT-809Enhancement✅ Make the word 'Search' in the Quick Search input box configurable
AT-782Task✅ Refactor how distinct values are fetched for a Column
AT-776Enhancement✅ Cache distinct values in Filter Form

7.1 Release

KeyTypeDescription
AT-848Enhancement✅ Refactor ServerSearchOptions to be an Array
AT-847Bug✅ BatchUpdateRowData is not triggering Alerts
AT-845Enhancement✅ Add brief documentation for each AdapTableQL function in the Expression UI
AT-844Enhancement✅ Disable 'Select Shared Query' button in UI if no Shared Queries are in State
AT-843Enhancement✅ Allow AdapTableQL to accept dates as strings
AT-842Bug✅ Calculated Columns appear as name_1 in certain circumstances
AT-838Bug✅ Error thrown when opening Query editor if no data in the Grid
AT-837Enhancement✅ Scrollbars in Filter Form are too intrusive
AT-836Enhancement✅ Add new ipushpull page to Toolbar dropdown as soon as its been created
AT-835Task✅ Move AdapTable documentation to docs.adaptabletools.com
AT-834Enhancement✅ Add 'Log to Console' as an Alert Option
AT-831Bug✅ Grouping fails in Calculated Columns for new Layouts
AT-830Bug✅ Row Styles don't work after Version 7 Upgrade
AT-829Enhancement✅ Add 'data-name' attribute to UI elements where missing
AT-828Enhancement✅ Between Predicate should include the bound values
AT-827Bug✅ Blanks and Non-Blanks Predicates sometimes fail
AT-826Bug✅ Percent Bar UI fails if no values currently in column
AT-824Enhancement✅ Only fire SearchChanged when a valid Column Filter has been created
AT-821Task✅ Upgrade to ag-Grid v.24
AT-819Task✅ Refactor exported data into Report Data object that can easily referenced
AT-816Enhancement✅ Allow Percent Bars to be based off other column values
AT-800Enhancement✅ Use normalised cell values in Parser
AT-798Bug✅ Export Selected Rows is exporting 0 as empty cell
AT-796Bug✅ Export Selected Cells doesnt work if column header has full stop
AT-794Bug✅ A grouped cell doesnt unflash
AT-793Enhancement✅ Add Option to show distinct values using current column sort order
AT-792Enhancement✅ Add Custom Destination in Export
AT-789Bug✅ Cannot create Calculated Column if grid has no data
AT-787Enhancement✅ Save a Layout changed in Layout Editor even if AutoSave is false
AT-786Enhancement✅ Enhance popup which appears when deleting Object with a referenced column
AT-783Enhancement✅ Make Create New Layout more flexible
AT-759Bug✅ Cannot enter a new Date into Bulk Update Toolbar
AT-599Enhancement✅ Normalize dropdowns/selects (just use one and make it more 'styleable')
AT-494Enhancement✅ Add Tooltips to Calculated Columns

7.0 Release

KeyTypeDescription
AT-769Bug✅ System Date Filters dont work with undefined or null values
AT-764Enhancement✅ Add Custom Reports facility for Export
AT-763Enhancement✅ Add a Grid Api Export to Excel method
AT-762Bug✅ Flashing cell not working for edits
AT-758Bug✅ Cannot Create Percent Bar through Column Info
AT-755Bug✅ Custom sort breaks when try to edit a Custom Sort which uses a comparer function
AT-754Study✅ New Expression Parser
AT-752Bug✅ Median Calculation Issue
AT-750Enhancement✅ Allow Editing of Special Columns - but not the ColumnId property
AT-749Enhancement✅ Prevent deletion of Special Columns if referenced elsewhere
AT-748Task✅ Remove Column Chooser function as replaced by Layout Editor
AT-746Bug✅ Quick Search doesnt search on a column that is not in layout when it opens
AT-741Enhancement✅ Add option to make the Label property of a User Menu Item a function
AT-740Enhancement✅ Make User Menu label settable by a function
AT-736Enhancement✅ Enable default column width for a Calculated Column to be set
AT-733Enhancement✅ Create ipushpull plugin
AT-732Enhancement✅ Create Glue42 plugin
AT-731Enhancement✅ Create Finsemble plugin
AT-730Enhancement✅ Create OpenFin plugin
AT-729Bug✅ Column Width is not displayed when opening a layout at startup
AT-718Enhancement✅ Add support for Angular 9
AT-717Task✅ Add support for ag-Grid version 23
AT-699Enhancement✅ Layout: save pivoting details
AT-692Enhancement✅ Layout: Add AutoSave property to Layout (and not just options)
AT-662Bug✅ ToolPanels have a fixed width so look wrong when toolpanel is dragged
AT-653Enhancement✅ Add DataType scope to Conditional Style
AT-543Task✅ Integrate Master / Detail into Adaptable Blotter
AT-433Enhancement✅ Implement multiple Ranges for Percent Bar
AT-381Study✅ Create Shared Queries functionality
AT-259Bug✅ Calculated Column creation / edit breaks grouping and sorting
AT-155Enhancement✅ Make the editor for Calculated Columns more user friendly
PreviousVersion 8NextRoad Map