The default value for this property is true, which matches Excel's behavior.

Set it to false to disable this behavior, so searching only affects which items are displayed on the list and not which items are included in the filter.

The filter is active if some values are selected and some are not. If all values are in the same state (either selected or un-selected), then the filter is not active.

Adding too many items to the list makes searching difficult and hurts performance. This property limits the number of items displayed at any time, but users can still use the search box to filter the items they are interested in.

The default value for this property is 250.

This code changes the value to 1,000,000, effectively listing all unique values for the field:

import { FlexGridFilter} from '@mescius/wijmo.grid.filter';

// change the maxItems property for the 'id' column:
let f = new FlexGridFilter(theGrid);
f.getColumnFilter('id').valueFilter.maxValues = 1000000;

For example, the code below sets up the ValueFilter for 'country' column to use Excel style wildcards

import { FlexGridFilter, ValueFilterSearchKind } from '@mescius/wijmo.grid.filter';
let filter = new FlexGridFilter(flex);
filter.getColumnFilter("country").valueFilter.searchType = ValueFilterSearchKind.Excel;

The default value for this property is ValueFilterSearchKind.Excel.

If the filter is not active, this property is set to null and all values present in the data source are shown on the list.

If the filter is active (the user selected some values from the list but not all), the showValues property is set to an object whose property names are the display values of the selected values.

For example, if the value list contains country names and the user selected "US" and "Japan", the showValues property returns:

{ Japan: true, US: true }

This property is especially useful when you are using the uniqueValues to provide a custom list of values property and you would like to preserve the order of the values.

If this property is set to null, the list will be filled based on the grid data.

Explicitly assigning the list of unique values is more efficient than building the list from the data, and is required for value filters to work properly when the data is filtered on the server (because in this case some values might not be present on the client so the list will be incomplete).

By default, the filter editor will sort the unique values when displaying them to the user. If you want to prevent that and show the values in the order you provided, set the sortValues property to false.

For example, the code below provides a list of countries to be used in the ValueFilter for the column bound to the 'country' field:

import { FlexGridFilter} from '@mescius/wijmo.grid.filter';

// create filter for a FlexGrid
let filter = new FlexGridFilter(grid);

// assign list of unique values to country filter
let cf = filter.getColumnFilter('country');
cf.valueFilter.uniqueValues = ['Austria', 'Belgium', 'Chile', 'Denmark'];