Named Filters Demo

The Adaptable Blotter has a range of powerful filter functions. These include Column Filters, System Filters and User Filters (that users create at run-time) and in most cases are sufficient for all needs.

But occasionally you might want to filter a column based on other data in the row or using internal logic not available to the Grid or even using an external lookup.

This is where Named Filters come in. You can create at design time a Named Filter and provide the Blotter the Predicate function required to evaluate it.

Named Filters operate either on a Single Column or all Columns of a particular DataType (e.g. Data): provide the Name of the Predicate in Named Filters section of Config, and the actual Predicate in Advanced Options.

In this example we created 3 Named Filters and associated Predicate Functions: (1) High on OrderId Column that evaluates based on data in Invoiced and ItemCount columns; (2) New Starter on Employee column which mimics a lookup to an internal CRM system (and which is also a column filter); and (3) Post Takeover which operates on all Date columns and evaluates true if date in cell was after a putative takeover date.

Adaptable Blotter Help Resources: User Guide - Predefined Config - Blotter API - FAQ - Videos.