• Set up Data Source to Access Data in SQL Reporting Services
  • How to Add Parameters to a Fetch Based Report
  • Dynamics CRM 2015 Online FetchXML Operators
  • Tips and Tricks

Following table describes different types of operators we can use in a ConditionExpression and FetchXML in Dynamics CRM 2015:

FetchXML OperatorConditionOperatorDescription
likeBeginsWithThe string occurs at the beginning of another string.
betweenBetweenThe value is between two values.
likeContainsThe string contains another string.
not-likeDoesNotBeginWithThe string does not begin with another string.
not-likeDoesNotContainThe string does not contain another string.
not-likeDoesNotEndWithThe string does not end with another string.
likeEndsWithThe string ends with another string.
eqEqualThe values are compared for equality.
eq-businessidEqualBusinessIdThe value is equal to the specified business ID.
eq-useridEqualUserIdThe value is equal to the specified user ID.
eq-userteamsEqualUserTeamsThe record is owned by teams that the user is a member of.
geGreaterEqualThe value is greater than or equal to the compared value.
gtGreaterThanThe value is greater than the compared value.
inInTheThe value exists in a list of values.
in-fiscal-periodInFiscalPeriodThe value is within the specified fiscal period.
in-fiscal-period-and-yearInFiscalPeriodAndYearThe value is within the specified fiscal period and year.
in-fiscal-yearInFiscalYearThe value is within the specified year.
in-or-after-fiscal-period-and-yearInOrAfterFiscalPeriodAndYearThe value is within or after the specified fiscal period and year.
in-or-before-fiscal-period-and-yearInOrBeforeFiscalPeriodAndYearThe value is within or before the specified fiscal period and year.
last-seven-daysLast7DaysThe value is within the last seven days including today.
last-fiscal-periodLastFiscalPeriodThe value is within the last fiscal period.
last-fiscal-yearLastFiscalYearThe value is within the last fiscal year.
last-monthLastMonth
The value is within the last month including first day of the last month and last day of the last month.
last-weekLastWeek
The value is within the previous week including Sunday through Saturday.
last-x-daysLastXDaysThe value is within last X days.
last-x-fiscal-periodsLastXFiscalPeriodsThe value is within the last X (specified value) fiscal periods.
last-x-fiscal-yearsLastXFiscalYearsThe value is within the last X (specified value) fiscal periods.
last-x-hoursLastXHoursThe value is within the last X hours.
last-x-monthsLastXMonthsThe value is within the last X (specified value) months.
last-x-weeksLastXWeeksThe value is within the last X (specified value) weeks.
last-x-yearsLastXYearsThe value is within the last X years.
last-yearLastYearThe value is within the previous year.
leLessEqualThe value is less than or equal to the compared value.
ltLessThanThe value is less than the compared value.
likeLikeThe character string is matched to the specified pattern.
next-seven-daysNext7DaysThe value is within the next seven days.
next-fiscal-periodNextFiscalPeriodThe value is within the next fiscal period.
next-fiscal-yearNextFiscalYearThe value is within the next fiscal year.
next-monthNextMonthThe value is within the next month.
next-weekNextWeekThe value is within the next week.
next-x-daysNextXDaysThe value is within the next X (specified value) days.
next-x-fiscal-periodsNextXFiscalPeriodsThe value is within the next X (specified value) fiscal period.
next-x-fiscal-yearsNextXFiscalYearsThe value is within the next X (specified value) fiscal years.
next-x-hoursNextXHoursThe value is within the next X (specified value) hours.
next-x-monthsNextXMonthsThe value is within the next X (specified value) months.
next-x-weeksNextXWeeksThe value is within the next X weeks.
next-x-yearsNextXYearsThe value is within the next X years.
next-yearNextYearThe value is within the next year.
not-betweenNotBetweenThe value is not between two values.
neNotEqualThe two values are not equal.
ne-businessidNotEqualBusinessIdThe value is not equal to the specified business ID.
ne-useridNotEqualUserIdThe value is not equal to the specified user ID.
not-inNotInThe given value is not matched to a value in a subquery or a list.
not-likeNotLikeThe character string does not match the specified pattern.
not-nullNotNullThe value is not null.
neNotOnThe value is not on the specified date.
nullNullThe value is null.
olderthan-x-monthsOlderThanXMonthsThe value is older than the specified number of months.
onOnThe value is on a specified date.
on-or-afterOnOrAfterThe value is on or after a specified date.
on-or-beforeOnOrBeforeThe value is on or before a specified date.
this-fiscal-periodThisFiscalPeriodThe value is within the current fiscal period.
this-fiscal-yearThisFiscalYearThe value is within the current fiscal year.
this-monthThisMonthThe value is within the current month.
this-weekThisWeekThe value is within the current week.
this-yearThisYearThe value is within the current year.
todayTodayThe value equals today’s date.
tomorrowTomorrowThe value equals tomorrow’s date.
yesterdayYesterdayThe value equals yesterday’s date.