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.