Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)
Syntax
[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
Members
| 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. |
Examples
filter.AddCondition("accountid", ConditionOperator.Equal, _accountIdArray[j]);
See Also
Operator
Microsoft.Xrm.Sdk.Query Namespace
Return to top
Microsoft Dynamics 365
© 2016 Microsoft. All rights reserved. Copyright