Column filter dialog box

The Column Filter dialog box configures the column filter.

  1. Parameters
  2. Column

Parameters

Defines the parameters to use in the column filter.

Column type

Displays the name of the column you put a filter on. Selects the type of filter that should be applied to this column and configures it.

Note: The list of possible filters depends on the column content type.
Note: For all text filters, you can also specify whether they should be case-sensitive or case-insensitive.
Always accepted
All column values are accepted.
Equal to

Value should be equal to the target one.

Note: Appears with numerical columns.
Not equal to

Value should be not equal to the target one.

Note: Appears with numerical columns.
Less than

Value should be less than the target one.

Note: Appears with numerical columns.
Greater than

Value should be greater than the target one.

Note: Appears with numerical columns.
Less than or equal to

Value should be less than or equal to the target one.

Note: Appears with numerical columns.
Between

Value should be in the given range, both ends excluded.

Note: Appears with numerical columns.
Not in range

Value should not be in the given range, both ends excluded.

Note: Appears with numerical columns.
Exactly matches

The content of the column should exactly match the target one.

Note: Appears with columns containing text.
Does not match

The content of the column should be different from the target one.

Note: Appears with columns containing text.
Starts with

The content of the column should start with the given text.

Note: Appears with columns containing text.
Does not start with

The content of the column should not start with the given text.

Note: Appears with columns containing text.
Ends with

The content of the column should end with the given text.

Note: Appears with columns containing text.
Does not end with

The content of the column should not end with the given text.

Note: Appears with columns containing text.
Contains

The content of the column should contain the given text.

Note: Appears with columns containing text.
Does not contain

The content of the column should not contain the given text.

Note: Appears with columns containing text.
Matches pattern

The content of the column should match the given wildcard template.

Note: Appears with columns containing text.
Does not match pattern

The content of the column should not match the given wildcard template.

Note: Appears with columns containing text.
Included in

The content of the column should be in the given set of values.

Note: Appears with columns containing text and numerical columns.
Not included in

The content of the column should not be in the given set of values.

Note: Appears with columns containing text and numerical columns.