ConditionOperator Enumeration
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 = "https://schemas.microsoft.com/xrm/2011/Contracts")]
public enum ConditionOperator
<DataContractAttribute(Name := "ConditionOperator", Namespace := "https://schemas.microsoft.com/xrm/2011/Contracts")>
Public Enumeration ConditionOperator
Member name | Description | |
---|---|---|
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]);
Operator
Microsoft.Xrm.Sdk.Query Namespace
Return to top
Microsoft Dynamics 365
© 2016 Microsoft. All rights reserved. Copyright