title

description

author

ms.author

ms.reviewer

ms.date

ms.topic

ms.subservice

search.audienceType

contributors

condition operator values

Use these values in a condition element operator attribute to specify how to evaluate the condition.

pnghub

gned

jdaly

03/08/2024

reference

dataverse-developer

developer

JimDaly

dmitmikh

dasussMS

apahwa-lab

DonaldlaGithub

condition operator values

To learn how to use these values, see Filter rows using FetchXml.

Operator	Description	Data Types
above	[!INCLUDE operator-above-description]	Hierarchical
begins-with	[!INCLUDE operator-begins-with-description]	String
between	[!INCLUDE operator-between-description]	Number Datetime
contain-values	[!INCLUDE operator-contain-values-description]	Choice
ends-with	[!INCLUDE operator-ends-with-description]	String
eq	[!INCLUDE operator-eq-description]	Choice Datetime Hierarchical Number Owner String Unique Identifier
eq-businessid	[!INCLUDE operator-eq-businessid-description]	Unique Identifier
eq-or-above	[!INCLUDE operator-eq-or-above-description]	Hierarchical
eq-or-under	[!INCLUDE operator-eq-or-under-description]	Hierarchical
eq-userid	[!INCLUDE operator-eq-userid-description]	Unique Identifier
eq-userlanguage	[!INCLUDE operator-eq-userlanguage-description]	Number
eq-useroruserhierarchy	[!INCLUDE operator-eq-useroruserhierarchy-description]	Hierarchical
eq-useroruserhierarchyandteams	[!INCLUDE operator-eq-useroruserhierarchyandteams-description]	Hierarchical
eq-useroruserteams	[!INCLUDE operator-eq-useroruserteams-description]	Owner
eq-userteams	[!INCLUDE operator-eq-userteams-description]	Owner
ge	[!INCLUDE operator-ge-description]	Number Datetime String
gt	[!INCLUDE operator-gt-description]	Number Datetime String
in	[!INCLUDE operator-in-description]	Choice Number Owner String Unique Identifier
in-fiscal-period	[!INCLUDE operator-in-fiscal-period-description]	Datetime
in-fiscal-period-and-year	[!INCLUDE operator-in-fiscal-period-and-year-description]	Datetime
in-fiscal-year	[!INCLUDE operator-in-fiscal-year-description]	Datetime
in-or-after-fiscal-period-and-year	[!INCLUDE operator-in-or-after-fiscal-period-and-year-description]	Datetime
in-or-before-fiscal-period-and-year	[!INCLUDE operator-in-or-before-fiscal-period-and-year-description]	Datetime
last-fiscal-period	[!INCLUDE operator-last-fiscal-period-description]	Datetime
last-fiscal-year	[!INCLUDE operator-last-fiscal-year-description]	Datetime
last-month	[!INCLUDE operator-last-month-description]	Datetime
last-seven-days	[!INCLUDE operator-last-seven-days-description]	Datetime
last-week	[!INCLUDE operator-last-week-description]	Datetime
last-x-days	[!INCLUDE operator-last-x-days-description]	Datetime
last-x-fiscal-periods	[!INCLUDE operator-last-x-fiscal-periods-description]	Datetime
last-x-fiscal-years	[!INCLUDE operator-last-x-fiscal-years-description]	Datetime
last-x-hours	[!INCLUDE operator-last-x-hours-description]	Datetime
last-x-months	[!INCLUDE operator-last-x-months-description]	Datetime
last-x-weeks	[!INCLUDE operator-last-x-weeks-description]	Datetime
last-x-years	[!INCLUDE operator-last-x-years-description]	Datetime
last-year	[!INCLUDE operator-last-year-description]	Datetime
le	[!INCLUDE operator-le-description]	Number Datetime String
like	[!INCLUDE operator-like-description]	String
lt	[!INCLUDE operator-lt-description]	Number Datetime String
ne	[!INCLUDE operator-ne-description]	Choice Datetime Hierarchical Number Owner String Unique Identifier
ne-businessid	[!INCLUDE operator-ne-businessid-description]	Unique Identifier
ne-userid	[!INCLUDE operator-ne-userid-description]	Unique Identifier
neq	[!INCLUDE operator-neq-description]	N/A
next-fiscal-period	[!INCLUDE operator-next-fiscal-period-description]	Datetime
next-fiscal-year	[!INCLUDE operator-next-fiscal-year-description]	Datetime
next-month	[!INCLUDE operator-next-month-description]	Datetime
next-seven-days	[!INCLUDE operator-next-seven-days-description]	Datetime
next-week	[!INCLUDE operator-next-week-description]	Datetime
next-x-days	[!INCLUDE operator-next-x-days-description]	Datetime
next-x-fiscal-periods	[!INCLUDE operator-next-x-fiscal-periods-description]	Datetime
next-x-fiscal-years	[!INCLUDE operator-next-x-fiscal-years-description]	Datetime
next-x-hours	[!INCLUDE operator-next-x-hours-description]	Datetime
next-x-months	[!INCLUDE operator-next-x-months-description]	Datetime
next-x-weeks	[!INCLUDE operator-next-x-weeks-description]	Datetime
next-x-years	[!INCLUDE operator-next-x-years-description]	Datetime
next-year	[!INCLUDE operator-next-year-description]	Datetime
not-begin-with	[!INCLUDE operator-not-begin-with-description]	String
not-between	[!INCLUDE operator-not-between-description]	Number Datetime
not-contain-values	[!INCLUDE operator-not-contain-values-description]	Choice
not-end-with	[!INCLUDE operator-not-end-with-description]	String
not-in	[!INCLUDE operator-not-in-description]	Number
not-like	[!INCLUDE operator-not-like-description]	String
not-null	[!INCLUDE operator-not-null-description]	Choice Datetime Hierarchical Number Owner String Unique Identifier
not-under	[!INCLUDE operator-not-under-description]	Hierarchical
null	[!INCLUDE operator-null-description]	Choice Datetime Hierarchical Number Owner String Unique Identifier
olderthan-x-days	[!INCLUDE operator-olderthan-x-days-description]	Datetime
olderthan-x-hours	[!INCLUDE operator-olderthan-x-hours-description]	Datetime
olderthan-x-minutes	[!INCLUDE operator-olderthan-x-minutes-description]	Datetime
olderthan-x-months	[!INCLUDE operator-olderthan-x-months-description]	Datetime
olderthan-x-weeks	[!INCLUDE operator-olderthan-x-weeks-description]	Datetime
olderthan-x-years	[!INCLUDE operator-olderthan-x-years-description]	Datetime
on	[!INCLUDE operator-on-description]	Datetime
on-or-after	[!INCLUDE operator-on-or-after-description]	Datetime
on-or-before	[!INCLUDE operator-on-or-before-description]	Datetime
this-fiscal-period	[!INCLUDE operator-this-fiscal-period-description]	Datetime
this-fiscal-year	[!INCLUDE operator-this-fiscal-year-description]	Datetime
this-month	[!INCLUDE operator-this-month-description]	Datetime
this-week	[!INCLUDE operator-this-week-description]	Datetime
this-year	[!INCLUDE operator-this-year-description]	Datetime
today	[!INCLUDE operator-today-description]	Datetime
tomorrow	[!INCLUDE operator-tomorrow-description]	Datetime
under	[!INCLUDE operator-under-description]	Hierarchical
yesterday	[!INCLUDE operator-yesterday-description]	Datetime

Back to top

By Data type

This section groups operators by the type of data they can be used with.

Choice data
Datetime data
Hierarchical data
Number data
Owner data
String data
Unique Identifier data

Choice data

Use the following operators in conditions using choice values.

Operator	Description
contain-values	[!INCLUDE operator-contain-values-description]
eq	[!INCLUDE operator-eq-description]
in	[!INCLUDE operator-in-description]
ne	[!INCLUDE operator-ne-description]
not-contain-values	[!INCLUDE operator-not-contain-values-description]
not-null	[!INCLUDE operator-not-null-description]
null	[!INCLUDE operator-null-description]

Datetime data

Use the following operators in conditions using date and time values.

Note

When a column is configured with DateOnly behavior you cannot use the operators that apply to hours and minutes. Learn more about the behavior of date and time columns.

The behavior of some operators depend on the fiscal year settings for the environment. Learn more about fiscal year settings

Operator	Description
between	[!INCLUDE operator-between-description]
eq	[!INCLUDE operator-eq-description]
gt	[!INCLUDE operator-gt-description]
ge	[!INCLUDE operator-ge-description]
in-fiscal-period-and-year	[!INCLUDE operator-in-fiscal-period-and-year-description]
in-fiscal-period	[!INCLUDE operator-in-fiscal-period-description]
in-fiscal-year	[!INCLUDE operator-in-fiscal-year-description]
in-or-after-fiscal-period-and-year	[!INCLUDE operator-in-or-after-fiscal-period-and-year-description]
in-or-before-fiscal-period-and-year	[!INCLUDE operator-in-or-before-fiscal-period-and-year-description]
last-fiscal-period	[!INCLUDE operator-last-fiscal-period-description]
last-fiscal-year	[!INCLUDE operator-last-fiscal-year-description]
last-month	[!INCLUDE operator-last-month-description]
last-seven-days	[!INCLUDE operator-last-seven-days-description]
last-week	[!INCLUDE operator-last-week-description]
last-x-days	[!INCLUDE operator-last-x-days-description]
last-x-fiscal-periods	[!INCLUDE operator-last-x-fiscal-periods-description]
last-x-fiscal-years	[!INCLUDE operator-last-x-fiscal-years-description]
last-x-hours	[!INCLUDE operator-last-x-hours-description]
last-x-months	[!INCLUDE operator-last-x-months-description]
last-x-weeks	[!INCLUDE operator-last-x-weeks-description]
last-x-years	[!INCLUDE operator-last-x-years-description]
last-year	[!INCLUDE operator-last-year-description]
le	[!INCLUDE operator-le-description]
lt	[!INCLUDE operator-lt-description]
next-fiscal-period	[!INCLUDE operator-next-fiscal-period-description]
next-fiscal-year	[!INCLUDE operator-next-fiscal-year-description]
next-month	[!INCLUDE operator-next-month-description]
next-seven-days	[!INCLUDE operator-next-seven-days-description]
next-week	[!INCLUDE operator-next-week-description]
next-x-days	[!INCLUDE operator-next-x-days-description]
next-x-fiscal-periods	[!INCLUDE operator-next-x-fiscal-periods-description]
next-x-fiscal-years	[!INCLUDE operator-next-x-fiscal-years-description]
next-x-hours	[!INCLUDE operator-next-x-hours-description]
next-x-months	[!INCLUDE operator-next-x-months-description]
next-x-weeks	[!INCLUDE operator-next-x-weeks-description]
next-x-years	[!INCLUDE operator-next-x-years-description]
next-year	[!INCLUDE operator-next-year-description]
not-between	[!INCLUDE operator-not-between-description]
not-null	[!INCLUDE operator-not-null-description]
null	[!INCLUDE operator-null-description]
olderthan-x-days	[!INCLUDE operator-olderthan-x-days-description]
olderthan-x-hours	[!INCLUDE operator-olderthan-x-hours-description]
olderthan-x-minutes	[!INCLUDE operator-olderthan-x-minutes-description]
olderthan-x-months	[!INCLUDE operator-olderthan-x-months-description]
olderthan-x-weeks	[!INCLUDE operator-olderthan-x-weeks-description]
olderthan-x-years	[!INCLUDE operator-olderthan-x-years-description]
on-or-after	[!INCLUDE operator-on-or-after-description]
on-or-before	[!INCLUDE operator-on-or-before-description]
on	[!INCLUDE operator-on-description]
this-fiscal-period	[!INCLUDE operator-this-fiscal-period-description]
this-fiscal-year	[!INCLUDE operator-this-fiscal-year-description]
this-month	[!INCLUDE operator-this-month-description]
this-week	[!INCLUDE operator-this-week-description]
this-year	[!INCLUDE operator-this-year-description]
today	[!INCLUDE operator-today-description]
tomorrow	[!INCLUDE operator-tomorrow-description]
yesterday	[!INCLUDE operator-yesterday-description]

Hierarchical data

Use the following operators in conditions using hierarchical data. Learn more about querying hierarchical data.

Operator	Description
above	[!INCLUDE operator-above-description]
eq-or-above	[!INCLUDE operator-eq-or-above-description]
eq-or-under	[!INCLUDE operator-eq-or-under-description]
eq-useroruserhierarchy	[!INCLUDE operator-eq-useroruserhierarchy-description]
eq-useroruserhierarchyandteams	[!INCLUDE operator-eq-useroruserhierarchyandteams-description]
not-under	[!INCLUDE operator-not-under-description]
under	[!INCLUDE operator-under-description]

Number data

Use the following operators in conditions using numeric values.

Operator	Description
between	[!INCLUDE operator-between-description]
eq-userlanguage	[!INCLUDE operator-eq-userlanguage-description]
eq	[!INCLUDE operator-eq-description]
ge	[!INCLUDE operator-ge-description]
gt	[!INCLUDE operator-gt-description]
in	[!INCLUDE operator-in-description]
le	[!INCLUDE operator-le-description]
lt	[!INCLUDE operator-lt-description]
ne	[!INCLUDE operator-ne-description]
not-between	[!INCLUDE operator-not-between-description]
not-in	[!INCLUDE operator-not-in-description]
not-null	[!INCLUDE operator-not-null-description]
null	[!INCLUDE operator-null-description]

Owner data

Use the following operators in conditions using owner values.

Operator	Description
eq-useroruserteams	[!INCLUDE operator-eq-useroruserteams-description]
eq-userteams	[!INCLUDE operator-eq-userteams-description]
eq	[!INCLUDE operator-eq-description]
in	[!INCLUDE operator-in-description]
ne	[!INCLUDE operator-ne-description]

String data

Use the following operators in conditions using string values.

All filter conditions for string values are case insensitive.

You can use wildcard characters for the following operators: like, not-like, begins-with, not-begin-with, ends-with, and not-end-with. Learn more about using wildcard characters in conditions for string values

Operator	Description
begins-with	[!INCLUDE operator-begins-with-description]
ends-with	[!INCLUDE operator-ends-with-description]
eq	[!INCLUDE operator-eq-description]
ge	[!INCLUDE operator-ge-description]
gt	[!INCLUDE operator-gt-description]
in	[!INCLUDE operator-in-description]
le	[!INCLUDE operator-le-description]
like	[!INCLUDE operator-like-description]
lt	[!INCLUDE operator-lt-description]
ne	[!INCLUDE operator-ne-description]
not-begin-with	[!INCLUDE operator-not-begin-with-description]
not-end-with	[!INCLUDE operator-not-end-with-description]
not-like	[!INCLUDE operator-not-like-description]
not-null	[!INCLUDE operator-not-null-description]
null	[!INCLUDE operator-null-description]

Unique Identifier data

Use the following operators in conditions using unique identifier (GUID) values.

Operator	Description
eq-businessid	[!INCLUDE operator-eq-businessid-description]
eq-userid	[!INCLUDE operator-eq-userid-description]
eq	[!INCLUDE operator-eq-description]
in	[!INCLUDE operator-in-description]
ne-businessid	[!INCLUDE operator-ne-businessid-description]
ne-userid	[!INCLUDE operator-ne-userid-description]
ne	[!INCLUDE operator-ne-description]
not-null	[!INCLUDE operator-not-null-description]
null	[!INCLUDE operator-null-description]

Back to top

Details

This section includes details about each of the FetchXml condition operators.

above

[!INCLUDE operator-above-description]

Learn more about querying hierarchical data

Data Type: Hierarchical

begins-with

[!INCLUDE operator-begins-with-description]

[!INCLUDE wildcard-string-operator]

Data Type: String

between

[!INCLUDE operator-between-description]

This operator requires two values.

<condition attribute="numberofemployees" operator="between">
  <value>6</value>
  <value>20</value>
</condition>

Data Types:

Number
Datetime

contain-values

[!INCLUDE operator-contain-values-description]

Data Type: Choice

ends-with

[!INCLUDE operator-ends-with-description]

[!INCLUDE wildcard-string-operator]

Data Type: String

eq

[!INCLUDE operator-eq-description]

Data Types:

Choice
Datetime
Hierarchical
Number
Owner
String
Unique Identifier

No value is required for this operator.

<condition attribute='ownerid' operator='eq-userid' />

Data Type: Unique Identifier

eq-userlanguage

[!INCLUDE operator-eq-userlanguage-description]

When a column uses the Power Apps Language type, it is an integer value that stores the Microsoft Locale ID Value for the language. The value is compared to the UserSettings.UILanguageId that represents the calling user's preferred language. These columns have AttributeMetadata.AttributeTypeName.Value equal to IntegerType and a Format value of IntegerFormat.Language.

Data Type: Number

eq-useroruserhierarchy

[!INCLUDE operator-eq-useroruserhierarchy-description]

Learn more about querying hierarchical data

Data Type: Hierarchical

eq-useroruserhierarchyandteams

[!INCLUDE operator-eq-useroruserhierarchyandteams-description]

Learn more about querying hierarchical data

Data Type: Hierarchical

eq-useroruserteams

[!INCLUDE operator-eq-useroruserteams-description]

Data Type: Owner

eq-userteams

[!INCLUDE operator-eq-userteams-description]

Data Type: Owner

ge

[!INCLUDE operator-ge-description]

Data Types:

Number
Datetime
String

gt

[!INCLUDE operator-gt-description]

Data Types:

Number
Datetime
String

in

[!INCLUDE operator-in-description]

Data Types:

Choice
Number
Unique Identifier
Owner
String Up to 850 characters

in-fiscal-period

[!INCLUDE operator-in-fiscal-period-description]

Learn more about fiscal year settings

The following example shows a FetchXML query that finds all orders fulfilled in period three of any fiscal year, according to the organization's fiscal year settings. The fiscal period value is specified in the value column of the condition element. If the organization uses fiscal months, the query returns results from month three. If the organization uses fiscal quarters, the query returns results from quarter three. If the organization uses fiscal semesters, no results are returned; there are only two semesters, and the value supplied is therefore out of range.

<fetch>
   <entity name="order">
      <attribute name="name" />
      <filter type="and">
         <condition attribute="datefulfilled"
            operator="in-fiscal-period"
            value="3" />
      </filter>
   </entity>
</fetch>

Data Type: Datetime

in-fiscal-period-and-year

[!INCLUDE operator-in-fiscal-period-and-year-description]

Learn more about fiscal year settings

The following example shows a FetchXML expression that finds all orders fulfilled in period three of fiscal year 2023, according to the organization's fiscal year settings. If the organization uses fiscal months, the query returns results from month three. If the organization uses fiscal quarters, the query returns results from quarter three. If the organization uses fiscal semesters, no results are returned; there are only two semesters, and the value supplied is therefore out-of-range

<fetch>
   <entity name="order">
      <attribute name="name" />
      <filter type="and">
         <condition attribute="datefulfilled"
            operator="in-fiscal-period-and-year">
            <value>3</value>
            <value>2023</value>
         </condition>
      </filter>
   </entity>
</fetch>

Data Type: Datetime

in-fiscal-year

[!INCLUDE operator-in-fiscal-year-description]

Learn more about fiscal year settings

The following example shows a FetchXML expression that finds all accounts created in fiscal year 2023.

<fetch>
   <entity name="account">
      <attribute name="name" />
      <filter type="and">
         <condition attribute="createdon"
            operator="in-fiscal-year"
            value="2023" />
      </filter>
   </entity>
</fetch>

Data Type: Datetime

in-or-after-fiscal-period-and-year

[!INCLUDE operator-in-or-after-fiscal-period-and-year-description]

Learn more about fiscal year settings

Data Type: Datetime

in-or-before-fiscal-period-and-year

[!INCLUDE operator-in-or-before-fiscal-period-and-year-description]

Learn more about fiscal year settings

Data Type: Datetime

last-fiscal-period

[!INCLUDE operator-last-fiscal-period-description]

Learn more about fiscal year settings

The following example shows a FetchXML expression that finds all orders fulfilled in the last fiscal period, according to the organization's fiscal year settings. For example, if the organization uses fiscal months, the query returns orders fulfilled in the last fiscal month. If the organization uses fiscal quarters, the query returns orders fulfilled in the last fiscal quarter. If the organization uses fiscal semesters, orders fulfilled in the last fiscal semester are returned.

<fetch>
   <entity name="order">
      <attribute name="name" />
      <filter type="and">
         <condition attribute="datefulfilled"
            operator="last-fiscal-period" />
      </filter>
   </entity>
</fetch>

Data Type: Datetime

last-fiscal-year

[!INCLUDE operator-last-fiscal-year-description]

Learn more about fiscal year settings

Data Type: Datetime

last-month

[!INCLUDE operator-last-month-description]

Data Type: Datetime

last-seven-days

[!INCLUDE operator-last-seven-days-description]

Data Type: Datetime

last-week

[!INCLUDE operator-last-week-description]

Data Type: Datetime

last-x-days

[!INCLUDE operator-last-x-days-description]

Data Type: Datetime

last-x-fiscal-periods

[!INCLUDE operator-last-x-fiscal-periods-description]

Learn more about fiscal year settings

Data Type: Datetime

last-x-fiscal-years

[!INCLUDE operator-last-x-fiscal-years-description]

Learn more about fiscal year settings

Data Type: Datetime

last-x-hours

[!INCLUDE operator-last-x-hours-description]

[!INCLUDE operator-invalid-dateonly]

Data Type: Datetime

last-x-months

[!INCLUDE operator-last-x-months-description]

Data Type: Datetime

last-x-weeks

[!INCLUDE operator-last-x-weeks-description]

Data Type: Datetime

last-x-years

[!INCLUDE operator-last-x-years-description]

Data Type: Datetime

last-year

[!INCLUDE operator-last-year-description]

Data Type: Datetime

le

[!INCLUDE operator-le-description]

Data Types:

Number
Datetime
String

like

[!INCLUDE operator-like-description]

[!INCLUDE wildcard-string-operator]

Data Type: String

lt

[!INCLUDE operator-lt-description]

Data Types:

Number
Datetime
String

ne

[!INCLUDE operator-ne-description]

Data Types:

Choice
Datetime
Hierarchical
Number
Owner
String
Unique Identifier

ne-businessid

[!INCLUDE operator-ne-businessid-description]

Data Type: Unique Identifier

ne-userid

[!INCLUDE operator-ne-userid-description]

Data Type: Unique Identifier

neq

[!INCLUDE operator-neq-description]

next-fiscal-period

[!INCLUDE operator-next-fiscal-period-description]

Learn more about fiscal year settings

Data Type: Datetime

next-fiscal-year

[!INCLUDE operator-next-fiscal-year-description]

Learn more about fiscal year settings

Data Type: Datetime

next-month

[!INCLUDE operator-next-month-description]

Data Type: Datetime

next-seven-days

[!INCLUDE operator-next-seven-days-description]

Data Type: Datetime

next-week

[!INCLUDE operator-next-week-description]

Data Type: Datetime

next-x-days

[!INCLUDE operator-next-x-days-description]

Data Type: Datetime

next-x-fiscal-periods

[!INCLUDE operator-next-x-fiscal-periods-description]

Learn more about fiscal year settings

Data Type: Datetime

next-x-fiscal-years

[!INCLUDE operator-next-x-fiscal-years-description]

Learn more about fiscal year settings

The following example shows a FetchXML expression that finds all opportunities with an estimated close date in the next three fiscal years, based on the organization's fiscal year settings. The value for x is specified in the value column of the condition element.

<fetch>
   <entity name="opportunity">
      <attribute name="name" />
      <filter type="and">
         <condition attribute="estimatedclosedate"
            operator="next-x-fiscal-years"
            value="3" />
      </filter>
   </entity>
</fetch>

Data Type: Datetime

next-x-hours

[!INCLUDE operator-next-x-hours-description]

[!INCLUDE operator-invalid-dateonly]

Data Type: Datetime

next-x-months

[!INCLUDE operator-next-x-months-description]

Data Type: Datetime

next-x-weeks

[!INCLUDE operator-next-x-weeks-description]

Data Type: Datetime

next-x-years

[!INCLUDE operator-next-x-years-description]

Data Type: Datetime

next-year

[!INCLUDE operator-next-year-description]

Data Type: Datetime

not-begin-with

[!INCLUDE operator-not-begin-with-description]

[!INCLUDE wildcard-string-operator]

Data Type: String

not-between

[!INCLUDE operator-not-between-description]

Data Types:

Number
Datetime

not-contain-values

[!INCLUDE operator-not-contain-values-description]

Data Type: Choice

not-end-with

[!INCLUDE operator-not-end-with-description]

[!INCLUDE wildcard-string-operator]

Data Type: String

not-in

[!INCLUDE operator-not-in-description]

Data Type: Number

not-like

[!INCLUDE operator-not-like-description]

[!INCLUDE wildcard-string-operator]

Data Type: String

not-null

[!INCLUDE operator-not-null-description]

Data Types:

Choice
Datetime
Hierarchical
Number
Owner
String
Unique Identifier

not-under

[!INCLUDE operator-not-under-description]

Learn more about querying hierarchical data

Data Type: Hierarchical

null

[!INCLUDE operator-null-description]

Data Types:

Choice
Datetime
Hierarchical
Number
Owner
String
Unique Identifier

olderthan-x-days

[!INCLUDE operator-olderthan-x-days-description]

Data Type: Datetime

olderthan-x-hours

[!INCLUDE operator-olderthan-x-hours-description]

[!INCLUDE operator-invalid-dateonly]

Data Type: Datetime

olderthan-x-minutes

[!INCLUDE operator-olderthan-x-minutes-description]

[!INCLUDE operator-invalid-dateonly]

The following example shows a FetchXML query that returns incidents that are older than 30 minutes.

<fetch>
   <entity name="incident">
      <attribute name="title" />
      <attribute name="ticketnumber" />
      <attribute name="createdon" />
      <attribute name="incidentid" />
      <filter type="and">
         <condition attribute="createdon"
            operator="olderthan-x-minutes"
            value="30" />
      </filter>
   </entity>
</fetch>