Types of filters

Contains

This filter type will remove records when the characters of the filter value can be found anywhere in the field value.

Does not contain

This filter type will remove records when the characters of the filter value are not found anywhere in the field value.

Equals

This filter type will remove records when the field value is exactly the same as the filter value.

Does not equal

This filter type will remove records when the field value is not exactly the same as the filter value.

Ends with

This filter type will remove records when the characters of the filter value can be found at the end of the field value.

Does not end with

This filter type will remove records when the characters of the filter value are not found at the end of the field value.

Starts with

This filter type will remove records when the characters of the filter value can be found at the start of the field value.

Does not start with

This filter type will remove records when the characters of the filter value are not found at the start of the field value.

Between

This filter type will remove records when the field value is between the first filter value and the second filter value.

Not between

This filter type will remove records when the field value is not between the first filter value and the second filter value.

Greater than

This filter type will remove records when the field value is greater than the filter value.

Greater than or equal to

This filter type will remove records when the field value is greater than or equal to the filter value.

Less than

This filter type will remove records when the field value is less than the filter value.

Less than or equal to

This filter type will remove records when the field value is less than or equal to the filter value.

One of list

This filter type will remove records when the field value is not one in the list.

Not one of list

This filter type will remove records when the field value is exactly the same as the value in the list.

 

Field types

Not all field types can use all filter types. The table below details which filter types are available for each field type.

Equals Contains Starts with Greater than Between
Does not equal Does not contain Ends with Less than Not Between
Does not start with
Currency
Date
Email
Number
Percentage
String
Time
Yes/no