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 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 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 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 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.
  • 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.

Comments
0
Add comment