condition element
Specify conditions for entity and link-entity row values which must be true to return the row. The condition operator attribute specifies how to evaluate the values.
Learn how to filter rows using FetchXml.
Example
This query returns account records where address1_city
equals 'Redmond'.
<fetch>
<entity name='account'>
<attribute name='name' />
<filter type='and'>
<condition attribute='address1_city'
operator='eq'
value='Redmond' />
</filter>
</entity>
</fetch>
Attributes
Name | Required? | Description |
---|---|---|
attribute |
No | The name of the column with the value to apply the filter. |
entityname |
No | Specify the link-entity name or alias that the condition should be applied to after the outer join. Learn more about filters on link-entity |
operator |
Yes | The operator to apply with the filter. |
value |
No | The value to test the column value with the operator. |
valueof |
No | The name of the column in the same table that has the value to test the column value with the operator. Learn more about filtering on other column values. |
Parent elements
Name | Description |
---|---|
filter | Specify complex conditions for an entity or link-entity to apply to a query. |
Child elements
Name | Occurrences | Description |
---|---|---|
value | 0 or Many | Specify values for operators that require multiple values. |
Remarks
- Use the
value
attribute for all operators that compare to a single value. For example,eq
. - Use the value element for operators that compare to multiple values For example:
in
. - Some operators require neither the
value
attribute or the value element. For example:null
.
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기