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.

AboveOrEqual 79

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

BeginsWith 54

The string occurs at the beginning of another string.

Between 10

The value is between two values.

ChildOf 45

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.

ContainValues 87

The choice value is one of the specified values.

DoesNotBeginWith 55

The string does not begin with another string.

DoesNotContain 50

The string does not contain another string.

DoesNotContainValues 88

The choice value is not one of the specified values.

DoesNotEndWith 57

The string does not end with another string.

EndsWith 56

The string ends with another string.

Equal 0

The values are compared for equality.

EqualBusinessId 43

The value is equal to the specified business ID.

EqualRoleBusinessId 89

For internal use only.

EqualUserId 41

The value is equal to the specified user ID.

EqualUserLanguage 51

The value is equal to the language for the user.

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.

EqualUserOrUserTeams 74

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

EqualUserTeams 73

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

GreaterEqual 4

The value is greater than or equal to the compared value.

GreaterThan 2

The value is greater than the compared value.

In 8

The value exists in a list of values.

InFiscalPeriod 69

The value is within the specified fiscal period.

InFiscalPeriodAndYear 70

The value is within the specified fiscal period and year.

InFiscalYear 68

The value is within the specified fiscal year.

InOrAfterFiscalPeriodAndYear 72

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

InOrBeforeFiscalPeriodAndYear 71

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

Last7Days 17

The value is within the last seven days including today.

LastFiscalPeriod 63

The value is within the last fiscal period.

LastFiscalYear 62

The value is within the last fiscal year.

LastMonth 22

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

LastWeek 19

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

LastXDays 33

The value is within last X (specified value) days.

LastXFiscalPeriods 65

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

LastXFiscalYears 64

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

LastXHours 31

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

LastXMonths 37

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

LastXWeeks 35

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

LastXYears 39

The value is within the last X (specified value) years.

LastYear 28

The value is within the previous year.

LessEqual 5

The value is less than or equal to the compared value.

LessThan 3

The value is less than the compared value.

Like 6

The character string is matched to the specified pattern.

Mask 46

The value is found in the specified bit-mask value.

MasksSelect 48

For internal use only.

Next7Days 18

The value is within the next seven days.

NextFiscalPeriod 61

The value is within the next fiscal period.

NextFiscalYear 60

The value is within the next fiscal year.

NextMonth 24

The value is within the next month.

NextWeek 21

The value is within the next week.

NextXDays 34

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

NextXFiscalPeriods 67

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

NextXFiscalYears 66

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

NextXHours 32

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

NextXMonths 38

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

NextXWeeks 36

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

NextXYears 40

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

NextYear 30

The value is within the next year.

NotBetween 11

The value is not between two values.

NotEqual 1

The two values are not equal.

NotEqualBusinessId 44

The value is not equal to the specified business ID.

NotEqualUserId 42

The value is not equal to the specified user ID.

NotIn 9

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

NotLike 7

The character string does not match the specified pattern.

NotMask 47

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

NotNull 13

The value is not null.

NotOn 52

For internal use only.

NotUnder 76

Returns all records not below the referenced record in the hierarchy.

Null 12

The value is null.

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.

OlderThanXMonths 53

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

OlderThanXWeeks 83

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

OlderThanXYears 82

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

On 25

The value is on a specified date.

OnOrAfter 27

The value is on or after a specified date.

OnOrBefore 26

The value is on or before a specified date.

ThisFiscalPeriod 59

The value is within the current fiscal period.

ThisFiscalYear 58

The value is within the current fiscal year.

ThisMonth 23

The value is within the current month.

ThisWeek 20

The value is within the current week.

ThisYear 29

The value is within the current year.

Today 15

The value equals today’s date.

Tomorrow 16

The value equals tomorrow's date.

Under 75

Returns all child records below the referenced record in the hierarchy.

UnderOrEqual 77

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

Yesterday 14

The value equals yesterday's date.

Examples

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

Applies to

See also