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.

‍