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

Above 78

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

AboveOrEqual 79

Returns the referenced record and all records above it in the hierarchy. Value = 78.

BeginsWith 54

The string occurs at the beginning of another string. Value = 54.

Between 10

The value is between two values. Value = 10.

ChildOf 45

For internal use only.

Contains 49

The string contains another string. Value = 49.

You must use the Contains operator for only those attributes that are enabled for full-text indexing. Otherwise, you will receive a generic SQL error message while retrieving data. In a Microsoft Dynamics 365 default installation, only the attributes of the KBArticle (article) entity are enabled for full-text indexing.

ContainValues 87
DoesNotBeginWith 55

The string does not begin with another string. Value = 55.

DoesNotContain 50

The string does not contain another string. Value = 50.

DoesNotContainValues 88
DoesNotEndWith 57

The string does not end with another string. Value = 57.

EndsWith 56

The string ends with another string. Value = 56.

Equal 0

The values are compared for equality. Value = 0.

EqualBusinessId 43

The value is equal to the specified business ID. Value = 43.

EqualUserId 41

The value is equal to the specified user ID. Value = 41.

EqualUserLanguage 51

The value is equal to the language for the user. Value = 51.

EqualUserOrUserHierarchy 80

When hierarchical security models are used, Equals current user or their reporting hierarchy. Value = 80.

EqualUserOrUserHierarchyAndTeams 81

When hierarchical security models are used, Equals current user and his teams or their reporting hierarchy and their teams. Value = 81.

EqualUserOrUserTeams 74

The record is owned by a user or teams that the user is a member of. Value = 74.

EqualUserTeams 73

The record is owned by teams that the user is a member of. Value = 73.

GreaterEqual 4

The value is greater than or equal to the compared value. Value = 4.

GreaterThan 2

The value is greater than the compared value. Value = 2.

In 8

TheThe value exists in a list of values. Value = 8.

InFiscalPeriod 69

The value is within the specified fiscal period. Value = 69.

InFiscalPeriodAndYear 70

The value is within the specified fiscal period and year. Value = 70.

InFiscalYear 68

The value is within the specified year. Value = 68.

InOrAfterFiscalPeriodAndYear 72

The value is within or after the specified fiscal period and year. Value = 72.

InOrBeforeFiscalPeriodAndYear 71

The value is within or before the specified fiscal period and year. Value = 71.

Last7Days 17

The value is within the last seven days including today. Value = 17.

LastFiscalPeriod 63

The value is within the last fiscal period. Value = 63.

LastFiscalYear 62

The value is within the last fiscal year. Value = 62.

LastMonth 22

The value is within the last month including first day of the last month and last day of the last month. Value = 22.

LastWeek 19

The value is within the previous week including Sunday through Saturday. Value = 19.

LastXDays 33

The value is within last X days. Value = 33.

LastXFiscalPeriods 65

The value is within the last X (specified value) fiscal periods. Value = 65.

LastXFiscalYears 64

The value is within the last X (specified value) fiscal periods. Value = 0x40.

LastXHours 31

The value is within the last X hours. Value =31.

LastXMonths 37

The value is within the last X (specified value) months. Value = 37.

LastXWeeks 35

The value is within the last X (specified value) weeks. Value = 35.

LastXYears 39

The value is within the last X years. Value = 39.

LastYear 28

The value is within the previous year. Value = 28.

LessEqual 5

The value is less than or equal to the compared value. Value = 5.

LessThan 3

The value is less than the compared value. Value = 3.

Like 6

The character string is matched to the specified pattern. Value = 6.

Mask 46

The value is found in the specified bit-mask value. Value = 46.

MasksSelect 48

For internal use only. Value = 48.

Next7Days 18

The value is within the next seven days. Value = 18.

NextFiscalPeriod 61

The value is within the next fiscal period. Value = 61.

NextFiscalYear 60

The value is within the next fiscal year. Value = 60.

NextMonth 24

The value is within the next month. Value = 24.

NextWeek 21

The value is within the next week. Value = 21.

NextXDays 34

The value is within the next X (specified value) days. Value = 34.

NextXFiscalPeriods 67

The value is within the next X (specified value) fiscal period. Value = 67.

NextXFiscalYears 66

The value is within the next X (specified value) fiscal years. Value = 66.

NextXHours 32

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

NextXMonths 38

The value is within the next X (specified value) months. Value = 38.

NextXWeeks 36

The value is within the next X weeks. Value = 36.

NextXYears 40

The value is within the next X years. Value = 40.

NextYear 30

The value is within the next year. Value = 30.

NotBetween 11

The value is not between two values. Value = 11.

NotEqual 1

The two values are not equal. Value = 1.

NotEqualBusinessId 44

The value is not equal to the specified business ID. Value = 44.

NotEqualUserId 42

The value is not equal to the specified user ID. Value = 42.

NotIn 9

The given value is not matched to a value in a subquery or a list. Value = 9.

NotLike 7

The character string does not match the specified pattern. Value = 7.

NotMask 47

The value is not found in the specified bit-mask value. Value = 47.

NotNull 13

The value is not null. Value = 13.

NotOn 52

For internal use only.

NotUnder 76

Returns all records not below the referenced record in the hierarchy. Value = 77.

Null 12

The value is null. Value = 12.

OlderThanXDays 84

OlderThanXHours 85

OlderThanXMinutes 86

OlderThanXMonths 53

The value is older than the specified number of months. Value = 53.

OlderThanXWeeks 83

OlderThanXYears 82

On 25

The value is on a specified date. Value = 25.

OnOrAfter 27

The value is on or after a specified date. Value = 27.

OnOrBefore 26

The value is on or before a specified date. Value = 26.

ThisFiscalPeriod 59

The value is within the current fiscal period. Value = 59.

ThisFiscalYear 58

The value is within the current fiscal year . Value = 58.

ThisMonth 23

The value is within the current month. Value = 23.

ThisWeek 20

The value is within the current week. Value = 20.

ThisYear 29

The value is within the current year. Value = 29.

Today 15

The value equals today’s date. Value = 15.

Tomorrow 16

The value equals tomorrow’s date. Value = 16.

Under 75

Returns all child records below the referenced record in the hierarchy. Value = 76.

UnderOrEqual 77

Returns the referenced record and all child records below it in the hierarchy. Value = 79.

Yesterday 14

The value equals yesterday’s date. Value = 14.

Examples

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

Applies to

See also