ConditionOperator EnumType

Describes the type of comparison in a condition expression.

Members

Members define the discrete options for the enumeration type.

Name Value Description
Equal 0 The values are compared for equality.
NotEqual 1 The two values are not equal.
GreaterThan 2 The value is greater than the compared value.
LessThan 3 The value is less than the compared value.
GreaterEqual 4 The value is greater than or equal to the compared value.
LessEqual 5 The value is less than or equal to the compared value.
Like 6 The character string is matched to the specified pattern.
NotLike 7 The character string does not match the specified pattern.
In 8 The value exists in a list of values.
NotIn 9 The given value is not matched to a value in a subquery or a list.
Between 10 The value is between two values.
NotBetween 11 The value is not between two values.
Null 12 The value is null.
NotNull 13 The value is not null.
Yesterday 14 The value equals yesterday's date.
Today 15 The value equals today's date.
Tomorrow 16 The value equals tomorrow's date.
Last7Days 17 The value is within the last seven days including today.
Next7Days 18 The value is within the next seven days.
LastWeek 19 The value is within the previous week including Sunday through Saturday.
ThisWeek 20 The value is within the current week.
NextWeek 21 The value is within the next week.
LastMonth 22 The value is within the last month including first day of the last month and last day of the last month.
ThisMonth 23 The value is within the current month.
NextMonth 24 The value is within the next month.
On 25 The value is on a specified date.
OnOrBefore 26 The value is on or before a specified date.
OnOrAfter 27 The value is on or after a specified date.
LastYear 28 The value is within the previous year.
ThisYear 29 The value is within the current year.
NextYear 30 The value is within the next year.
LastXHours 31 The value is within the last X hours.
NextXHours 32 The value is within the next X (specified value) hours.
LastXDays 33 The value is within last X days.
NextXDays 34 The value is within the next X (specified value) days.
LastXWeeks 35 The value is within the last X (specified value) weeks.
NextXWeeks 36 The value is within the next X weeks.
LastXMonths 37 The value is within the last X (specified value) months.
NextXMonths 38 The value is within the next X (specified value) months.
LastXYears 39 The value is within the last X years.
NextXYears 40 The value is within the next X years.
EqualUserId 41 The value is equal to the specified user ID.
NotEqualUserId 42 The value is not equal to the specified user ID.
EqualBusinessId 43 The value is equal to the specified business ID.
NotEqualBusinessId 44 The value is not equal to the specified business ID.
ChildOf 45 For internal use only.
Mask 46 The value is found in the specified bit-mask value.
NotMask 47 The value is not found in the specified bit-mask value.
MasksSelect 48 For internal use only.
Contains 49 For an attribute enabled for full-text indexing: the string contains another string.
DoesNotContain 50 The string does not contain another string.
EqualUserLanguage 51 The value is equal to the language for the user.
NotOn 52 For internal use only.
OlderThanXMonths 53 The value is older than the specified number of months.
BeginsWith 54 The string occurs at the beginning of another string.
DoesNotBeginWith 55 The string does not begin with another string
EndsWith 56 The string ends with another string.
DoesNotEndWith 57 The string does not end with another string.
ThisFiscalYear 58 The value is within the current fiscal year .
ThisFiscalPeriod 59 The value is within the current fiscal period.
NextFiscalYear 60 The value is within the next fiscal year.
NextFiscalPeriod 61 The value is within the next fiscal period.
LastFiscalYear 62 The value is within the last fiscal year.
LastFiscalPeriod 63 The value is within the last fiscal period.
LastXFiscalYears 64 The value is within the last X (specified value) fiscal periods.
LastXFiscalPeriods 65 The value is within the last X (specified value) fiscal periods.
NextXFiscalYears 66 The value is within the next X (specified value) fiscal years.
NextXFiscalPeriods 67 The value is within the next X (specified value) fiscal period.
InFiscalYear 68 The value is within the specified year.
InFiscalPeriod 69 The value is within the specified fiscal period.
InFiscalPeriodAndYear 70 The value is within the specified fiscal period and year.
InOrBeforeFiscalPeriodAndYear 71 The value is within or before the specified fiscal period and year.
InOrAfterFiscalPeriodAndYear 72 The value is within or after the specified fiscal period and year.
EqualUserTeams 73 The record is owned by teams that the user is a member of.
EqualUserOrUserTeams 74 The record is owned by a user or teams that the user is a member of.
Under 75 Returns all child records below the referenced record in the hierarchy.
NotUnder 76 Returns all records not below the referenced record in the hierarchy.
UnderOrEqual 77 Returns the referenced record and all child records below it in the hierarchy.
Above 78 All records in referenced record's hierarchical ancestry line.
AboveOrEqual 79 The referenced record and all records above it in the hierarchy.
EqualUserOrUserHierarchy 80 When hierarchical security models are used, Equals current user or their reporting hierarchy.
EqualUserOrUserHierarchyAndTeams 81 When hierarchical security models are used, Equals current user and his teams or their reporting hierarchy and their teams.
OlderThanXYears 82 The value is older than the specified number of years.
OlderThanXWeeks 83 The value is older than the specified number of weeks.
OlderThanXDays 84 The value is older than the specified number of days.
OlderThanXHours 85 The value is older than the specified number of hours.
OlderThanXMinutes 86 The value is older than the specified number of minutes.
ContainValues 87 The choice value is one of the specified values.
DoesNotContainValues 88 The choice value is not one of the specified values.
EqualRoleBusinessId 89 The value is equal to the role's business ID.

Used by

The following use the ConditionOperator EnumType.

Name How used
ConditionExpression Operator Property

See also