Using operators in the Filter Builder

The following tables describe the behavior of logical and comparison operators available in the Filter Builder.

Logical operators available for combining conditions and groups:

Logical Operator Behavior

all matched

TRUE if all nested conditions and subgroups return TRUE; otherwise, FALSE.

any matched

TRUE if at least one condition or a subgroup returns TRUE; otherwise, FALSE.

one failed

TRUE if at least one condition or subgroup returns FALSE; otherwise, FALSE.

all failed

TRUE if all conditions and subgroups return FALSE; otherwise, FALSE.

Comparison operators available for composing conditions:

Comparison Operator Behavior Usage example

equals

TRUE if the field value equals to the specified one.

Category equals Network.

does not equal

TRUE if the field value does not equal to the specified one.

Location does not equal <Current User Location>.

is less than

TRUE if the field value is less than the specified one.

Due Date is less than 11.05.11.

is less than or equal to

TRUE if the field value is less than or equals to the specified one.

Due Date is less than or equal to 03.01.11.

is greater than

TRUE if the field value is greater than the specified one.

Complete Date is greater than 01.02.11.

is greater than or equal to

TRUE if the field value is greater than or equals to the specified one.

Complete Date is greater than or equal to 09.08.11.

like

Similar to ”equals” but allows to use wildcards in the specified value: ”%” to represent any sequence of characters and ”_” to represent any single character.

Summary like %upgrade%.

not like

Similar to "does not equal" but allows to use wildcards in the specified value: "%" to represent any sequence of characters and "_" to represent any single character.

Summary not like %network%.

is blank

TRUE if the field is blank.

Assignee is blank.

is not blank

TRUE if the field is not blank.

Assignee Group is not blank

is yesterday

TRUE if the field value is equal to the yesterday date. Requires no arguments. Applicable to date/time fields only.

Submit Date is yesterday.

is today

TRUE if the field value is equal to the current date. Requires no arguments. Applicable to date/time fields only.

Modified Date is today.

is tomorrow

TRUE if the field value is equal to the tomorrow date. Requires no arguments. Applicable to date/time fields only.

Due Date is tomorrow.

is last week

TRUE if the field value belongs to the previous calendar week. Requires no arguments. Applicable to date/time fields only.

Created Date is last week.

is last two weeks

TRUE if the field value belongs to the previous two calendar weeks. Requires no arguments. Applicable to date/time fields only.

Created Date is last two weeks.

is last month

TRUE if the field value belongs to the previous calendar month. Requires no arguments. Applicable to date/time fields only.

Submit Date is last month.

is last year

TRUE if the field value belongs to the previous calendar year. Requires no arguments. Applicable to date/time fields only.

Submit Date is last year.

is last 7 days

TRUE if the field value is earlier than the current date by not more than 7 days. Applicable to date/time fields only.

Due Date is last 7 days.

is last 14 days

TRUE if the field value is earlier than the current date by not more than 14 days. Applicable to date/time fields only.

Created Date is last 14 days.

is last 30 days

TRUE if the field value is earlier than the current date by not more than 30 days. Applicable to date/time fields only.

Submit Date is last 30 days.

is this week

TRUE if the field value belongs to the current calendar week. Requires no arguments. Applicable to date/time fields only.

Due Date is this week.

is this month

TRUE if the field value belongs to the current calendar month. Requires no arguments. Applicable to date/time fields only.

Submit Date is this month.

is this year

TRUE if the field value belongs to the current calendar year. Requires no arguments. Applicable to date/time fields only.

Invoice Date is this year.

is next week

TRUE if the field value belongs to the next calendar week. Requires no arguments. Applicable to date/time fields only.

Due Date is next week.

is next two weeks

TRUE if the field value belongs to the next two calendar weeks. Requires no arguments. Applicable to date/time fields only.

Due Date is next two weeks.

is next month

TRUE if the field value belongs to the next calendar month. Requires no arguments. Applicable to date/time fields only.

Warranty Exp is next month.

is next year

TRUE if the field value belongs to the next calendar year. Requires no arguments. Applicable to date/time fields only.

Lease Return Date is next year.

in next 7 days

TRUE if the field value is greater than the current date by no more than 7 days. Applicable to date/time fields only.

Invoice Date is in next 7 days.

in next 14 days

TRUE if the field value is greater than the current date by no more than 14 days. Applicable to date/time fields only.

Due Date is in next 14 days.

in next 30 days

TRUE if the field value is greater than the current date by no more than 30 days. Applicable to date/time fields only.

Warranty Exp is in next 30 days.

in the past by no more than *** days

TRUE if the field value is earlier than the current date by not more than the specified number of days. Applicable to date/time fields only.

Due Date in the past by no more than 4 days.

in the future by no more than *** days

TRUE if the field value is greater than the current date by not more than the specified number of days. Applicable to date/time fields only.

Response Date in the future by no more than 2 days.

is before today by *** days or more

TRUE if the field value is earlier than the current date by the specified number of days or more. Applicable to date/time fields only.

Modified Date is before today by 3 days or more.

is after today by *** days or more

TRUE if the field value is greater than the current date by the specified number of days or more. Applicable to date/time fields only.

Completed Date is after today by 5 days or more.