--- sourceDocument: Australia ServiceNow AI Platform user interface sourceDocumentLink: https://www.servicenow.com/docs/r/platform-user-interface Release : - australia ft:locale : - en-US ft:publication_title : - Australia ServiceNow AI Platform user interface ft:clusterId : - platux bundleId : - platux workflow : - Platform --- # Operators available for filters and queries # Operators available for filters and queries {#ariaid-title1} * Release version: Australia * * Updated March 12, 2026 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 15 minutes to read 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 {#r_OpAvailableFiltersQueries__section_jdp_ltb_tdc} {#r_OpAvailableFiltersQueries__table_jb1_r21_ft__entry__5} | Operator label | Example condition | Equivalent query operator | Example query | Example output | |-|-|-|-|-| | AND | \[Active\]\[is\]\[True\]\[AND\]\[Caller\]\[is not empty\] | \^ | active=true\^CallerISNOTEMPTY | All records that have both of the following: * Active field is True * Caller field has any value {#r_OpAvailableFiltersQueries__ul_lnn_gvg_kgb} | | OR condition | \[Short description\]\[is empty\]\[OR\]\[Description\]\[is empty\] | \^OR | short_descriptionISEMPTY\^ORdescriptionISEMPTY | All records that have at least one of the following: * Short description field has no value * Description field has no value {#r_OpAvailableFiltersQueries__ul_pc5_3vg_kgb} | | OR filter | All these conditions must be met \[Short description\]\[is empty\] OR all these conditions must be met \[Description\]\[is not empty\] | \^NQ new query | short_descriptionISEMPTY\^NQdescriptionISNOTEMPTY | All records that have at least one of the following: * Short description field has no value * Description field has no value {#r_OpAvailableFiltersQueries__ul_ifv_gyp_lgb} | [Table 1. Operators available for condition builders] {#r_OpAvailableFiltersQueries__table_jb1_r21_ft} ## Operators available for string fields {#r_OpAvailableFiltersQueries__section_k1v_ntb_tdc} {#r_OpAvailableFiltersQueries__table_egn_qcy_dt__entry__5} | Operator label | Example condition | Equivalent query operator | Example query | Example output | |-|-|-|-|-| | starts with | \[Short description\]\[starts with\]\[SAP\] | STARTSWITH | short_descriptionSTARTSWITHSAP | All records in which the characters "SAP" appear at the beginning of the value for the Short description field. | | ends with | \[Short description\]\[ends with\]\[outage\] | * % * ENDSWITH {#r_OpAvailableFiltersQueries__ul_hdr_mdy_dt} | short_descriptionENDSWITHoutage | All records in which the string "outage" appears at the end of the value for the Short description field. | | contains | \[Short description\]\[contains\]\[SAP\] | * \* * LIKE {#r_OpAvailableFiltersQueries__ul_iss_ndy_dt} | short_descriptionLIKESAP | All records in which the characters "SAP" appear anywhere in the value for the Short description field. | | does not contain | \[Short description\]\[does not contain\]\[SAP\] | * !\* * NOT LIKE {#r_OpAvailableFiltersQueries__ul_td4_4dy_dt} | short_descriptionNOT LIKESAP | All records in which the characters "SAP" do not appear anywhere in the value for the Short description field. | | is | \[Short description\]\[is\]\[Network storage unavailable\] | = | short_description=Network storage unavailable | All records in which the Short description says nothing else but "Network storage is unavailable." | | is not | \[Short description\]\[is not\]\[Network storage unavailable\] | != | short_description!=Network storage unavailable | All records in which the value for the Short description field says anything but "Network storage is unavailable." | | is empty | \[Short description\]\[is empty\] | ISEMPTY | short_descriptionISEMPTY | All records in which there is no value in the Short description field. | | is not empty | \[Short description\]\[is not empty\] | ISNOTEMPTY | short_descriptionISNOTEMPTY | All records in which there is any value in the Short description field. | | is anything | \[Short description\]\[is anything\] | ANYTHING | short_descriptionANYTHING | All records in which the Short description field is one of the following: * any value * empty * NULL {#r_OpAvailableFiltersQueries__ul_shl_hmv_ngb} | | is empty string | \[Short description\]\[is empty string\] | EMPTYSTRING | short_descriptionEMPTYSTRING | All records in which there is no value in the Short description field. | | less than or is | \[Short description\]\[less than or is\]\[s\] | \<= | short_descriptionlt;=s | 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" {#r_OpAvailableFiltersQueries__ul_op4_4n2_4gb} | | greater than or is | \[Short description\]\[greater than or is\]\[s\] | \>= | short_description\>=s | 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" {#r_OpAvailableFiltersQueries__ul_vng_rn2_4gb} | | between | \[Short description\]\[between\]\[q\] and \[t\] | BETWEEN | short_descriptionBETWEENq@t | All records in which the first letter in the Short description field is "q," "r," "s," or "t." | | is same | \[Short description\]\[is same\] as \[Description\] | SAMEAS | short_descriptionSAMEASdescription | All records in which there exist matching values for the Short description and Description fields. | | is different | \[Short description\]\[is different\] from \[Description\] | NSAMEAS | short_descriptionNSAMEASdescription | All records in which there exist differing values for the Short description and Description fields. | [Table 2. Operators available for string fields] {#r_OpAvailableFiltersQueries__table_egn_qcy_dt} ## Operators available for reference fields {#r_OpAvailableFiltersQueries__section_am4_w5b_tdc} {#r_OpAvailableFiltersQueries__table_cz1_q2y_dt__entry__5} | Operator label | Example condition | Equivalent query operator | Example query | Example output | |-|-|-|-|-| | is | \[Caller\]\[is\]\[Don Goodliffe\] | = | caller_id=9ee1b13dc6112271007f9d0efdb69cd0 | All records in which the Caller is no one else but Don Goodliffe. | | is not | \[Caller\]\[is not\]\[Don Goodliffe\] | != | caller_id!=9ee1b13dc6112271007f9d0efdb69cd0 | All records in which the Caller field is populated by any user record but Don Goodliffe. | | is empty | \[Caller\]\[is empty\] | ISEMPTY | caller_idISEMPTY | All records in which the Caller field has no value. | | is not empty | \[Caller\]\[is not empty\] | ISNOTEMPTY | caller_idISNOTEMPTY | All records in which there is any value in the Caller field. | | starts with | \[Caller\]\[starts with\]\[Don\] | STARTSWITH | caller_idSTARTSWITHDon | All records in which the name in the Caller field begins with "Don." | | ends with | \[Caller\]\[ends with\]\[liffe\] | * % * ENDSWITH {#r_OpAvailableFiltersQueries__ul_mmz_wgy_dt} | caller_idENDSWITHliffe | All records in which the name in the Caller field has the letters "liffe" at the end. | | contains | \[Caller\]\[contains\]\[on\] | * \* * LIKE {#r_OpAvailableFiltersQueries__ul_en4_xgy_dt} | caller_idLIKEon | All records in which the characters "on" appear anywhere in the name for the Caller field. | | does not contain | \[Caller\]\[does not contain\]\[on\] | * !\* * NOT LIKE {#r_OpAvailableFiltersQueries__ul_sdd_ygy_dt} | caller_idNOT LIKEon | All records in which the characters "on" do not appear anywhere in the name for the Caller field. | | is anything | \[Caller\]\[is anything\] | ANYTHING | caller_idANYTHING | All records in which the Caller field is one of the following: * any value * empty * NULL {#r_OpAvailableFiltersQueries__ul_kdp_3mv_ngb} | | is same | \[Caller\]\[is same\] as \[Assigned to\] | SAMEAS | caller_idSAMEASassigned_to | All records in which the same user record is referenced in the Caller and Assigned to fields. | | is different | \[Caller\]\[is different\] from \[Assigned to\] | NSAMEAS | caller_idNSAMEASassigned_to | All records in which the user records in the Caller and Assigned to fields do no match. | | is empty string | \[Caller\]\[is empty string\] | EMPTYSTRING | caller_idEMPTYSTRING | All records in which the Caller field has no value. | | is (dynamic) | \[Caller\]\[is (dynamic)\]\[Me\] | DYNAMIC | caller_idDYNAMIC54635e965f510100a9ad2572f2b4774c | All records in which your user record populates the Caller field. | | is in hierarchy | \[Manager\]\[is in hierarchy\]\[Manager Hierarchy\] starting at \[Don Goodliffe\] which is \[Included\] | IN_HIERARCHY | managerIN_HIERARCHYfdd0fa0f93f5d2505bd0bd886cba1015%409ee1b13dc6112271007f9d0efdb69cd0 | All records throughout the Manager hierarchy in which the manager is Don Goodliffe or a user reporting up to Don Goodliffe. | | is in hierarchy (dynamic) | \[Manager\]\[is in hierarchy (dynamic)\]\[Manager Hierarchy\] starting at \[Me\] which is \[Included\] | IN_HIERARCHY_DYNAMIC | managerIN_HIERARCHY_DYNAMICfdd0fa0f93f5d2505bd0bd886cba1015%4090d1921e5f510100a9ad2572f2b477fe | 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 [Building hierarchical queries](https://www.servicenow.com/docs/access?context=data-hierarchies&version=australia&pubname=australia-platform-administration&ft:locale=en-US). | [Table 3. Operators available for reference fields] {#r_OpAvailableFiltersQueries__table_cz1_q2y_dt} 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 {#r_OpAvailableFiltersQueries__section_dgv_fvb_tdc} {#r_OpAvailableFiltersQueries__table_mjd_4fy_dt__entry__5} | Operator label | Example condition | Equivalent query operator | Example query | Example output | |-|-|-|-|-| | is | \[Subcategory\]\[is\]\[Email\] | = | subcategory=email | All records in which the Subcategory is nothing else but Email. | | is not | \[Subcategory\]\[is not\]\[Email\] | != | subcategory!=email | All records in which the Subcategory field is populated by any value except Email. | | is one of | \[Subcategory\]\[is one of\]\[DB2, MS SQL Server, Oraclel\] | IN | subcategoryINdb2,sql server,oracle | All records in which the Subcategory field is populated by one of the following values: * DB2 * MS SQL Server * Oraclel {#r_OpAvailableFiltersQueries__ul_s4m_w1h_kgb} | | is not one of | \[Subcategory\]\[is not one of\]\[DB2, MS SQL Server, Oraclel\] | NOT IN | subcategoryNOT INdb2,sql server,oracle | All records in which the Subcategory field is populated by anything except the following values: * DB2 * MS SQL Server * Oraclel {#r_OpAvailableFiltersQueries__ul_spp_fbh_kgb} | | contains | \[Subcategory\]\[contains\]\[Em\] | LIKE | subcategoryLIKEem | All records in which the characters "Em" appear anywhere in the value for the Subcategory field. | | starts with | \[Subcategory\]\[starts with\]\[Em\] | STARTSWITH | subcategorySTARTSWITHem | All records in which the characters "Em" appear at the beginning of the value for the Subcategory field. | | ends with | \[Subcategory\]\[ends with\]\[il\] | * % * ENDSWITH {#r_OpAvailableFiltersQueries__ul_ekb_wgy_dt} | subcategoryENDSWITHil | All records in which the characters "il" appear at the end of the value for the Subcategory field. | | does not contain | \[Subcategory\]\[does not contain\]\[Em\] | NOT LIKE | subcategoryNOT LIKEem | All records in which the characters "Em" do not appear anywhere in the value for the Subcategory field. | | is anything | \[Subcategory\]\[is anything\] | ANYTHING | subcategoryANYTHING | All records in which the Subcategory field is one of the following: * any value * empty * NULL {#r_OpAvailableFiltersQueries__ul_z2j_ylv_ngb} | | is same | \[Subcategory\]\[is same\] as \[Category\] | SAMEAS | subcategorySAMEAScategory | All records in which there exist matching values for the Subcategory and Category fields. | | is different | \[Subcategory\]\[is different\] from \[Category\] | NSAMEAS | subcategoryNSAMEAScategory | All records in which there exist differing values for the Subcategory and Category fields. | [Table 4. Operators available for choice fields containing strings] {#r_OpAvailableFiltersQueries__table_mjd_4fy_dt} ## Operators available for choice fields containing integers {#r_OpAvailableFiltersQueries__section_pgq_hvb_tdc} {#r_OpAvailableFiltersQueries__table_b5h_hgy_dt__entry__5} | Operator label | Example condition | Equivalent query operator | Example query | Example output | |-|-|-|-|-| | is | \[Impact\]\[is\]\[1 - High\] | = | impact=1 | All records in which the value in the Impact field is nothing else but 1 - High. | | is not | \[Impact\]\[is not\]\[1 - High\] | != | impact!=1 | All records in which the value in the Impact field is anything but 1 - High. | | is one of | \[Impact\]\[is one of\]\[1 - High, 2 - Medium\] | IN | impactIN1,2 | All records in which the Impact field is populated by one of the following values: * 1 - High * 2 - Medium {#r_OpAvailableFiltersQueries__ul_s4b_gdh_kgb} | | is not one of | \[Impact\]\[is not one of\]\[1 - High, 2 - Medium\] | NOT IN | impactNOT IN1,2 | All records in which the Impact field is populated by anything except the following values: * 1 - High * 2 - Medium {#r_OpAvailableFiltersQueries__ul_t53_jdh_kgb} | | is empty | \[Impact\]\[is empty\] | EMPTY | impactISEMPTY | All records in which the Impact field has no value. | | is not empty | \[Impact\]\[is not empty\] | NOTEMPTY | impactISNOTEMPTY | All records in which the Impact field has any value. | | less than | \[Impact\]\[less than\]\[2 - Medium\] | \< | impact\<2 | All records in which the Impact field has a value of 1 - High. | | greater than | \[Impact\]\[greater than\]\[2 - Medium\] | \> | impact\>2 | All records in which the Impact field has a value of 3 - Low | | less than or is | \[Impact\]\[less than or is\]\[2 - Medium\] | \<= | impact\<=2 | All records in which the Impact field has a value of 1 - High or 2 - Medium. | | greater than or is | \[Impact\]\[greater than or is\]\[2 - Medium\] | \>= | impact\>=2 | All records in which the Impact field has a value of 2 - Medium or 3 - Low. | | between | \[Impact\]\[between\]\[1 - High\] and \[3 - Low\] | BETWEEN | impactBETWEEN1@2 | All records in which the Impact field has one of the following values: * 1 - High * 2 - Medium * 3 - Low {#r_OpAvailableFiltersQueries__ul_bqh_kjv_ngb}. | | is anything | \[Impact\]\[is anything\] | ANYTHING | impactANYTHING | All records in which the Impact field is one of the following: * any value * empty * NULL {#r_OpAvailableFiltersQueries__ul_oz4_bmv_ngb} | | is same | \[Impact\]\[is same\] as \[Urgency\] | SAMEAS | impactSAMEASurgency | All records in which there exist matching values for the Impact and Urgency fields. | | is different | \[Impact\]\[is different\] from \[Urgency\] | NSAMEAS | impactNSAMEASurgency | All records in which there exist differing values for the Impact and Urgency fields. | [Table 5. Operators available for choice fields containing integers] {#r_OpAvailableFiltersQueries__table_b5h_hgy_dt} 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 {#r_OpAvailableFiltersQueries__section_jqy_mvb_tdc} {#r_OpAvailableFiltersQueries__table_url_chy_dt__entry__5} | Operator label | Example condition | Equivalent query operator | Example query | Example output | |-|-|-|-|-| | on | \[SLA due\]\[on\]\[Today\] | ONToday | sla_dueONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0) | All records in which the value for the SLA due field matches the date for today. | | not on | \[SLA due\]\[not on\]\[Today\] | NOTONToday | sla_dueNOTONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0) | All records in which the value for the SLA due field is any other date but today. | | before | \[SLA due\]\[before\]\[Today\] | \< | sla_due\ | sla_due\>javascript:gs.daysAgoEnd(0) | All records in which the value for the SLA due field is any date after today. | | at or after | \[SLA due\]\[at or after\]\[Today\] | \>= | sla_due\>=javascript:gs.daysAgoStart(0) | All records in which the date value for the SLA due field is one of the following: * today * any date after today {#r_OpAvailableFiltersQueries__ul_td1_rqp_lgb} | | between | \[SLA due\]\[between\]\[Yesterday\] and \[Today\] | BETWEEN | sla_dueBETWEENjavascript:gs.daysAgoStart(1)@javascript:gs.daysAgoEnd(0) | All records in which the value for the SLA due field is either yesterday's or today's date. | | trend (on or after) | \[SLA due\]\[trend\]\[on or after\]\[Monday\] | DATEPART | sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GE') | All records in which the date in the SLA due field is on any day of the week except a Sunday. | | trend (on or before) | \[SLA due\]\[trend\]\[on or before\]\[Monday\] | DATEPART | sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','LE') | All records in which the date in the SLA due field is on either a Sunday or a Monday. | | trend (after) | \[SLA due\]\[trend\]\[after\]\[Monday\] | DATEPART | sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GT') | All records in which the date in the SLA due field is on any day of the week except a Sunday or a Monday. | | trend (before) | \[SLA due\]\[trend\]\[before\]\[Monday\] | DATEPART | sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','LT') | All records in which the date in the SLA due field is on a Sunday. | | trend (on) | \[SLA due\]\[trend\]\[on\]\[Monday\] | DATEPART | sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','EE') | All records in which the date in the SLA due field is on a Monday. | | relative (after) | \[SLA due\]\[relative\]\[after\]\[1\]\[Hours\]\[ago\] | RELATIVEGT | sla_dueRELATIVEGT@hour@ago@1 | 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. | | relative (before) | \[SLA due\]\[relative\]\[before\]\[1\]\[Hours\]\[ago\] | RELATIVELT | sla_dueRELATIVELT@hour@ago@1 | All records in which the time on the SLA due field is less than an hour before the time that you entered the query. | | is empty | \[SLA due\]\[is empty\] | ISEMPTY | sla_dueISEMPTY | All records in which the SLA due field has no value. | | is not empty | \[SLA due\]\[is not empty\] | ISNOTEMPTY | sla_dueISNOTEMPTY | All records in which the SLA due is populated by any value. | | is anything | \[SLA due\]\[is anything\] | ANYTHING | sla_dueANYTHING | All records in which the SLA due field is one of the following: * any value * empty * NULL {#r_OpAvailableFiltersQueries__ul_w4d_dmv_ngb} | | is same | \[SLA due\]\[is same\] as \[Activity due\] | SAMEAS | sla_dueSAMEASactivity_due@day | All records in which there are matching values for the SLA due and Activity due fields. | | is different | \[SLA due\]\[is different\] from \[Activity due\] | NSAMEAS | sla_dueNSAMEASactivity_due@day | All records in which there are differing values for the SLA due and Activity due fields. | | is more than | \[SLA due\]\[is more than\]\[1\]\[Days\]\[before\]\[Activity due\] | MORETHAN | sla_dueMORETHANactivity_due@day@before@1 | 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. | | is less than | \[SLA due\]\[is less than\]\[3\]\[Days\]\[before\]\[Activity due\] | LESSTHAN | sla_dueLESSTHANactivity_due@day@before@3 | 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. | [Table 6. Operators available for date-time fields] {#r_OpAvailableFiltersQueries__table_url_chy_dt} ## Operators available for numeric fields {#r_OpAvailableFiltersQueries__section_cdd_pvb_tdc} {#r_OpAvailableFiltersQueries__table_yz1_shy_dt__entry__5} | Operator label | Example condition | Equivalent query operator | Example query | Example output | |-|-|-|-|-| | is | \[Reassignment count\]\[is\]\[0\] | = | reassignment_count=0 | All records in which the Reassignment count is nothing else but 0. | | is not | \[Reassignment count\]\[is not\]\[0\] | != | reassignment_count!=0 | All records in which the value for the Reassignment count is any number but 0. | | is empty | \[Reassignment count\]\[is empty\] | EMPTY | reassignment_countISEMPTY | All records in which there is no value in the Reassignment count field. | | is not empty | \[Reassignment count\]\[is not empty\] | NOTEMPTY | reassignment_countISNOTEMPTY | All records in which there is any number in the Reassignment count field. | | less than | \[Reassignment count\]\[less than\]\[2\] | \< | reassignment_count\<2 | All records in which the value in the Reassignment count field is any number less than (but not equal to) 2. | | greater than | \[Reassignment count\]\[greater than\]\[2\] | \> | reassignment_count\>2 | All records in which the value in the Reassignment count field is any number greater than (but not equal to) 2. | | less than or is | \[Reassignment count\]\[less than or is\]\[2\] | \<= | reassignment_count\<=2 | All records in which the value in the Reassignment count field is one of the following: * a number less than 2 * 2 {#r_OpAvailableFiltersQueries__ul_jcp_ttp_lgb} | | greater than or is | \[Reassignment count\]\[greater than or is\]\[2\] | \>= | reassignment_count\>=2 | All records in which the value in the Reassignment count field is one of the following: * 2 * a number greater than 2 {#r_OpAvailableFiltersQueries__ul_m3w_vtp_lgb} | | between | \[Reassignment count\]\[between\]\[1\] and \[3\] | BETWEEN | reassignment_countBETWEEN1@3 | All records in which the number in the Reassignment count is either 1, 2, or 3. | | is anything | \[Reassignment count\]\[is anything\] | ANYTHING | reassignment_countANYTHING | All records in which the Reassignment count field is one of the following: * any value * empty * NULL {#r_OpAvailableFiltersQueries__ul_uyb_2mv_ngb} | | is same | \[Reassignment count\]\[is same\] as \[Reopen count\] | SAMEAS | reassignment_countSAMEASreopen_count | All records in which there are matching numbers for the Reassignment count and Reopen count fields. | | is different | \[Reassignment count\]\[is different\] from \[Reopen count\] | NSAMEAS | reassignment_countNSAMEASreopen_count | All records in which there are differing values between the Reassignment count and Reopen count fields. | | greater than field | \[Reassignment count\]\[greater than field\]\[Reopen count\] | GT_FIELD | reassignment_countGT_FIELDreopen_count | 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. | | less than field | \[Reassignment count\]\[less than field\]\[Reopen count\] | LT_FIELD | reassignment_countLT_FIELDreopen_count | 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. | | greater than or is field | \[Reassignment count\]\[greater than or is field\]\[Reopen count\] | GT_OR_EQUALS_FIELD | reassignment_countGT_OR_EQUALS_FIELDreopen_count | 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 {#r_OpAvailableFiltersQueries__ul_wnl_ykv_ngb} | | less than or is field | \[Reassignment count\]\[less than or is field\]\[Reopen count\] | LT_OR_EQUALS_FIELD | reassignment_countLT_OR_EQUALS_FIELDreopen_count | 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 {#r_OpAvailableFiltersQueries__ul_yhz_blv_ngb} | [Table 7. Operators available for numeric fields] {#r_OpAvailableFiltersQueries__table_yz1_shy_dt} ## Operators available for Boolean fields {#r_OpAvailableFiltersQueries__section_ovs_qvb_tdc} {#r_OpAvailableFiltersQueries__table_vfm_d3y_dt__entry__5} | Operator label | Example condition | Equivalent query operator | Example query | Example output | |-|-|-|-|-| | is | \[Active\]\[is\]\[true\] | = | active=true | All records in which the Active field is True. | | is not | \[Active\]\[is not\]\[true\] | != | active!=true | All records in which the Active field is False, empty, or NULL. | | is empty | \[Active\]\[is empty\] | ISEMPTY | activeISEMPTY | All records in which there is no value in the Active field. | | is not empty | \[Active\]\[is not empty\] | ISNOTEMPTY | activeISNOTEMPTY | All records in which the Active field is either True or False. | | is anything | \[Active\]\[is anything\] | ANYTHING | activeANYTHING | All records in which the Active field is one of the following: * True * False * empty * NULL {#r_OpAvailableFiltersQueries__ul_s3h_fmv_ngb} | | is same | \[Active\]\[is same\] as \[Made SLA\] | SAMEAS | activeSAMEASmade_sla | All records in which there are matching values for the Active and Made SLA fields. | | is different | \[Active\]\[is different\] from \[Made SLA\] | NSAMEAS | activeNSAMEASmade_sla | All records in which there are differing values for the Active and Made SLA fields. | [Table 8. Operators available for Boolean fields] {#r_OpAvailableFiltersQueries__table_vfm_d3y_dt} ## Operators available for email notifications {#r_OpAvailableFiltersQueries__section_vqt_tvb_tdc} {#r_OpAvailableFiltersQueries__table_wqc_x3y_dt__entry__5} | 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. | [Table 9. Operators available for email notifications] {#r_OpAvailableFiltersQueries__table_wqc_x3y_dt} ## Operators available for tags {#r_OpAvailableFiltersQueries__section_jnf_2wb_tdc} {#r_OpAvailableFiltersQueries__table_add_cbc_tdc__entry__5} | 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. | [Table 10. Operators available for tags] {#r_OpAvailableFiltersQueries__table_add_cbc_tdc} **Related concepts** * [Condition builder](https://www.servicenow.com/docs/IIN4hZqrIKyLkjH1bZU7hA "A condition builder constructs a condition statement with a series of contextually generated fields. Condition builders are used in many operations, such as creating filters, administering surveys, and administering access control.")