AustraliaREFERENCE GUIDE

Operators available for filters and queries

ServiceNow documentation·17 min readView source ↗

On this page

Operators available for filters and queries

The system provides a set of operators for use with filters, condition builders, and encoded queries. The data type of a field determines what operators are available for it.

Operators available for condition builders

Operator label

</th><th>

Example condition

</th><th>

Equivalent query operator

</th><th>

Example query

</th><th>

Example output

</th></tr></thead><tbody><tr><td>

AND

</td><td>

[Active][is][True][AND][Caller][is not empty]

</td><td>

active=true^CallerISNOTEMPTY

</td><td>

All records that have both of the following:- Active field is True - Caller field has any value

</td></tr><tr><td>

OR condition

</td><td>

[Short description][is empty][OR][Description][is empty]

</td><td>

^OR

</td><td>

short_descriptionISEMPTY^ORdescriptionISEMPTY

</td><td>

All records that have at least one of the following:- Short description field has no value - Description field has no value

</td></tr><tr><td>

OR filter

</td><td>

All these conditions must be met

[Short description][is empty]

OR all these conditions must be met

[Description][is not empty]

</td><td>

^NQ

new query

</td><td>

short_descriptionISEMPTY^NQdescriptionISNOTEMPTY

</td><td>

All records that have at least one of the following:- Short description field has no value - Description field has no value

</td></tr></tbody> </table>## Operators available for string fields

Operator label

</th><th>

Example condition

</th><th>

Equivalent query operator

</th><th>

Example query

</th><th>

Example output

</th></tr></thead><tbody><tr><td>

starts with

</td><td>

[Short description][starts with][SAP]

</td><td>

STARTSWITH

</td><td>

short_descriptionSTARTSWITHSAP

</td><td>

All records in which the characters “SAP” appear at the beginning of the value for the Short description field.

</td></tr><tr><td>

ends with

</td><td>

[Short description][ends with][outage]

</td><td>

%
ENDSWITH

</td><td>

short_descriptionENDSWITHoutage

</td><td>

All records in which the string “outage” appears at the end of the value for the Short description field.

</td></tr><tr><td>

contains

</td><td>

[Short description][contains][SAP]

</td><td>

short_descriptionLIKESAP

</td><td>

All records in which the characters “SAP” appear anywhere in the value for the Short description field.

</td></tr><tr><td>

does not contain

</td><td>

[Short description][does not contain][SAP]

</td><td>

!*
NOT LIKE

</td><td>

short_descriptionNOT LIKESAP

</td><td>

All records in which the characters “SAP” do not appear anywhere in the value for the Short description field.

</td></tr><tr><td>

</td><td>

[Short description][is][Network storage unavailable]

</td><td>

short_description=Network storage unavailable

</td><td>

All records in which the Short description says nothing else but “Network storage is unavailable.”

</td></tr><tr><td>

is not

</td><td>

[Short description][is not][Network storage unavailable]

</td><td>

short_description!=Network storage unavailable

</td><td>

All records in which the value for the Short description field says anything but “Network storage is unavailable.”

</td></tr><tr><td>

is empty

</td><td>

[Short description][is empty]

</td><td>

ISEMPTY

</td><td>

short_descriptionISEMPTY

</td><td>

All records in which there is no value in the Short description field.

</td></tr><tr><td>

is not empty

</td><td>

[Short description][is not empty]

</td><td>

ISNOTEMPTY

</td><td>

short_descriptionISNOTEMPTY

</td><td>

All records in which there is any value in the Short description field.

</td></tr><tr><td>

is anything

</td><td>

[Short description][is anything]

</td><td>

ANYTHING

</td><td>

short_descriptionANYTHING

</td><td>

All records in which the Short description field is one of the following:- any value - empty - NULL

</td></tr><tr><td>

is empty string

</td><td>

[Short description][is empty string]

</td><td>

EMPTYSTRING

</td><td>

short_descriptionEMPTYSTRING

</td><td>

All records in which there is no value in the Short description field.

</td></tr><tr><td>

less than or is

</td><td>

[Short description][less than or is][s]

</td><td>

short_descriptionlt;=s

</td><td>

All records in which the string in the Short description field is one of the following:- the first letter is any letter between “a” and “s” - the exact value is “s”

</td></tr><tr><td>

greater than or is

</td><td>

[Short description][greater than or is][s]

</td><td>

short_description>=s

</td><td>

All records in which the string in the Short description field is one of the following:- the first letter is any letter between “s” and “z” - the exact value is “s”

</td></tr><tr><td>

between

</td><td>

[Short description][between][q] and [t]

</td><td>

BETWEEN

</td><td>

short_descriptionBETWEENq@t

</td><td>

All records in which the first letter in the Short description field is “q,” “r,” “s,” or “t.”

</td></tr><tr><td>

is same

</td><td>

[Short description][is same] as [Description]

</td><td>

SAMEAS

</td><td>

short_descriptionSAMEASdescription

</td><td>

All records in which there exist matching values for the Short description and Description fields.

</td></tr><tr><td>

is different

</td><td>

[Short description][is different] from [Description]

</td><td>

NSAMEAS

</td><td>

short_descriptionNSAMEASdescription

</td><td>

All records in which there exist differing values for the Short description and Description fields.

</td></tr></tbody> </table>## Operators available for reference fields

Operator label

</th><th>

Example condition

</th><th>

Equivalent query operator

</th><th>

Example query

</th><th>

Example output

</th></tr></thead><tbody><tr><td>

</td><td>

[Caller][is][Don Goodliffe]

</td><td>

caller_id=9ee1b13dc6112271007f9d0efdb69cd0

</td><td>

All records in which the Caller is no one else but Don Goodliffe.

</td></tr><tr><td>

is not

</td><td>

[Caller][is not][Don Goodliffe]

</td><td>

caller_id!=9ee1b13dc6112271007f9d0efdb69cd0

</td><td>

All records in which the Caller field is populated by any user record but Don Goodliffe.

</td></tr><tr><td>

is empty

</td><td>

[Caller][is empty]

</td><td>

ISEMPTY

</td><td>

caller_idISEMPTY

</td><td>

All records in which the Caller field has no value.

</td></tr><tr><td>

is not empty

</td><td>

[Caller][is not empty]

</td><td>

ISNOTEMPTY

</td><td>

caller_idISNOTEMPTY

</td><td>

All records in which there is any value in the Caller field.

</td></tr><tr><td>

starts with

</td><td>

[Caller][starts with][Don]

</td><td>

STARTSWITH

</td><td>

caller_idSTARTSWITHDon

</td><td>

All records in which the name in the Caller field begins with “Don.”

</td></tr><tr><td>

ends with

</td><td>

[Caller][ends with][liffe]

</td><td>

%
ENDSWITH

</td><td>

caller_idENDSWITHliffe

</td><td>

All records in which the name in the Caller field has the letters “liffe” at the end.

</td></tr><tr><td>

contains

</td><td>

[Caller][contains][on]

</td><td>

caller_idLIKEon

</td><td>

All records in which the characters “on” appear anywhere in the name for the Caller field.

</td></tr><tr><td>

does not contain

</td><td>

[Caller][does not contain][on]

</td><td>

!*
NOT LIKE

</td><td>

caller_idNOT LIKEon

</td><td>

All records in which the characters “on” do not appear anywhere in the name for the Caller field.

</td></tr><tr><td>

is anything

</td><td>

[Caller][is anything]

</td><td>

ANYTHING

</td><td>

caller_idANYTHING

</td><td>

All records in which the Caller field is one of the following:- any value - empty - NULL

</td></tr><tr><td>

is same

</td><td>

[Caller][is same] as [Assigned to]

</td><td>

SAMEAS

</td><td>

caller_idSAMEASassigned_to

</td><td>

All records in which the same user record is referenced in the Caller and Assigned to fields.

</td></tr><tr><td>

is different

</td><td>

[Caller][is different] from [Assigned to]

</td><td>

NSAMEAS

</td><td>

caller_idNSAMEASassigned_to

</td><td>

All records in which the user records in the Caller and Assigned to fields do no match.

</td></tr><tr><td>

is empty string

</td><td>

[Caller][is empty string]

</td><td>

EMPTYSTRING

</td><td>

caller_idEMPTYSTRING

</td><td>

All records in which the Caller field has no value.

</td></tr><tr><td>

is (dynamic)

</td><td>

[Caller][is (dynamic)][Me]

</td><td>

DYNAMIC

</td><td>

caller_idDYNAMIC54635e965f510100a9ad2572f2b4774c

</td><td>

All records in which your user record populates the Caller field.

</td></tr><tr><td>

is in hierarchy

</td><td>

[Manager][is in hierarchy][Manager Hierarchy] starting at [Don Goodliffe] which is [Included]

</td><td>

IN_HIERARCHY

</td><td>

managerIN_HIERARCHYfdd0fa0f93f5d2505bd0bd886cba1015%409ee1b13dc6112271007f9d0efdb69cd0

</td><td>

All records throughout the Manager hierarchy in which the manager is Don Goodliffe or a user reporting up to Don Goodliffe.

</td></tr><tr><td>

is in hierarchy (dynamic)

</td><td>

[Manager][is in hierarchy (dynamic)][Manager Hierarchy] starting at [Me] which is [Included]

</td><td>

IN_HIERARCHY_DYNAMIC

</td><td>

managerIN_HIERARCHY_DYNAMICfdd0fa0f93f5d2505bd0bd886cba1015%4090d1921e5f510100a9ad2572f2b477fe

</td><td>

All records throughout the Manager hierarchy in which the manager is you or a user reporting up to you.Note: A record hierarchy between related records in the same table must be established before you can use this operator. See .

</td></tr></tbody> </table>Note: Not all operators are available for all reference types. Depending on the reference you select, you may see a shorter list of operators.

Operators available for choice fields containing strings

Operator label

</th><th>

Example condition

</th><th>

Equivalent query operator

</th><th>

Example query

</th><th>

Example output

</th></tr></thead><tbody><tr><td>

</td><td>

[Subcategory][is][Email]

</td><td>

subcategory=email

</td><td>

All records in which the Subcategory is nothing else but Email.

</td></tr><tr><td>

is not

</td><td>

[Subcategory][is not][Email]

</td><td>

subcategory!=email

</td><td>

All records in which the Subcategory field is populated by any value except Email.

</td></tr><tr><td>

is one of

</td><td>

[Subcategory][is one of][DB2, MS SQL Server, Oraclel]

</td><td>

subcategoryINdb2,sql server,oracle

</td><td>

All records in which the Subcategory field is populated by one of the following values:- DB2 - MS SQL Server - Oraclel

</td></tr><tr><td>

is not one of

</td><td>

[Subcategory][is not one of][DB2, MS SQL Server, Oraclel]

</td><td>

NOT IN

</td><td>

subcategoryNOT INdb2,sql server,oracle

</td><td>

All records in which the Subcategory field is populated by anything except the following values:- DB2 - MS SQL Server - Oraclel

</td></tr><tr><td>

contains

</td><td>

[Subcategory][contains][Em]

</td><td>

subcategoryLIKEem

</td><td>

All records in which the characters “Em” appear anywhere in the value for the Subcategory field.

</td></tr><tr><td>

starts with

</td><td>

[Subcategory][starts with][Em]

</td><td>

STARTSWITH

</td><td>

subcategorySTARTSWITHem

</td><td>

All records in which the characters “Em” appear at the beginning of the value for the Subcategory field.

</td></tr><tr><td>

ends with

</td><td>

[Subcategory][ends with][il]

</td><td>

%
ENDSWITH

</td><td>

subcategoryENDSWITHil

</td><td>

All records in which the characters “il” appear at the end of the value for the Subcategory field.

</td></tr><tr><td>

does not contain

</td><td>

[Subcategory][does not contain][Em]

</td><td>

NOT LIKE

</td><td>

subcategoryNOT LIKEem

</td><td>

All records in which the characters “Em” do not appear anywhere in the value for the Subcategory field.

</td></tr><tr><td>

is anything

</td><td>

[Subcategory][is anything]

</td><td>

ANYTHING

</td><td>

subcategoryANYTHING

</td><td>

All records in which the Subcategory field is one of the following:- any value - empty - NULL

</td></tr><tr><td>

is same

</td><td>

[Subcategory][is same] as [Category]

</td><td>

SAMEAS

</td><td>

subcategorySAMEAScategory

</td><td>

All records in which there exist matching values for the Subcategory and Category fields.

</td></tr><tr><td>

is different

</td><td>

[Subcategory][is different] from [Category]

</td><td>

NSAMEAS

</td><td>

subcategoryNSAMEAScategory

</td><td>

All records in which there exist differing values for the Subcategory and Category fields.

</td></tr></tbody> </table>## Operators available for choice fields containing integers

Operator label

</th><th>

Example condition

</th><th>

Equivalent query operator

</th><th>

Example query

</th><th>

Example output

</th></tr></thead><tbody><tr><td>

</td><td>

[Impact][is][1 - High]

</td><td>

impact=1

</td><td>

All records in which the value in the Impact field is nothing else but 1 - High.

</td></tr><tr><td>

is not

</td><td>

[Impact][is not][1 - High]

</td><td>

impact!=1

</td><td>

All records in which the value in the Impact field is anything but 1 - High.

</td></tr><tr><td>

is one of

</td><td>

[Impact][is one of][1 - High, 2 - Medium]

</td><td>

impactIN1,2

</td><td>

All records in which the Impact field is populated by one of the following values:- 1 - High - 2 - Medium

</td></tr><tr><td>

is not one of

</td><td>

[Impact][is not one of][1 - High, 2 - Medium]

</td><td>

NOT IN

</td><td>

impactNOT IN1,2

</td><td>

All records in which the Impact field is populated by anything except the following values:- 1 - High - 2 - Medium

</td></tr><tr><td>

is empty

</td><td>

[Impact][is empty]

</td><td>

EMPTY

</td><td>

impactISEMPTY

</td><td>

All records in which the Impact field has no value.

</td></tr><tr><td>

is not empty

</td><td>

[Impact][is not empty]

</td><td>

NOTEMPTY

</td><td>

impactISNOTEMPTY

</td><td>

All records in which the Impact field has any value.

</td></tr><tr><td>

less than

</td><td>

[Impact][less than][2 - Medium]

</td><td>

impact<2

</td><td>

All records in which the Impact field has a value of 1 - High.

</td></tr><tr><td>

greater than

</td><td>

[Impact][greater than][2 - Medium]

</td><td>

impact>2

</td><td>

All records in which the Impact field has a value of 3 - Low

</td></tr><tr><td>

less than or is

</td><td>

[Impact][less than or is][2 - Medium]

</td><td>

impact<=2

</td><td>

All records in which the Impact field has a value of 1 - High or 2 - Medium.

</td></tr><tr><td>

greater than or is

</td><td>

[Impact][greater than or is][2 - Medium]

</td><td>

impact>=2

</td><td>

All records in which the Impact field has a value of 2 - Medium or 3 - Low.

</td></tr><tr><td>

between

</td><td>

[Impact][between][1 - High] and [3 - Low]

</td><td>

BETWEEN

</td><td>

impactBETWEEN1@2

</td><td>

All records in which the Impact field has one of the following values:- 1 - High - 2 - Medium - 3 - Low

</td></tr><tr><td>

is anything

</td><td>

[Impact][is anything]

</td><td>

ANYTHING

</td><td>

impactANYTHING

</td><td>

All records in which the Impact field is one of the following:- any value - empty - NULL

</td></tr><tr><td>

is same

</td><td>

[Impact][is same] as [Urgency]

</td><td>

SAMEAS

</td><td>

impactSAMEASurgency

</td><td>

All records in which there exist matching values for the Impact and Urgency fields.

</td></tr><tr><td>

is different

</td><td>

[Impact][is different] from [Urgency]

</td><td>

NSAMEAS

</td><td>

impactNSAMEASurgency

</td><td>

All records in which there exist differing values for the Impact and Urgency fields.

</td></tr></tbody> </table>Note: The operators ‘less than or is’ and ‘greater than or is’ are not supported for integer fields in the condition builder. Use a scripted condition instead.

Operators available for date-time fields

Operator label

</th><th>

Example condition

</th><th>

Equivalent query operator

</th><th>

Example query

</th><th>

Example output

</th></tr></thead><tbody><tr><td>

</td><td>

[SLA due][on][Today]

</td><td>

ONToday

</td><td>

sla_dueONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)

</td><td>

All records in which the value for the SLA due field matches the date for today.

</td></tr><tr><td>

not on

</td><td>

[SLA due][not on][Today]

</td><td>

NOTONToday

</td><td>

sla_dueNOTONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)

</td><td>

All records in which the value for the SLA due field is any other date but today.

</td></tr><tr><td>

before

</td><td>

[SLA due][before][Today]

</td><td>

sla_due<javascript:gs.daysAgoStart(0)

</td><td>

All records in which the value for the SLA due field is any date previous to today.

</td></tr><tr><td>

at or before

</td><td>

[SLA due][at or before][Today]

</td><td>

sla_due<=javascript:gs.daysAgoEnd(0)

</td><td>

All records in which the value for the SLA due field is one of the following:- any date previous to today - today

</td></tr><tr><td>

after

</td><td>

[SLA due][after][Today]

</td><td>

sla_due>javascript:gs.daysAgoEnd(0)

</td><td>

All records in which the value for the SLA due field is any date after today.

</td></tr><tr><td>

at or after

</td><td>

[SLA due][at or after][Today]

</td><td>

sla_due>=javascript:gs.daysAgoStart(0)

</td><td>

All records in which the date value for the SLA due field is one of the following:- today - any date after today

</td></tr><tr><td>

between

</td><td>

[SLA due][between][Yesterday] and [Today]

</td><td>

BETWEEN

</td><td>

sla_dueBETWEENjavascript:gs.daysAgoStart(1)@javascript:gs.daysAgoEnd(0)

</td><td>

All records in which the value for the SLA due field is either yesterday’s or today’s date.

</td></tr><tr><td>

trend (on or after)

</td><td>

[SLA due][trend][on or after][Monday]

</td><td>

DATEPART

</td><td>

sla_dueDATEPARTMonday@javascript:gs.datePart(‘dayofweek’,‘monday’,‘GE’)

</td><td>

All records in which the date in the SLA due field is on any day of the week except a Sunday.

</td></tr><tr><td>

trend (on or before)

</td><td>

[SLA due][trend][on or before][Monday]

</td><td>

DATEPART

</td><td>

sla_dueDATEPARTMonday@javascript:gs.datePart(‘dayofweek’,‘monday’,‘LE’)

</td><td>

All records in which the date in the SLA due field is on either a Sunday or a Monday.

</td></tr><tr><td>

trend (after)

</td><td>

[SLA due][trend][after][Monday]

</td><td>

DATEPART

</td><td>

sla_dueDATEPARTMonday@javascript:gs.datePart(‘dayofweek’,‘monday’,‘GT’)

</td><td>

All records in which the date in the SLA due field is on any day of the week except a Sunday or a Monday.

</td></tr><tr><td>

trend (before)

</td><td>

[SLA due][trend][before][Monday]

</td><td>

DATEPART

</td><td>

sla_dueDATEPARTMonday@javascript:gs.datePart(‘dayofweek’,‘monday’,‘LT’)

</td><td>

All records in which the date in the SLA due field is on a Sunday.

</td></tr><tr><td>

trend (on)

</td><td>

[SLA due][trend][on][Monday]

</td><td>

DATEPART

</td><td>

sla_dueDATEPARTMonday@javascript:gs.datePart(‘dayofweek’,‘monday’,‘EE’)

</td><td>

All records in which the date in the SLA due field is on a Monday.

</td></tr><tr><td>

relative (after)

</td><td>

[SLA due][relative][after][1][Hours][ago]

</td><td>

RELATIVEGT

</td><td>

sla_dueRELATIVEGT@hour@ago@1

</td><td>

All records in which the time on the SLA due field is no more than an hour before the time that you entered the query.

</td></tr><tr><td>

relative (before)

</td><td>

[SLA due][relative][before][1][Hours][ago]

</td><td>

RELATIVELT

</td><td>

sla_dueRELATIVELT@hour@ago@1

</td><td>

All records in which the time on the SLA due field is less than an hour before the time that you entered the query.

</td></tr><tr><td>

is empty

</td><td>

[SLA due][is empty]

</td><td>

ISEMPTY

</td><td>

sla_dueISEMPTY

</td><td>

All records in which the SLA due field has no value.

</td></tr><tr><td>

is not empty

</td><td>

[SLA due][is not empty]

</td><td>

ISNOTEMPTY

</td><td>

sla_dueISNOTEMPTY

</td><td>

All records in which the SLA due is populated by any value.

</td></tr><tr><td>

is anything

</td><td>

[SLA due][is anything]

</td><td>

ANYTHING

</td><td>

sla_dueANYTHING

</td><td>

All records in which the SLA due field is one of the following:- any value - empty - NULL

</td></tr><tr><td>

is same

</td><td>

[SLA due][is same] as [Activity due]

</td><td>

SAMEAS

</td><td>

sla_dueSAMEASactivity_due@day

</td><td>

All records in which there are matching values for the SLA due and Activity due fields.

</td></tr><tr><td>

is different

</td><td>

[SLA due][is different] from [Activity due]

</td><td>

NSAMEAS

</td><td>

sla_dueNSAMEASactivity_due@day

</td><td>

All records in which there are differing values for the SLA due and Activity due fields.

</td></tr><tr><td>

is more than

</td><td>

[SLA due][is more than][1][Days][before][Activity due]

</td><td>

MORETHAN

</td><td>

sla_dueMORETHANactivity_due@day@before@1

</td><td>

All records in which the date value for the SLA due field is two or more days previous to the date in the Activity due field.

</td></tr><tr><td>

is less than

</td><td>

[SLA due][is less than][3][Days][before][Activity due]

</td><td>

LESSTHAN

</td><td>

sla_dueLESSTHANactivity_due@day@before@3

</td><td>

All records in which the date value for the SLA due field is no more than three days prior to the date in the Activity due field.

</td></tr></tbody> </table>## Operators available for numeric fields

Operator label

</th><th>

Example condition

</th><th>

Equivalent query operator

</th><th>

Example query

</th><th>

Example output

</th></tr></thead><tbody><tr><td>

</td><td>

[Reassignment count][is][0]

</td><td>

reassignment_count=0

</td><td>

All records in which the Reassignment count is nothing else but 0.

</td></tr><tr><td>

is not

</td><td>

[Reassignment count][is not][0]

</td><td>

reassignment_count!=0

</td><td>

All records in which the value for the Reassignment count is any number but 0.

</td></tr><tr><td>

is empty

</td><td>

[Reassignment count][is empty]

</td><td>

EMPTY

</td><td>

reassignment_countISEMPTY

</td><td>

All records in which there is no value in the Reassignment count field.

</td></tr><tr><td>

is not empty

</td><td>

[Reassignment count][is not empty]

</td><td>

NOTEMPTY

</td><td>

reassignment_countISNOTEMPTY

</td><td>

All records in which there is any number in the Reassignment count field.

</td></tr><tr><td>

less than

</td><td>

[Reassignment count][less than][2]

</td><td>

reassignment_count<2

</td><td>

All records in which the value in the Reassignment count field is any number less than (but not equal to) 2.

</td></tr><tr><td>

greater than

</td><td>

[Reassignment count][greater than][2]

</td><td>

reassignment_count>2

</td><td>

All records in which the value in the Reassignment count field is any number greater than (but not equal to) 2.

</td></tr><tr><td>

less than or is

</td><td>

[Reassignment count][less than or is][2]

</td><td>

reassignment_count<=2

</td><td>

All records in which the value in the Reassignment count field is one of the following:- a number less than 2 - 2

</td></tr><tr><td>

greater than or is

</td><td>

[Reassignment count][greater than or is][2]

</td><td>

reassignment_count>=2

</td><td>

All records in which the value in the Reassignment count field is one of the following:- 2 - a number greater than 2

</td></tr><tr><td>

between

</td><td>

[Reassignment count][between][1] and [3]

</td><td>

BETWEEN

</td><td>

reassignment_countBETWEEN1@3

</td><td>

All records in which the number in the Reassignment count is either 1, 2, or 3.

</td></tr><tr><td>

is anything

</td><td>

[Reassignment count][is anything]

</td><td>

ANYTHING

</td><td>

reassignment_countANYTHING

</td><td>

All records in which the Reassignment count field is one of the following:- any value - empty - NULL

</td></tr><tr><td>

is same

</td><td>

[Reassignment count][is same] as [Reopen count]

</td><td>

SAMEAS

</td><td>

reassignment_countSAMEASreopen_count

</td><td>

All records in which there are matching numbers for the Reassignment count and Reopen count fields.

</td></tr><tr><td>

is different

</td><td>

[Reassignment count][is different] from [Reopen count]

</td><td>

NSAMEAS

</td><td>

reassignment_countNSAMEASreopen_count

</td><td>

All records in which there are differing values between the Reassignment count and Reopen count fields.

</td></tr><tr><td>

greater than field

</td><td>

[Reassignment count][greater than field][Reopen count]

</td><td>

GT_FIELD

</td><td>

reassignment_countGT_FIELDreopen_count

</td><td>

All records in which the number in the Reassignment count field is greater than (but not equal to) the number in the Reopen count field.

</td></tr><tr><td>

less than field

</td><td>

[Reassignment count][less than field][Reopen count]

</td><td>

LT_FIELD

</td><td>

reassignment_countLT_FIELDreopen_count

</td><td>

All records in which the number in the Reassignment count field is less than (but not equal to) the number in the Reopen count field.

</td></tr><tr><td>

greater than or is field

</td><td>

[Reassignment count][greater than or is field][Reopen count]

</td><td>

GT_OR_EQUALS_FIELD

</td><td>

reassignment_countGT_OR_EQUALS_FIELDreopen_count

</td><td>

All records in which the number in the Reassignment count field is one of the following:- greater than the number in the Reopen count field - equal to the number in the Reopen count field

</td></tr><tr><td>

less than or is field

</td><td>

[Reassignment count][less than or is field][Reopen count]

</td><td>

LT_OR_EQUALS_FIELD

</td><td>

reassignment_countLT_OR_EQUALS_FIELDreopen_count

</td><td>

All records in which the number in the Reassignment count field is one of the following:- less than the number in the Reopen count field - equal to the number in the Reopen count field

</td></tr></tbody> </table>## Operators available for Boolean fields

Operator label

</th><th>

Example condition

</th><th>

Equivalent query operator

</th><th>

Example query

</th><th>

Example output

</th></tr></thead><tbody><tr><td>

</td><td>

[Active][is][true]

</td><td>

active=true

</td><td>

All records in which the Active field is True.

</td></tr><tr><td>

is not

</td><td>

[Active][is not][true]

</td><td>

active!=true

</td><td>

All records in which the Active field is False, empty, or NULL.

</td></tr><tr><td>

is empty

</td><td>

[Active][is empty]

</td><td>

ISEMPTY

</td><td>

activeISEMPTY

</td><td>

All records in which there is no value in the Active field.

</td></tr><tr><td>

is not empty

</td><td>

[Active][is not empty]

</td><td>

ISNOTEMPTY

</td><td>

activeISNOTEMPTY

</td><td>

All records in which the Active field is either True or False.

</td></tr><tr><td>

is anything

</td><td>

[Active][is anything]

</td><td>

ANYTHING

</td><td>

activeANYTHING

</td><td>

All records in which the Active field is one of the following:- True - False - empty - NULL

</td></tr><tr><td>

is same

</td><td>

[Active][is same] as [Made SLA]

</td><td>

SAMEAS

</td><td>

activeSAMEASmade_sla

</td><td>

All records in which there are matching values for the Active and Made SLA fields.

</td></tr><tr><td>

is different

</td><td>

[Active][is different] from [Made SLA]

</td><td>

NSAMEAS

</td><td>

activeNSAMEASmade_sla

</td><td>

All records in which there are differing values for the Active and Made SLA fields.

</td></tr></tbody> </table>## Operators available for email notifications

Operator label Example condition Equivalent query operator Example query Example output changes [State][changes] VALCHANGES stateVALCHANGES All records in which the State field is updated. changes from [State][changes from][Awaiting User Info] CHANGESFROM stateCHANGESFROM4 All records in which the State field is updated to another value after previously being Awaiting User Info (4). changes to [State][changes to][Awaiting User Info] CHANGESTO stateCHANGESTO4 All records in which the State field is updated to Awaiting User Info (4) after previously being any other value.

Operators available for tags

Operator label Example condition Equivalent query operator Example query Example output have [Tag][have][Most Active] = sys_tags.6c361e12471331007f47563dbb9a7135=6c361e12471331007f47563dbb9a7135 All records that have the Tag in the value field. does not have [Tag][does not have][Most Active] DOESNOTHAVE sys_tags.6c361e12471331007f47563dbb9a7135DOESNOTHAVE6c361e12471331007f47563dbb9a7135 Any records that has a Tag except for the tag mentioned in the value field. excluding [Tag][excluding][Most Active] EXCLUDING sys_tags.6c361e12471331007f47563dbb9a7135EXCLUDING6c361e12471331007f47563dbb9a7135 All records with and without the Tag except for the tag mentioned in the value field.

Parent Topic:Create a condition statement using the condition builder

Related topics

{Condition builder}[]

Keep exploring.

Find another answer, or bring this documentation into your own tools.

Search the library →Read via the REST API ↗