The null operators search for the presence or absence of a value, but does not evaluate the value itself. Null values are attributes that are left blank.

For example, you perform a search against the following values:

not null — Return all objects that have any value entered in the Material field:

null — Return all objects that have no value entered in the Material field:

Returns values that are a precise match.

For example, you perform a search against the following values:

equals Steel — Return all objects with steel:

not Steel — Return all objects with any material other than steel:

Provide a list of possible values separated by the pipe character (‘|’) or a comma.

For example, you perform a search against the following values:

in contact matrix, Project Timeline — Return all objects with titles in the list:

not in contact matrix, Project Timeline — Return all objects with titles not in the list:

Search for string values, beginning at the start of the string and moving towards the end.

For example, you perform a search against the following values:

like app — Return all objects that have titles starting with “app”:

not like app — Return all objects which have titles that do not start with “app”:

like *9 — Return all objects with titles that include the number 9:

not like *9 — Return all objects with titles that do not include the number 9:

Return string values greater than or less than the string.

Strings are sorted by character value, starting with the first character in the string. Character value is assessed using printable ASCII code. For more information, see http://www.ascii-code.com/.

With some exceptions, the sort order is as follows: spaces < symbols < 0-9 < A-Z < a-z

For example, the following strings are sorted by value from smallest to largest:

For example, you and another user are responsible for evaluating budget requests submitted by individual employees. You have divided the work based on employee names. You are responsible for evaluating requests from employees whose name starts with A through L, and your coworker evaluates M through Z.

To complicate this, a random 5 character identifier is appended to the front of each submission. As a result, you have the following files:

> zzzzz M — Return strings with a larger character value:

>= zzzzz M — Return strings with a larger or equal character value:

< zzzzz M — Return strings with a smaller character value:

<= zzzzz M — Return strings with a smaller or equal character value:

Provide a list of possible values separated by the pipe character (‘|’).

For example, you perform a search against the following values:

in 10|16.25|585 — Return all objects with a listed cost:

not in 10|16.25|585 — Return all objects with a cost that is not in the list:

Search for numbers greater than or less than the supplied value.

For example, you perform a search against the following values:

> 462 — Return all objects with a cost greater than 462:

>= 462 — Return all objects with a cost greater than or equal to 462:

< 462 — Return all objects with a cost less than 462:

<= 462 — Return all objects with a cost less than or equal to 462:

Return dates within the given time period, including the selected dates.

For example, you perform a search against the following values:

between 2016-07-19 - 2016-08-05 — Return all tasks with deadlines between July 19 and August 5:

Return dates within a past time period.

For example, the current date is 15 July 2016 and you perform a search against the following values:

yesterday — Return all tasks with a July 14 deadline:

last week — Return all tasks with a deadline from July 3 through July 9:

last month — Return all tasks with a deadline in June 2016:

last quarter — Return all tasks with a deadline from April 2016 through June 2016:

last year — Return all tasks with a deadline in 2015:

Return dates within the current time period.

For example, the current date is 15 July 2016 and you perform a search against the following values:

today — Return all tasks with a July 15 deadline:

this week — Return all tasks with a deadline from July 10 through July 16:

this month — Return all tasks with a deadline in July 2016:

this quarter — Return all tasks with a deadline from July 2016 through September 2016:

this year — Return all tasks with a deadline in 2016:

Return dates within a future time period.

For example, the current date is 15 July 2016 and you perform a search against the following values:

tomorrow — Return all tasks with a July 16 deadline:

next week — Return all tasks with a deadline from July 17 through July 23:

next month — Return all tasks with a deadline in August 2016:

next quarter — Return all tasks with a deadline from October 2016 through December 2016:

next year — Return all tasks with a deadline in 2017:

Return dates before or after a specified date.

> 2016-06-21 — Return all tasks with a deadline after 21 June 2016:

>= 2016-06-21 — Return all tasks with a deadline on or after 21 June 2016:

< 2016-06-21 — Return all tasks with a deadline before 21 June 2016:

<= 2016-06-21 — Return all tasks with a deadline on or before 21 June 2016: