CRM Online Reporting FetchXML (Operators)
CRM Online Reporting with FetchXML Series
Intro: Intro to Series
Part I: How to Set up a Data Source to Access CRM Data in SQL Reporting Services
Part II: How to Use FetchXML Data in the Report
Part IIa: CRM FetchXML Operators
Part III: Handy SQL Reporting Services Functions for CRM Online Reports
I made this list mostly for my own benefit, but because I haven't seen a similar list online, it may be useful for you as well. Here's a list of the "operator" elements in CRM 2011 FetchXML, so these are the values you put into the operator attribute of a filter condition when building your FetchXML query.
An example of this use would be as follows:
<condition attribute="regardingobjectid" value="@ProjectTaskID" uitype="new_projecttask" operator="in"/>
Here's the list of operator values - let me know in the comments if you have found any others:
Operator | CRM Advanced Find Term |
lt | Less Than |
gt | Greater Than |
le | Less Than or Equal To |
ge | Greater Than or Equal To |
eq | Equals |
ne | Not Equals |
neq | Not Equal To |
null | Does Not Contain Data |
not-null | Contains Data |
in | Is In |
not-in | Is Not In |
between | Between |
not-between | Is Not Between |
like | Like |
not-like | Not Like |
yesterday | Yesterday |
today | Today |
tomorrow | Tomorrow |
next-seven-days | Next Seven Days |
last-seven-days | Last Seven Days |
next-week | Next Week |
last-week | Last Week |
this-month | This Month |
last-month | Last Month |
next-month | Next Month |
on | On |
on-or-before | On or Before |
on-or-after | On on After |
this-year | This Year |
last-year | Last Year |
next-year | Next Year |
eq-userid | Equals Current User |
ne-userid | Does Not Equal Current User |
eq-businessid | Equals Current Business Unit |
ne-businessid | Does Not Equal Current Business Unit |
this-week | This Week |
last-x-months | Last X Months |
eq-userlanguage | Equals User Language |
eq-userteams | Equals Current User's Teams |
in-fiscal-year | In Fiscal Year |
in-fiscal-period | In Fiscal Period |
in-fiscal-period-and-year | In Fiscal Period and Year |
in-or-after-fiscal-period-and-year | In or After Fiscal Period and Year |
in-or-before-fiscal-period-and-year | In or Before Fiscal Period and Year |
last-fiscal-year | Last Fiscal Year |
this-fiscal-year | This Fiscal Year |
next-fiscal-year | Next Fiscal Year |
last-x-fiscal-years | Last X Fiscal Years |
next-x-fiscal-years | Next X Fiscal Years |
last-fiscal-period | Last Fiscal Period |
this-fiscal-period | This Fiscal Period |
next-fiscal-period | Next Fiscal Period |
last-x-fiscal-periods | Last X Fiscal Periods |
next-x-fiscal-periods | Next X Fiscal Periods |