Salesforce Docs Portal

SimpleOperators

Contains operators to use when filtering data.

Properties

Name Data Type Description
beginsWith Enumeration Searches for values that begin with the specified string.
between Enumeration Matches values that occur between the two specified values.
contains Enumeration Matches values that contain the specified value.
endsWith Enumeration Matches values that end with the specified value.
equals Enumeration Searches for values that are equal to a given value.
existsInString Enumeration Matches values that contain specified value within a string.
existsInStringAsAWord Enumeration Searches for values that exist within a string as a word.
greaterThan Enumeration Specifies that one numeric value is greater than another.
greaterThanAnniversary Enumeration Specifies a date value occurs after a given anniversary date.
greaterThanOrEqual Enumeration Searches for values greater than or equal to a specified value.
IN Enumeration Searches for values in the specified list. You can include multiple IN values in a filter part.
isAnniversary Enumeration Searches for a date value that exists as an anniversary of an event.
isNotAnniversary Enumeration Searches for values that aren't the anniversary of a given data value.
isNotNull Enumeration Searches for a value that isn't null.
isNull Enumeration Searches for a null value.
lessThan Enumeration Searches for a value less than a specified value.
lessThanAnniversary Enumeration Searches for date values that occur before a given anniversary date.
lessThanOrEqual Enumeration Searches for a value less than or equal to a given value.
like Enumeration Specifies 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.
notContains Enumeration Searches for a value that doesn't contain a specific value.
notEquals Enumeration Searches for a value that doesn't equal a specified value.
notExistsInString Enumeration Searches for values that don't contain a specific value within a string.

Filter Operators

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.