We are working hard to make updates to the Shop and Account Management portal.

Please note that many of these changes will roll out this Saturday, June 1st and will require downtime. We are working to ensure minimal disruption for our eOne community and really appreciate your patience as we push out these changes. Please reach out to sales@eonesolutions.com with any questions.

Filter Restriction Types

Filter Restriction Types

This article describes the filter restriction types and what fields can be used with them.

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 restriction types are available for each field type.

ColorCurrencyDateDropdown ListEmailFileGUIDImageNumberPercentagePhoneQuantitySkypeStringTextTimeTime SpanTwitterWebsiteYes/No
ContainsXXXXXXXXXXXContains
Does Not ContainXXXXXXXXXXDoes Not Contain
EqualsXXXXXXXXXXXXXXXXXXXXEquals
Does Not EqualXXXXXXXXXXXXXXXXXXXXDoes Not Equal
Ends WithXXXXXXXXEnds With
Does Not End WithXXXXXXXXDoes Not End With
Starts WithXXXXXXXXStarts With
Does Not Start WithXXXXXXXXDoes Not Start With
BetweenXXXXXXXXXXXXXXBetween
Not BetweenXXXXXXXXXXXXXXNot Between
Greater ThanXXXXXXXXXXXXXXXXXGreater Than
Greater Than or Equal ToXXXXXXXXXXXXXXXXXGreater Than or Equal To
Less ThanXXXXXXXXXXXXXXXXXLess Than
Less Than or Equal ToXXXXXXXXXXXXXXXXXLess Than or Equal To
One of ListXXXXXXXXXXXXOne of List
Not One of ListXXXXXXXXXXXXNot One of List
ColorCurrencyDateDropdown ListEmailFileGUIDImageNumberPercentagePhoneQuantitySkypeStringTextTimeTime SpanTwitterWebsiteYes/No
Content
Field types

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters