ConditionOperator Enum

Definition

Describes the type of comparison for two values (or expressions) in a condition expression.

public enum class ConditionOperator
[System.Runtime.Serialization.DataContract(Name="ConditionOperator", Namespace="http://schemas.microsoft.com/xrm/2011/Contracts")]
public enum ConditionOperator
[<System.Runtime.Serialization.DataContract(Name="ConditionOperator", Namespace="http://schemas.microsoft.com/xrm/2011/Contracts")>]
type ConditionOperator = 
Public Enum ConditionOperator
Inheritance
ConditionOperator
Attributes

Fields

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 (specified value) hours.

NextXHours 32

The value is within the next X (specified value) hours.

LastXDays 33

The value is within last X (specified value) 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 (specified value) 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 (specified value) years.

NextXYears 40

The value is within the next X (specified value) 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

The string contains another string.

You must use the Contains operator for only those columns that are enabled for full-text indexing. Otherwise, you will receive a generic SQL error message while retrieving data. In Dataverse, only the columns of the KBArticle (article) table are enabled for full-text indexing.

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 X (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 fiscal 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

Returns all records in referenced record's hierarchical ancestry line.

AboveOrEqual 79

Returns 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 X (specified number) of years.

OlderThanXWeeks 83

The value is older than X (specified number) of weeks.

OlderThanXDays 84

The value is older than X (specified number) of days.

OlderThanXHours 85

The value is older than X (specified number) of hours.

OlderThanXMinutes 86

The value is older than X (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

For internal use only.

Examples

filter.AddCondition("accountid", ConditionOperator.Equal, _accountIdArray[j]);

Applies to

See also