ConditionOperator Enumeration

Applies To: Microsoft Dynamics CRM 2013, Microsoft 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)

Syntax

'Declaration
<DataContractAttribute(Name:="ConditionOperator", Namespace:="https://schemas.microsoft.com/xrm/2011/Contracts")> _
Public Enumeration ConditionOperator
[DataContractAttribute(Name="ConditionOperator", Namespace="https://schemas.microsoft.com/xrm/2011/Contracts")] 
public enum ConditionOperator

Members

Member name Description
BeginsWith The string occurs at the beginning of another string. Value = 0x36.
Between The value is between two values. Value = 10.
ChildOf For internal use only.
Contains The string contains another string. Value = 0x31.
DoesNotBeginWith The string does not begin with another string. Value = 0x37.
DoesNotContain The string does not contain another string. Value = 50.
DoesNotEndWith The string does not end with another string. Value = 0x39.
EndsWith The string ends with another string. Value = 0x38.
Equal The values are compared for equality. Value = 0.
EqualBusinessId The value is equal to the specified business ID. Value = 0x2b.
EqualUserId The value is equal to the specified user ID. Value = 0x29.
EqualUserLanguage The value is equal to the language for the user. Value = 0x33.
EqualUserOrUserTeams The record is owned by a user or teams that the user is a member of. Value = 0x4a.
EqualUserTeams The record is owned by teams that the user is a member of. Value = 0x49.
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 = 0x45.
InFiscalPeriodAndYear The value is within the specified fiscal period and year. Value = 70.
InFiscalYear The value is within the specified year. Value = 0x44.
InOrAfterFiscalPeriodAndYear The value is within or after the specified fiscal period and year. Value = 0x48.
InOrBeforeFiscalPeriodAndYear The value is within or before the specified fiscal period and year. Value = 0x47.
Last7Days The value is within the last seven days including today. Value = 0x11.
LastFiscalPeriod The value is within the last fiscal period. Value = 0x3f.
LastFiscalYear The value is within the last fiscal year. Value = 0x3e.
LastMonth The value is within the last month including first day of the last month and last day of the last month. Value = 0x16.
LastWeek The value is within the previous week including Sunday through Saturday. Value = 0x13.
LastXDays The value is within last X days. Value = 0x21.
LastXFiscalPeriods The value is within the last X (specified value) fiscal periods. Value = 0x41.
LastXFiscalYears The value is within the last X (specified value) fiscal periods. Value = 0x40.
LastXHours The value is within the last X hours. Value = 0x1f.
LastXMonths The value is within the last X (specified value) months. Value = 0x25.
LastXWeeks The value is within the last X (specified value) weeks. Value = 0x23.
LastXYears The value is within the last X years. Value = 0x27.
LastYear The value is within the previous year. Value = 0x1c.
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 = 0x2e.
MasksSelect For internal use only. Value = 0x30.
Next7Days The value is within the next seven days. Value = 0x12.
NextFiscalPeriod The value is within the next fiscal period. Value = 0x3d.
NextFiscalYear The value is within the next fiscal year. Value = 60.
NextMonth The value is within the next month. Value = 0x18.
NextWeek The value is within the next week. Value = 0x15.
NextXDays The value is within the next X (specified value) days. Value = 0x22.
NextXFiscalPeriods The value is within the next X (specified value) fiscal period. Value = 0x43.
NextXFiscalYears The value is within the next X (specified value) fiscal years. Value = 0x42.
NextXHours The value is within the next X (specified value) hours. Value = 0x20.
NextXMonths The value is within the next X (specified value) months. Value = 0x26.
NextXWeeks The value is within the next X weeks. Value = 0x24.
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 = 0x2c.
NotEqualUserId The value is not equal to the specified user ID. Value = 0x2a.
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 = 0x2f.
NotNull The value is not null. Value = 13.
NotOn The value is not on the specified date. Value = 0x34.
Null The value is null. Value = 12.
OlderThanXMonths The value is older than the specified number of months. Value = 0x35.
On The value is on a specified date. Value = 0x19.
OnOrAfter The value is on or after a specified date. Value = 0x1b.
OnOrBefore The value is on or before a specified date. Value = 0x1a.
ThisFiscalPeriod The value is within the current fiscal period. Value = 0x3b.
ThisFiscalYear The value is within the current fiscal year . Value = 0x3a.
ThisMonth The value is within the current month. Value = 0x17.
ThisWeek The value is within the current week. Value = 20.
ThisYear The value is within the current year. Value = 0x1d.
Today The value equals today’s date. Value = 15.
Tomorrow The value equals tomorrow’s date. Value = 0x10.
Yesterday The value equals yesterday’s date. Value = 14.

Example

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

Platforms

Development Platforms

Windows Server 2008, Windows Server 2012, Windows 7 (All Versions), Windows 8 (All Versions)

Target Platforms

Windows Server 2008, ,Windows Server 2012, ,Windows 7 (All Versions),

Change History

See Also

Reference

Microsoft.Xrm.Sdk.Query Namespace
ConditionExpression.Operator Property

Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.