The SimpleOperators object contains operators to use when filtering data.

NameData TypeDescription
beginsWithEnumerationSearches for values that begin with the specified string.
betweenEnumerationMatches values that occur between the two specified values.
containsEnumerationMatches values that contain the specified value.
endsWithEnumerationMatches values that end with the specified value.
equalsEnumerationSearches for values that are equal to a given value.
existsInStringEnumerationMatches values that contain specified value within a string.
existsInStringAsAWordEnumerationSearches for values that exist within a string as a word.
greaterThanEnumerationSpecifies that one numeric value is greater than another.
greaterThanAnniversaryEnumerationSpecifies a date value occurs after a given anniversary date.
greaterThanOrEqualEnumerationSearches for values greater than or equal to a specified value.
INEnumerationSearches for values in the specified list. You can include multiple IN values in a filter part.
isAnniversaryEnumerationSearches for a date value that exists as an anniversary of an event.
isNotAnniversaryEnumerationSearches for values that are not the anniversary of a given data value.
isNotNullEnumerationSearches for a value that is not null.
isNullEnumerationSearches for a null value.
lessThanEnumerationSearches for a value less than a specified value.
lessThanAnniversaryEnumerationSearches for date values that occur before a given anniversary date.
lessThanOrEqualEnumerationSearches for a value less than or equal to a given value.
likeEnumerationSpecifies a string of characters to find in a larger string. This property automatically appends percent signs to the beginning and end of the Like value.
notContainsEnumerationSearches for a value that does not contain a specific value.
notEqualsEnumerationSearches for a value that does not equal a specified value.
notExistsInStringEnumerationSearches for values that don't contain a specific value within a string.

Use these operators when building filters for most objects.

  • equals
  • notEquals
  • greaterThan
  • lessThan
  • isNull
  • isNotNull
  • greaterThanOrEqual
  • lessThanOrEqual
  • between
  • IN
  • like

The following operators work only for the DataFilter property:

  • existsInString
  • existsInStringAsAWord
  • notExistsInString
  • beginsWith
  • endsWith
  • contains
  • notContains
  • isAnniversary
  • isNotAnniversary
  • greaterThanAnniversary
  • lessThanAnniversary

The IN property evaluates to True if the value of the specified property is in the specified list.