Comparison types

The following comparison types are available for filters: 

• Equal to. The result includes the records where the field value is equal to the specified value.
• Not Equal. The result includes the records where the field value is not equal to the specified value.
• Less than. The result includes the records where the field value is less than the specified value.
• Less than or equal to. The result includes the records where the field value is less than or equal to the specified value.
• Greater than. The result includes the records where the field value is greater than the specified value.
• Greater than or equal to. The result includes the records where the field value is greater than or equal to the specified value.
• In list. The result includes the records where the field value is present in the specified list. To create a list, click the selection button in the Value column.
• In the list group. The result includes the records where the field value is present in the specified list or in a group that is present in the specified list.
• In group. The result includes the records where the field value is present in a group that is present in the specified list.
• Not in the list. The result includes the records where the field value is absent from the specified list. To create a list, click the selection button in the Value column.
• Not in the list group. The result includes the records where the field value is absent from the specified list or from a group that is present in the specified list.
• Not in the group. The result includes the records where the field value is absent from a group that is present in the specified list.
• Contains. The result includes the records that contain the field value as a substring.
• It does not contain. The result includes the records that do not contain the field value as a substring.
• Filled. The result includes the records where the field is filled.

• Not filled. The result includes the records where the field is blank.

• Begins with. The result includes the records where the field value begins with the specified string.
• Does not begin with. The result includes the records where the field value does not begin with the specified string.
• Like. The result includes the records where the field value matches the specified template.
• Not like. The result includes the records where the field value does not match the specified template.

The templates use the following syntax:

• / (slash mark) designates that the following character is a regular character.
• % (percent) stands for any number of any characters.
• _ (underscore) stands for any single character.