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.
Assembly: Microsoft.Xrm.Sdk (in Microsoft.Xrm.Sdk.dll)
| 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. |
Microsoft Dynamics 365
© 2016 Microsoft. All rights reserved. Copyright