Knowledge base

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

Does Not Equal

Contains

Does Not Contain

Starts with

Ends with

Does Not Start with

Greater than

Less than

Between 

Not Between

Currency

Y

N

N

Y

Y

Date

Y

N

N

Y

Y

Email

Y

Y

Y

Y

Y

Number

Y

N

N

Y

Y

Percentage

Y

N

N

Y

Y

String

Y

Y

Y

Y

Y

Time

Y

N

N

Y

Y

Yes/No

Y

N

N

N

N

TOP-RATED

Experience Popdock.

Request 1:1 Demo

We're committed to your privacy. eOne Solutions, the creator of Popdock, uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Recorded Demo

We're committed to your privacy. eOne Solutions, the creator of Popdock, uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.