Filter Operators

Filter Operators

Below are the different Operators available when you try using filters.

Text Operators

Operator	Description
is blank	Field value is empty.
is not blank	Field value isn’t empty.
equal to	Field value is equal to comparison value. Case insensitive. Example: Cat is equal to cat.
not equal to	Field value isn't equal to comparison value. Case insensitive. Example: Cat is not equal to cat.
contains	Comparison value is a subset of field value. Case insensitive. Example: Cat contains AT.
contains (case sensitive)	Comparison value is a subset of field value. Example: Cat contains at.
does not contain	Comparison value isn't a subset of field value. Case insensitive. Example: Cat does not contain dog.
does not contain (case sensitive)	Comparison value isn't a subset of field value. Example: Cat does not contain AT.
starts with	Comparison value is a subset of field value, and the first character of the field value matches the first character of the comparison value. Case insensitive. Example: Cat starts with ca.
starts with (case sensitive)	Comparison value is a subset of field value, and the first character of the field value matches first character of comparison value. Example: Cat starts with Ca.
ends with	Comparison value is a subset of field value, and the last character of the field value matches the last character of comparison value. Case insensitive. Example: Cat ends with AT.
ends with (case sensitive)	Comparison value is a subset of field value, and the last character of the field value matches the last character of the comparison value. Example: Cat ends with at.
greater than	Field value comes before the comparison value in alphabetical order. This operator compares alphabetic sort order, not length. Case insensitive. Example: Cat is greater than dog.
greater than or equal to	Field value is the same as or comes before the comparison value in alphabetical order. This operator compares alphabetic sort order, not length. Case insensitive. Examples: Cat is greater than or equal to dog. Dog is greater than or equal to dog.
less than	Field value comes after comparison value in alphabetical order. This operator compares alphabetic sort order, not length. Case insensitive. Example: Dog is less than cat.
less than or equal to	Field value is the same as or comes after the comparison value in alphabetical order. This operator compares alphabetic sort order, not length. Case insensitive. Examples: Dog is less than or equal to cat. Cat is less than or equal to cat.

Currency and Numeric Operators

Operator	Description
equal to	Field value is equal to comparison value. Example: 123 is equal to 123.
not equal to	Field value isn't equal to comparison value. Example: 12 is not equal to 123.
greater than	Field value is greater than comparison value. Example: 321 is greater than 123.
greater than or equal to	Field value is greater than or equal to comparison value. Examples: 321 is greater than or equal to 123. 123 is greater than or equal to 123.
less than	Field value is less than comparison value. Example: 12 is less than 123.
less than or equal to	Field value is less than or equal to comparison value. Examples: 12 is less than or equal to 123. 123 is less than or equal to 123.

Date Operators

Operator	Description
is blank	Field value is empty.
is not blank	Field value isn't empty.
equal to	Date value is equal to comparison value.
not equal to	Date value isn't equal to comparison value.
greater than	Date value is later than comparison value. Example: 10/20/2016 is greater than 05/20/2016.
greater than or equal to	Date value is later than or equal to comparison value. Examples: 10/20/2016 is greater than or equal to 10/20/2016. 10/20/2016 is greater than or equal to 05/20/2016.
less than	Date value is before comparison value. Example: 05/20/2016 is less than 10/20/2016.
less than or equal to	Date value is before or equal to comparison value. Examples: 10/20/2016 is less than or equal to 10/20/2016. 05/20/2016 is less than or equal to 10/20/2016.

Boolean Operators

Operator	Description
equal to	Field value is equal to the comparison value. For True, select the Comparison Value check box. For False, clear theComparison Value check box.
not equal to	Field value isn't equal to the comparison value. For True, clear the Comparison Value check box. For False, select theComparison Value check box.
is blank	Field value is empty. Represents False.
is not blank	Field value isn't empty. Represents True.

Single Instance and Multi-Instance Operators

Field Type	Operator	Usage
Single Instance	in the selection list	Comparison value is one of the possible field values. Example: A is in the selection list A, B, C.
Single Instance	not in the selection list	Comparison value isn't one of the possible field values. Example: D is not in the selection list A, B, C.
Multi-Instance	any in the selection list	Field value is one of the possible comparison values.
Multi-Instance	none in the selection list	Field value isn't one of the possible comparison values.
Single Instance Multi-instance	is empty	Field value is blank.
Single Instance Multi-instance	is not empty	Field value isn't blank.
Single Instance Multi-instance	count is equal to	The number of field values is equal to the comparison value. Example: To view workers with 2 dependents, set a filter for Dependents where count is equal to a Comparison Value of 2.
Single Instance Multi-instance	count is not equal to	The number of field values isn't equal to the comparison value. Example: To view workers with dependents, set a filter for Dependents where count is not equal to a Comparison Value of zero.
Single Instance Multi-instance	count is greater than	The number of field values is greater than the comparison value. Example: To view workers with more than 1 dependent, set a filter for Dependents where count is greater than a Comparison Value of 1.
Single Instance Multi-instance	count is greater than or equal to	The number of field values is greater than or equal to the comparison value. Example: To view workers with 1 or more dependent, set a filter for Dependents where count is greater than or equal to a Comparison Value of 1.
Single Instance Multi-instance	count is less than	The number of field values is less than the comparison value. Example: To view workers with fewer than 2 dependents, set a filter for Dependents where count is less than a Comparison Value of 2.
Single Instance Multi-instance	count is less than or equal to	The number of field values is less than or equal to the comparison value. Example: To view workers with 2 or fewer dependents, set a filter for Dependents where count is less than or equal to a Comparison Value of 2.
Single Instance Multi-instance	exact match with selection list	Field value matches exactly with comparison value. For single instance fields, this operator restricts a prompt so that it accepts a single value only. To enable a prompt for a single instance field to accept multiple values, use in the selection list.
Single Instance Multi-instance	subset of the selection list	Field value is a subset of the comparison value. Blank field values are a subset of the comparison values.
Single Instance Multi-instance	superset of the selection list	Comparison value is a subset of the field value. Blank comparison values are a subset of the field values.
Single Instance Multi-instance	NOT exact match with selection	Field value doesn’t exactly match the comparison value.
Single Instance Multi-instance	NOT subset of the selection list	Field value isn’t a subset of the comparison value. Blank field values are a subset of the comparison values.
Single Instance Multi-instance	NOT superset of the selection list	Comparison value isn’t a subset of the field value. Blank comparison values are a subset of the field values.