Conditions
The following table provides more information regarding conditions in Fetch XML.
| Condition | Actual comparison | Value |
| equals x | eq | x |
| does not equal x | ne | x |
| is greater than x | gt | x |
| is greater than or equal to x | ge | x |
| is less than x | lt | x |
| is less than or equal to x | le | x |
| begins with x | like | x% |
| does not begin with x | not-like | x% |
| ends with x | like | %x |
| does not end with x | not-like | %x |
| contains x | like | %x% |
| does not contain x | not-like | %x% |
| exists | not-null | |
| does not exist | null | |
| anytime | not-null | |
| yesterday | yesterday | |
| today | today | |
| tomorrow | tomorrow | |
| in next 7 days | next-seven-days | |
| in last 7 days | last-seven-days | |
| next week | next-week | |
| last week | last-week | |
| this week | this-week | |
| this month | this-month | |
| last month | last-month | |
| next month | next-month | |
| this year | this-year | |
| next year | next-year | |
| last year | last-year | |
| on x | on | x |
| on or after x | on-or-after | x |
| on or before x | on-or-before | x |
| in between | between | |
| not between | not-between | |
| in | in | |
| not in | not-in | |
| equals user id | eq-userid | |
| does not equal user id | ne-userid | |
| equals business id | eq-businessid | |
| does not equal business id | ne-businessid |