Version 21.2 Release Note

AdapTable 21.2 is a minor version release which supports AG Grid version 34.2.

The main area of focus in 21.2 is improvements to Quick Search, Column Filters, Export and AdapTableQL.

Quick Search

• Now leverages AG Grid's Find - users can provide custom implementations if desired
• Extended to Row Grouped Columns, Tree Grid Columns, Array Columns and Grouped Rows
• Still available in Server Side Row Model (via custom implementation)
• Quick Search can now be accessed via the AdapTable Status Bar and in Floating Mode
• Includes ability to configure 3 styles of matching cells (when "cycling" through results):

Property Name	Highlights	Default
CellMatchStyle	All Text in Matching Cells	none
TextMatchStyle	Matching text within Cell	Black Text, Yellow Background
CurrentTextMatchStyle	Matching text in current result Cell	Black Text, Orange Background

Tree Filter

• When filtering, AdapTable now provides a tree-like structure for 3 types of Columns:

  • For Date Columns (ie. columns with data cell type of date), but only when using the In Filter

  Hint

  • It is possible to display multiple entries in the Tree Filter for the same day, differing only by time
  • This is done by setting the evaluateInPredicateUsingTime property in Predicate Options to true

  • The "key" (i.e. the first) Column in a Tree Data Grid

  • A Row Grouped Column with multiple grouped columns (and RowGroupDisplayType is single)

Export

• Exporting via the API facilitates additional, advanced, configuration options
• Three Export-related items can be configured by developers using functions (and not just hard-coded lists):
  • Custom Destinations
  • System Reports
  • Report Formats

AdapTableQL

• Three Relative Change Expression Functions have been added to AdapTableQL
• Each function evaluates the relative nature of a data change:

Function	When Evaluates as True
ANY_CHANGE	Any change at all between old and new value
PERCENT_CHANGE	If new value changes by a given percent amount
ABSOLUTE_CHANGE	If new value changes by a given absolute amount

• These are leveraged by the new Relative Change Alerts and Flashing Cells

Array Columns

• A new Array Type has been introduced which can be used in:
  • Multiple different Badge Styles
  • Sparkline Columns
  • Array-based Column Filtering

Badge Style

• AdapTable now supports Icon-only Badge Styles
• These enable users to replace all text in a cell with a single image

Change Log

Key	Type	Description
AT-3194	Enhancement	✅ Add ANY_CHANGE Expression Function
AT-3193	Enhancement	✅ Add ABSOLUTE_CHANGE Expression Function
AT-3192	Enhancement	✅ Add PERCENT_CHANGE Expression Function
AT-3189	Enhancement	✅ Use the Tree Filter in Tree Grid Key Columns
AT-3188	Enhancement	✅ Use the Tree Filter in Date Columns
AT-3187	Enhancement	✅ Use the Tree Filter in Row Group Key Columns
AT-3182	Enhancement	✅ Add ability to constrain width of the Filter Form
AT-3181	Bug	✅ Filtering not working in Agg-only Pivot Layouts
AT-3180	Enhancement	✅ Update Weighted Average Aggregation to take account of filters
AT-3152	Enhancement	✅ Provide raw value to custom Predicate definitions
AT-3077	Enhancement	✅ Create a Tree-like Filter
AT-3049	Enhancement	✅ Add ability to create Icon-only Badge Styles
AT-3015	Enhancement	✅ Add Quick Search panel to Status Bar
AT-3012	Enhancement	✅ Add support for Different Badge Styles in Array Columns
AT-3009	Enhancement	✅ Enable Custom Destinations, System Reports and Report Formats to be provided as functions
AT-2999	Enhancement	✅ Support Quick Search in Server Side Row Model
AT-2948	Enhancement	✅ Add configuration support to ExportApi methods
AT-2941	Enhancement	✅ Update Quick Search to leverage AG Grid's new Find
AT-2898	Enhancement	✅ Refactor Quick Search Options
AT-2873	Enhancement	✅ Extend Quick Search to Tree Columns (in Tree Grid)
AT-2742	Task	✅ Enable relative change Expression Functions
AT-2363	Enhancement	✅ Allow devs to provide a bespoke Quick Search implementation
AT-2033	Enhancement	✅ Extend Quick Search to Row Grouped Columns