ConditionOperator Enumeration

 

Updated: November 29, 2016

Applies To: Dynamics 365 (online), Dynamics 365 (on-premises), Dynamics CRM 2016, Dynamics CRM Online

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

Namespace:   Microsoft.Xrm.Sdk.Query
Assembly:  Microsoft.Xrm.Sdk (in Microsoft.Xrm.Sdk.dll)

[DataContractAttribute(Name = "ConditionOperator", Namespace = "http://schemas.microsoft.com/xrm/2011/Contracts")]
public enum ConditionOperator

Member nameDescription
Above

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

AboveOrEqual

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

BeginsWith

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

Between

The value is between two values. Value = 10.

ChildOf

For internal use only.

Contains

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.

DoesNotBeginWith

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

DoesNotContain

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

DoesNotEndWith

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

EndsWith

The string ends with another string. Value = 56.

Equal

The values are compared for equality. Value = 0.

EqualBusinessId

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

EqualUserId

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

EqualUserLanguage

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

EqualUserOrUserHierarchy

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

EqualUserOrUserHierarchyAndTeams

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

EqualUserOrUserTeams

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

EqualUserTeams

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

GreaterEqual

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

GreaterThan

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

In

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

InFiscalPeriod

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

InFiscalPeriodAndYear

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

InFiscalYear

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

InOrAfterFiscalPeriodAndYear

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

InOrBeforeFiscalPeriodAndYear

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

Last7Days

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

LastFiscalPeriod

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

LastFiscalYear

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

LastMonth

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

LastWeek

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

LastXDays

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

LastXFiscalPeriods

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

LastXFiscalYears

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

LastXHours

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

LastXMonths

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

LastXWeeks

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

LastXYears

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

LastYear

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

LessEqual

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

LessThan

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

Like

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

Mask

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

MasksSelect

For internal use only. Value = 48.

Next7Days

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

NextFiscalPeriod

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

NextFiscalYear

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

NextMonth

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

NextWeek

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

NextXDays

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

NextXFiscalPeriods

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

NextXFiscalYears

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

NextXHours

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

NextXMonths

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

NextXWeeks

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

NextXYears

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

NextYear

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

NotBetween

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

NotEqual

The two values are not equal. Value = 1.

NotEqualBusinessId

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

NotEqualUserId

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

NotIn

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

NotLike

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

NotMask

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

NotNull

The value is not null. Value = 13.

NotOn

For internal use only.

NotUnder

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

Null

The value is null. Value = 12.

OlderThanXDays

OlderThanXHours

OlderThanXMinutes

OlderThanXMonths

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

OlderThanXWeeks

OlderThanXYears

On

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

OnOrAfter

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

OnOrBefore

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

ThisFiscalPeriod

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

ThisFiscalYear

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

ThisMonth

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

ThisWeek

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

ThisYear

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

Today

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

Tomorrow

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

Under

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

UnderOrEqual

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

Yesterday

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


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

Return to top

Microsoft Dynamics 365

© 2016 Microsoft. All rights reserved. Copyright

Community Additions

ADD
Show: