System Filters Demo

AdapTable provides a range of useful System Filters (e.g. 'Blanks', 'Zero', 'Yesterday') to complement any User Filters or Named Filters provided by you.

They appear in italics at the top of the Column Filter form (above individual column values) and can also be used when creating Queries.

By default all System Filters will be shown. However in Sytem Filter State, you can stipulate to show none (by passing in an empty array) or to select just those that you want.

In this example we have stipulated that just 2 System Filters are used: Positive and Zero (both for Number columns) and then used it on 'Order Chg.' column.

Generating dummy data, please wait ...