Using operators in the Filter Builder
Updated in 8.4
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.19. |
|
is greater than |
TRUE if the field value is greater than the specified one. |
Complete Date is greater than 01.02.19. |
|
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.19. |
|
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. |