<h2>Operators available for filters and queries</h2><br/><div style="overflow-x:auto"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head><meta content="text/html; charset=UTF-8" /><meta name="copyright" content="(C) Copyright 2024" /><meta name="DC.rights.owner" content="(C) Copyright 2024" /><meta name="generator" content="DITA-OT" /><meta name="DC.type" content="reference" /><meta name="DC.title" content="Operators available for filters and queries" /><meta name="abstract" content="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." /><meta name="description" content="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." /><meta name="DC.subject" content="operators, filters, Condition builders, encoded queries" /><meta name="keywords" content="operators, filters, Condition builders, encoded queries" /><meta name="DC.relation" scheme="URI" content="../../../use/common-ui-elements/task/create-cond-state-using-cond-build.html" /><meta name="DC.relation" scheme="URI" content="../../../administer/navigation-and-ui/concept/c_NavigationAndTheUserInterface.html" /><meta name="DC.relation" scheme="URI" content="../../../administer/general/concept/configure-uis-and-portals.html" /><meta name="DC.relation" scheme="URI" content="../../../get-started/servicenow-overview/concept/working-in-ui16-and-ui15.html" /><meta name="DC.relation" scheme="URI" content="../../../use/common-ui-elements/topic/p_CommonUIElements.html" /><meta name="DC.relation" scheme="URI" content="../../../use/common-ui-elements/concept/c_ConditionBuilder.html" /><meta name="DC.creator" content="Katherine Jackson" /><meta name="DC.creator" content="Phil Salzman" /><meta name="DC.creator" content="ServiceNow" /><meta name="DC.date.created" content="2023-08-03" /><meta name="DC.date.modified" content="2023-08-03" /><meta name="DC.format" content="XHTML" /><meta name="DC.identifier" content="r_OpAvailableFiltersQueries" /><link rel="stylesheet" type="text/css" href="../../../CSS/commonltr.css" /><title>Operators available for filters and queries</title></head><body id="r_OpAvailableFiltersQueries"> <div class="breadcrumb"><a class="link" href="../../../administer/navigation-and-ui/concept/c_NavigationAndTheUserInterface.html" title="Interact with Now Platform applications and data in the way that works best for you.">Configure user experiences</a> > <a class="link" href="../../../administer/general/concept/configure-uis-and-portals.html" title="Customize your interface to create an efficient, unique experience for users and customers.">Configure UIs and portals</a> > <a class="link" href="../../../get-started/servicenow-overview/concept/working-in-ui16-and-ui15.html" title="Learn about the features of the Core UI that predated Next Experience.">Working in Core UI</a> > <a class="link" href="../../../use/common-ui-elements/topic/p_CommonUIElements.html" title="This page lists common UI elements for the standard user interface.">Common UI elements</a> > </div> <h1 class="title topictitle1" id="ariaid-title1">Operators available for filters and queries</h1> <div class="body refbody"><p class="shortdesc">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.</p> <div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="r_OpAvailableFiltersQueries__table_jb1_r21_ft" class="table" frame="border" border="1" rules="all"><caption><span class="tablecap"><span class="table--title-label">Table 1. </span>Operators available for condition builders</span></caption><colgroup><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /></colgroup><thead class="thead" style="text-align:left;"><tr class="row"><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e100">Operator label</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e103">Example condition</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e106">Equivalent query operator</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e109">Example query</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e112">Example output</th></tr></thead><tbody class="tbody"><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e100 ">AND</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e103 ">[Active][is][True][AND][Caller][is not empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e106 ">^</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e109 ">active=true^CallerISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e112 ">All records that have both of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_lnn_gvg_kgb"><li class="li"><span class="ph uicontrol">Active</span> field is <span class="ph uicontrol">True</span></li><li class="li"><span class="ph uicontrol">Caller</span> field has any value</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e100 ">OR condition</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e103 ">[Short description][is empty][OR][Description][is empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e106 ">^OR</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e109 ">short_descriptionISEMPTY^ORdescriptionISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e112 ">All records that have at least one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_pc5_3vg_kgb"><li class="li"><span class="ph uicontrol">Short description</span> field has no value</li><li class="li"><span class="ph uicontrol">Description</span> field has no value</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e100 ">OR filter</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e103 "><p class="p">All these conditions must be met</p> <p class="p">[Short description][is empty]</p> <p class="p">OR all these conditions must be met</p> <p class="p">[Description][is not empty]</p> </td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e106 "><p class="p">^NQ</p> <p class="p">new query</p> </td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e109 ">short_descriptionISEMPTY^NQdescriptionISNONEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e112 ">All records that have at least one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_ifv_gyp_lgb"><li class="li"><span class="ph uicontrol">Short description</span> field has no value</li><li class="li"><span class="ph uicontrol">Description</span> field has no value</li></ul> </td></tr></tbody></table> </div> <div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="r_OpAvailableFiltersQueries__table_egn_qcy_dt" class="table" frame="border" border="1" rules="all"><caption><span class="tablecap"><span class="table--title-label">Table 2. </span>Operators available for string fields</span></caption><colgroup><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /></colgroup><thead class="thead" style="text-align:left;"><tr class="row"><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e251">Operator label</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e254">Example condition</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e257">Equivalent query operator</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e260">Example query</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e263">Example output</th></tr></thead><tbody class="tbody"><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">starts with</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][starts with][SAP]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">STARTSWITH</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionSTARTSWITHSAP</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which the characters "SAP" appear at the beginning of the value for the <span class="ph uicontrol">Short description</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">ends with</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][ends with][outage]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 "><ul class="ul" id="r_OpAvailableFiltersQueries__ul_hdr_mdy_dt"><li class="li">%</li><li class="li">ENDSWITH</li></ul> </td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionENDSWITHoutage</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which the string "outage" appears at the end of the value for the <span class="ph uicontrol">Short description</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">contains</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][contains][SAP]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 "><ul class="ul" id="r_OpAvailableFiltersQueries__ul_iss_ndy_dt"><li class="li">*</li><li class="li">LIKE</li></ul> </td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionLIKESAP</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which the characters "SAP" appear anywhere in the value for the <span class="ph uicontrol">Short description</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">does not contain</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][does not contain][SAP]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 "><ul class="ul" id="r_OpAvailableFiltersQueries__ul_td4_4dy_dt"><li class="li">!*</li><li class="li">NOT LIKE</li></ul> </td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionNOT LIKESAP</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which the characters "SAP" do not appear anywhere in the value for the <span class="ph uicontrol">Short description</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][is][Network storage unavailable]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_description=Network storage unavailable</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which the <span class="ph uicontrol">Short description</span> says nothing else but "Network storage is unavailable."</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">is not</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][is not][Network storage unavailable]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">!=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_description!=Network storage unavailable</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which the value for the <span class="ph uicontrol">Short description</span> field says anything but "Network storage is unavailable."</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">is empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][is empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">ISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which there is no value in the <span class="ph uicontrol">Short description</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">is not empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][is not empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">ISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which there is any value in the <span class="ph uicontrol">Short description</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">is anything</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][is anything]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">ANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which the <span class="ph uicontrol">Short description</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_shl_hmv_ngb"><li class="li">any value</li><li class="li">empty</li><li class="li">NULL</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">is empty string</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][is empty string]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">EMPTYSTRING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionEMPTYSTRING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which there is no value in the <span class="ph uicontrol">Short description</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">less than or is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][less than or is][s]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 "><=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionlt;=s</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which the string in the <span class="ph uicontrol">Short description</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_op4_4n2_4gb"><li class="li">the first letter is any letter between "a" and "s"</li><li class="li">the exact value is "s"</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">greater than or is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][greater than or is][s]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">>=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_description>=s</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which the string in the <span class="ph uicontrol">Short description</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_vng_rn2_4gb"><li class="li">the first letter is any letter between "s" and "z"</li><li class="li">the exact value is "s"</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">between</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][between][q] and [t]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">BETWEEN</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionBETWEENq@t</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which the first letter in the <span class="ph uicontrol">Short description</span> field is "q," "r," "s," or "t."</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">is same</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][is same] as [Description]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">SAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionSAMEASdescription</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which there exist matching values for the <span class="ph uicontrol">Short description</span> and <span class="ph uicontrol">Description</span> fields.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e251 ">is different</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e254 ">[Short description][is different] from [Description]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e257 ">NSAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e260 ">short_descriptionNSAMEASdescription</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e263 ">All records in which there exist differing values for the <span class="ph uicontrol">Short description</span> and <span class="ph uicontrol">Description</span> fields.</td></tr></tbody></table> </div> <div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="r_OpAvailableFiltersQueries__table_cz1_q2y_dt" class="table" frame="border" border="1" rules="all"><caption><span class="tablecap"><span class="table--title-label">Table 3. </span>Operators available for reference fields</span></caption><colgroup><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /></colgroup><thead class="thead" style="text-align:left;"><tr class="row"><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e666">Operator label</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e669">Example condition</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e672">Equivalent query operator</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e675">Example query</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e678">Example output</th></tr></thead><tbody class="tbody"><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][is][Don Goodliffe]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 ">=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_id=9ee1b13dc6112271007f9d0efdb69cd0</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the <span class="ph uicontrol">Caller</span> is no one else but Don Goodliffe.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">is not</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][is not][Don Goodliffe]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 ">!=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_id!=9ee1b13dc6112271007f9d0efdb69cd0</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the <span class="ph uicontrol">Caller</span> field is populated by any user record but Don Goodliffe.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">is empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][is empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 ">ISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the <span class="ph uicontrol">Caller</span> field has no value.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">is not empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][is not empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 ">ISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which there is any value in the <span class="ph uicontrol">Caller</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">starts with</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][starts with][Don]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 ">STARTSWITH</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idSTARTSWITHDon</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the name in the <span class="ph uicontrol">Caller</span> field begins with "Don."</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">ends with</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][ends with][liffe]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 "><ul class="ul" id="r_OpAvailableFiltersQueries__ul_mmz_wgy_dt"><li class="li">%</li><li class="li">ENDSWITH</li></ul> </td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idENDSWITHliffe</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the name in the <span class="ph uicontrol">Caller</span> field has the letters "liffe" at the end.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">contains</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][contains][on]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 "><ul class="ul" id="r_OpAvailableFiltersQueries__ul_en4_xgy_dt"><li class="li">*</li><li class="li">LIKE</li></ul> </td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idLIKEon</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the characters "on" appear anywhere in the name for the <span class="ph uicontrol">Caller</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">does not contain</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][does not contain][on]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 "><ul class="ul" id="r_OpAvailableFiltersQueries__ul_sdd_ygy_dt"><li class="li">!*</li><li class="li">NOTLIKE</li></ul> </td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idNOT LIKEon</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the characters "on" do not appear anywhere in the name for the <span class="ph uicontrol">Caller</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">is anything</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][is anything]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 ">ANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the <span class="ph uicontrol">Caller</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_kdp_3mv_ngb"><li class="li">any value</li><li class="li">empty</li><li class="li">NULL</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">is same</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][is same] as [Assigned to]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 ">SAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idSAMEASassigned_to</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the same user record is referenced in the <span class="ph uicontrol">Caller</span> and <span class="ph uicontrol">Assigned to</span> fields.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">is different</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][is different] from [Assigned to]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 ">NSAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idNSAMEASassigned_to</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the user records in the <span class="ph uicontrol">Caller</span> and <span class="ph uicontrol">Assigned to</span> fields do no match.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">is empty string</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][is empty string]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 ">EMPTYSTRING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idEMPTYSTRING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which the <span class="ph uicontrol">Caller</span> field has no value.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e666 ">is (dynamic)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e669 ">[Caller][is (dynamic)][Me]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e672 ">DYNAMIC</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e675 ">caller_idDYNAMIC54635e965f510100a9ad2572f2b4774c</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e678 ">All records in which your user record populates the <span class="ph uicontrol">Caller</span> field.</td></tr></tbody></table> </div> <div class="section"> <div class="p"><div class="note"><span class="notetitle">Note:</span> Not all operators are available for all reference types. Depending on the reference you select, you may see a shorter list of operators.</div> </div> </div> <div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="r_OpAvailableFiltersQueries__table_mjd_4fy_dt" class="table" frame="border" border="1" rules="all"><caption><span class="tablecap"><span class="table--title-label">Table 4. </span>Operators available for choice fields containing strings</span></caption><colgroup><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /></colgroup><thead class="thead" style="text-align:left;"><tr class="row"><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1030">Operator label</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1033">Example condition</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1036">Equivalent query operator</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1039">Example query</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1042">Example output</th></tr></thead><tbody class="tbody"><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][is][Email]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 ">=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategory=email</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which the <span class="ph uicontrol">Subcategory</span> is nothing else but <span class="ph uicontrol">Email</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">is not</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][is not][Email]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 ">!=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategory!=email</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which the <span class="ph uicontrol">Subcategory</span> field is populated by any value except <span class="ph uicontrol">Email</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">is one of</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][is one of][DB2, MS SQL Server, Oraclel]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 ">IN</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategoryINdb2,sql server,oracle</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which the <span class="ph uicontrol">Subcategory</span> field is populated by one of the following values:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_s4m_w1h_kgb"><li class="li">DB2</li><li class="li">MS SQL Server</li><li class="li">Oraclel</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">is not one of</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][is not one of][DB2, MS SQL Server, Oraclel]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 ">NOT IN</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategoryNOT INdb2,sql server,oracle</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which the <span class="ph uicontrol">Subcategory</span> field is populated by anything except the following values:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_spp_fbh_kgb"><li class="li">DB2</li><li class="li">MS SQL Server</li><li class="li">Oraclel</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">contains</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][contains][Em]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 ">LIKE</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategoryLIKEem</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which the characters "Em" appear anywhere in the value for the <span class="ph uicontrol">Subcategory</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">starts with</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][starts with][Em]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 ">STARTSWITH</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategorySTARTSWITHem</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which the characters "Em" appear at the beginning of the value for the <span class="ph uicontrol">Subcategory</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">ends with</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][ends with][il]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 "><ul class="ul" id="r_OpAvailableFiltersQueries__ul_ekb_wgy_dt"><li class="li">%</li><li class="li">ENDSWITH</li></ul> </td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategoryENDSWITHil</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which the characters "il" appear at the end of the value for the <span class="ph uicontrol">Subcategory</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">does not contain</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][does not contain][Em]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 ">NOT LIKE</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategoryNOT LIKEem</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which the characters "Em" do not appear anywhere in the value for the <span class="ph uicontrol">Subcategory</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">is anything</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][is anything]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 ">ANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategoryANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which the <span class="ph uicontrol">Subcategory</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_z2j_ylv_ngb"><li class="li">any value</li><li class="li">empty</li><li class="li">NULL</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">is same</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][is same] as [Category]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 ">SAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategorySAMEAScategory</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which there exist matching values for the <span class="ph uicontrol">Subcategory</span> and <span class="ph uicontrol">Category</span> fields.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1030 ">is different</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1033 ">[Subcategory][is different] from [Category]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1036 ">NSAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1039 ">subcategoryNSAMEAScategory</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1042 ">All records in which there exist differing values for the <span class="ph uicontrol">Subcategory</span> and <span class="ph uicontrol">Category</span> fields.</td></tr></tbody></table> </div> <div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="r_OpAvailableFiltersQueries__table_b5h_hgy_dt" class="table" frame="border" border="1" rules="all"><caption><span class="tablecap"><span class="table--title-label">Table 5. </span>Operators available for choice fields containing integers</span></caption><colgroup><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /></colgroup><thead class="thead" style="text-align:left;"><tr class="row"><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1359">Operator label</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1362">Example condition</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1365">Equivalent query operator</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1368">Example query</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1371">Example output</th></tr></thead><tbody class="tbody"><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][is][1 - High]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impact=1</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the value in the <span class="ph uicontrol">Impact</span> field is nothing else but <span class="ph uicontrol">1 - High</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">is not</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][is not][1 - High]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">!=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impact!=1</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the value in the <span class="ph uicontrol">Impact</span> field is anything but <span class="ph uicontrol">1 - High</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">is one of</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][is one of][1 - High, 2 - Medium]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">IN</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impactIN1,2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the <span class="ph uicontrol">Impact</span> field is populated by one of the following values:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_s4b_gdh_kgb"><li class="li"><span class="ph uicontrol">1 - High</span></li><li class="li"><span class="ph uicontrol">2 - Medium</span></li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">is not one of</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][is not one of][1 - High, 2 - Medium]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">NOT IN</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impactNOT IN1,2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the <span class="ph uicontrol">Impact</span> field is populated by anything except the following values:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_t53_jdh_kgb"><li class="li"><span class="ph uicontrol">1 - High</span></li><li class="li"><span class="ph uicontrol">2 - Medium</span></li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">is empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][is empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">EMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impactISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the <span class="ph uicontrol">Impact</span> field has no value.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">is not empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][is not empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">NOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impactISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the <span class="ph uicontrol">Impact</span> field has any value.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">less than</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][less than][2 - Medium]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 "><</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impact<2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the <span class="ph uicontrol">Impact</span> field has a value of <span class="ph uicontrol">1 - High</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">greater than</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][greater than][2 - Medium]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">></td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impact>2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the <span class="ph uicontrol">Impact</span> field has a value of <span class="ph uicontrol">3 - Low</span></td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">less than or is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][less than or is][2 - Medium]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 "><=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impact<=2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the <span class="ph uicontrol">Impact</span> field has a value of <span class="ph uicontrol">1 - High</span> or <span class="ph uicontrol">2 - Medium</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">greater than or is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][greater than or is][2 - Medium]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">>=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impact>=2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the <span class="ph uicontrol">Impact</span> field has a value of <span class="ph uicontrol">2 - Medium</span> or <span class="ph uicontrol">3 - Low</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">between</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][between][1 - High] and [3 - Low]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">BETWEEN</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impactBETWEEN1@2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the <span class="ph uicontrol">Impact</span> field has one of the following values:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_bqh_kjv_ngb"><li class="li"><span class="ph uicontrol">1 - High</span></li><li class="li"><span class="ph uicontrol">2 - Medium</span></li><li class="li"><span class="ph uicontrol">3 - Low</span></li></ul> .</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">is anything</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][is anything]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">ANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impactANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which the <span class="ph uicontrol">Impact</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_oz4_bmv_ngb"><li class="li">any value</li><li class="li">empty</li><li class="li">NULL</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">is same</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][is same] as [Urgency]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">SAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impactSAMEASurgency</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which there exist matching values for the <span class="ph uicontrol">Impact</span> and <span class="ph uicontrol">Urgency</span> fields.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1359 ">is different</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1362 ">[Impact][is different] from [Urgency]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1365 ">NSAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1368 ">impactNSAMEASurgency</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1371 ">All records in which there exist differing values for the <span class="ph uicontrol">Impact</span> and <span class="ph uicontrol">Urgency</span> fields.</td></tr></tbody></table> </div> <div class="section"> <div class="note"><span class="notetitle">Note:</span> 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.</div> </div> <div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="r_OpAvailableFiltersQueries__table_url_chy_dt" class="table" frame="border" border="1" rules="all"><caption><span class="tablecap"><span class="table--title-label">Table 6. </span>Operators available for date-time fields</span></caption><colgroup><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /></colgroup><thead class="thead" style="text-align:left;"><tr class="row"><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1780">Operator label</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1783">Example condition</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1786">Equivalent query operator</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1789">Example query</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e1792">Example output</th></tr></thead><tbody class="tbody"><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">on</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][on][Today]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">ONToday</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the value for the <span class="ph uicontrol">SLA due</span> field matches the date for today.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">not on</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][not on][Today]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">NOTONToday</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueNOTONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the value for the <span class="ph uicontrol">SLA due</span> field is any other date but today.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">before</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][before][Today]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 "><</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_due<javascript:gs.daysAgoStart(0)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the value for the <span class="ph uicontrol">SLA due</span> field is any date previous to today.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">at or before</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][at or before][Today]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 "><=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_due<=javascript:gs.daysAgoEnd(0)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the value for the <span class="ph uicontrol">SLA due</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_bjx_kqp_lgb"><li class="li">any date previous to today</li><li class="li">today</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">after</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][after][Today]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">></td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_due>javascript:gs.daysAgoEnd(0)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the value for the <span class="ph uicontrol">SLA due</span> field is any date after today.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">at or after</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][at or after][Today]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">>=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_due>=javascript:gs.daysAgoStart(0)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the date value for the <span class="ph uicontrol">SLA due</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_td1_rqp_lgb"><li class="li">today</li><li class="li">any date after today</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">between</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][between][Yesterday] and [Today]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">BETWEEN</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueBETWEENjavascript:gs.daysAgoStart(1)@javascript:gs.daysAgoEnd(0)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the value for the <span class="ph uicontrol">SLA due</span> field is either yesterday's or today's date.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">trend (on or after)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][trend][on or after][Monday]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">DATEPART</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GE')</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the date in the <span class="ph uicontrol">SLA due</span> field is on any day of the week except a Sunday.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">trend (on or before)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][trend][on or before][Monday]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">DATEPART</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','LE')</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the date in the <span class="ph uicontrol">SLA due</span> field is on either a Sunday or a Monday.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">trend (after)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][trend][after][Monday]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">DATEPART</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GT')</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the date in the <span class="ph uicontrol">SLA due</span> field is on any day of the week except a Sunday or a Monday.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">trend (before)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][trend][before][Monday]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">DATEPART</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','LT')</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the date in the <span class="ph uicontrol">SLA due</span> field is on a Sunday.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">trend (on)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][trend][on][Monday]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">DATEPART</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','EE')</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the date in the <span class="ph uicontrol">SLA due</span> field is on a Monday.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">relative (after)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][relative][after][1][Hours][ago]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">RELATIVEGT</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueRELATIVEGT@hour@ago@1</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the time on the <span class="ph uicontrol">SLA due</span> field is no more than an hour before the time that you entered the query.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">relative (before)</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][relative][before][1][Hours][ago]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">RELATIVELT</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueRELATIVELT@hour@ago@1</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the time on the <span class="ph uicontrol">SLA due</span> field is less than an hour before the time that you entered the query.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">is empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][is empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">ISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the <span class="ph uicontrol">SLA due</span> field has no value.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">is not empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][is not empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">ISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the <span class="ph uicontrol">SLA due</span> is populated by any value.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">is anything</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][is anything]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">ANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the <span class="ph uicontrol">SLA due</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_w4d_dmv_ngb"><li class="li">any value</li><li class="li">empty</li><li class="li">NULL</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">is same</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][is same] as [Activity due]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">SAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueSAMEASactivity_due@day</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which there are matching values for the <span class="ph uicontrol">SLA due</span> and <span class="ph uicontrol">Activity due</span> fields.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">is different</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][is different] from [Activity due]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">NSAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueNSAMEASactivity_due@day</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which there are differing values for the <span class="ph uicontrol">SLA due</span> and <span class="ph uicontrol">Activity due</span> fields.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">is more than</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][is more than][1][Days][before][Activity due]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">MORETHAN</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueMORETHANactivity_due@day@before@1</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the date value for the <span class="ph uicontrol">SLA due</span> field is two or more days previous to the date in the <span class="ph uicontrol">Activity due</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1780 ">is less than</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1783 ">[SLA due][is less than][3][Days][before][Activity due]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1786 ">LESSTHAN</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1789 ">sla_dueLESSTHANactivity_due@day@before@3</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e1792 ">All records in which the date value for the <span class="ph uicontrol">SLA due</span> field is no more than three days prior to the date in the <span class="ph uicontrol">Activity due</span> field.</td></tr></tbody></table> </div> <div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="r_OpAvailableFiltersQueries__table_yz1_shy_dt" class="table" frame="border" border="1" rules="all"><caption><span class="tablecap"><span class="table--title-label">Table 7. </span>Operators available for numeric fields</span></caption><colgroup><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /></colgroup><thead class="thead" style="text-align:left;"><tr class="row"><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2307">Operator label</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2310">Example condition</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2313">Equivalent query operator</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2316">Example query</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2319">Example output</th></tr></thead><tbody class="tbody"><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][is][0]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_count=0</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the <span class="ph uicontrol">Reassignment count</span> is nothing else but <span class="ph uicontrol">0</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">is not</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][is not][0]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">!=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_count!=0</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the value for the <span class="ph uicontrol">Reassignment count</span> is any number but <span class="ph uicontrol">0</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">is empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][is empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">EMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_countISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which there is no value in the <span class="ph uicontrol">Reassignment count</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">is not empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][is not empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">NOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_countISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which there is any number in the <span class="ph uicontrol">Reassignment count</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">less than</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][less than][2]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 "><</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_count<2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the value in the <span class="ph uicontrol">Reassignment count</span> field is any number less than (but not equal to) <span class="ph uicontrol">2</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">greater than</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][greater than][2]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">></td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_count>2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the value in the <span class="ph uicontrol">Reassignment count</span> field is any number greater than (but not equal to) <span class="ph uicontrol">2</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">less than or is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][less than or is][2]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 "><=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_count<=2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the value in the <span class="ph uicontrol">Reassignment count</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_jcp_ttp_lgb"><li class="li">a number less than 2</li><li class="li">2</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">greater than or is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][greater than or is][2]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">>=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_count>=2</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the value in the <span class="ph uicontrol">Reassignment count</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_m3w_vtp_lgb"><li class="li">2</li><li class="li">a number greater than 2</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">between</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][between][1] and [3]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">BETWEEN</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_countBETWEEN1@3</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the number in the <span class="ph uicontrol">Reassignment count</span> is either 1, 2, or 3.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">is anything</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][is anything]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">ANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_countANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the <span class="ph uicontrol">Reassignment count</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_uyb_2mv_ngb"><li class="li">any value</li><li class="li">empty</li><li class="li">NULL</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">is same</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][is same] as [Reopen count]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">SAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_countSAMEASreopen_count</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which there are matching numbers for the <span class="ph uicontrol">Reassignment count</span> and <span class="ph uicontrol">Reopen count</span> fields.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">is different</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][is different] from [Reopen count]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">NSAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_countNSAMEASreopen_count</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which there are differing values between the <span class="ph uicontrol">Reassignment count</span> and <span class="ph uicontrol">Reopen count</span> fields.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">greater than field</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][greater than field][Reopen count]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">GT_FIELD</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_countGT_FIELDreopen_count</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the number in the <span class="ph uicontrol">Reassignment count</span> field is greater than (but not equal to) the number in the <span class="ph uicontrol">Reopen count</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">less than field</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][less than field][Reopen count]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">LT_FIELD</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_countLT_FIELDreopen_count</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the number in the <span class="ph uicontrol">Reassignment count</span> field is less than (but not equal to) the number in the <span class="ph uicontrol">Reopen count</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">greater than or is field</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][greater than or is field][Reopen count]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">GT_OR_EQUALS_FIELD</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_countGT_OR_EQUALS_FIELDreopen_count</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the number in the <span class="ph uicontrol">Reassignment count</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_wnl_ykv_ngb"><li class="li">greater than the number in the <span class="ph uicontrol">Reopen count</span> field</li><li class="li">equal to the number in the <span class="ph uicontrol">Reopen count</span> field</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2307 ">less than or is field</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2310 ">[Reassignment count][less than or is field][Reopen count]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2313 ">LT_OR_EQUALS_FIELD</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2316 ">reassignment_countLT_OR_EQUALS_FIELDreopen_count</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2319 ">All records in which the number in the <span class="ph uicontrol">Reassignment count</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_yhz_blv_ngb"><li class="li">less than the number in the <span class="ph uicontrol">Reopen count</span> field</li><li class="li">equal to the number in the <span class="ph uicontrol">Reopen count</span> field</li></ul> </td></tr></tbody></table> </div> <div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="r_OpAvailableFiltersQueries__table_vfm_d3y_dt" class="table" frame="border" border="1" rules="all"><caption><span class="tablecap"><span class="table--title-label">Table 8. </span>Operators available for Boolean fields</span></caption><colgroup><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /></colgroup><thead class="thead" style="text-align:left;"><tr class="row"><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2768">Operator label</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2771">Example condition</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2774">Equivalent query operator</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2777">Example query</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2780">Example output</th></tr></thead><tbody class="tbody"><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2768 ">is</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2771 ">[Active][is][true]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2774 ">=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2777 ">active=true</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2780 ">All records in which the <span class="ph uicontrol">Active</span> field is <span class="ph uicontrol">True</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2768 ">is not</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2771 ">[Active][is not][true]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2774 ">!=</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2777 ">active!=true</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2780 ">All records in which the <span class="ph uicontrol">Active</span> field is <span class="ph uicontrol">False</span>, empty, or NULL.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2768 ">is empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2771 ">[Active][is empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2774 ">ISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2777 ">activeISEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2780 ">All records in which there is no value in the <span class="ph uicontrol">Active</span> field.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2768 ">is not empty</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2771 ">[Active][is not empty]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2774 ">ISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2777 ">activeISNOTEMPTY</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2780 ">All records in which the <span class="ph uicontrol">Active</span> field is either <span class="ph uicontrol">True</span> or <span class="ph uicontrol">False</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2768 ">is anything</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2771 ">[Active][is anything]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2774 ">ANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2777 ">activeANYTHING</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2780 ">All records in which the <span class="ph uicontrol">Active</span> field is one of the following:<ul class="ul" id="r_OpAvailableFiltersQueries__ul_s3h_fmv_ngb"><li class="li">True</li><li class="li">False</li><li class="li">empty</li><li class="li">NULL</li></ul> </td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2768 ">is same</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2771 ">[Active][is same] as [Made SLA]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2774 ">SAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2777 ">activeSAMEASmade_sla</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2780 ">All records in which there are matching values for the <span class="ph uicontrol">Active</span> and <span class="ph uicontrol">Made SLA</span> fields.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2768 ">is different</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2771 ">[Active][is different] from [Made SLA]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2774 ">NSAMEAS</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2777 ">activeNSAMEASmade_sla</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2780 ">All records in which there are differing values for the <span class="ph uicontrol">Active</span> and <span class="ph uicontrol">Made SLA</span> fields.</td></tr></tbody></table> </div> <div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="r_OpAvailableFiltersQueries__table_wqc_x3y_dt" class="table" frame="border" border="1" rules="all"><caption><span class="tablecap"><span class="table--title-label">Table 9. </span>Operators available for email notifications</span></caption><colgroup><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /><col style="width:20%" /></colgroup><thead class="thead" style="text-align:left;"><tr class="row"><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2992">Operator label</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2995">Example condition</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e2998">Equivalent query operator</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e3001">Example query</th><th class="entry cellrowborder" style="vertical-align:top;" id="d305862e3004">Example output</th></tr></thead><tbody class="tbody"><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2992 ">changes</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2995 ">[State][changes]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2998 ">VALCHANGES</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e3001 ">stateVALCHANGES</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e3004 ">All records in which the <span class="ph uicontrol">State</span> field is updated.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2992 ">changes from</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2995 ">[State][changes from][Awaiting User Info]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2998 ">CHANGESFROM</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e3001 ">stateCHANGESFROM4^EQ</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e3004 ">All records in which the <span class="ph uicontrol">State</span> field is updated to another value after previously being <span class="ph uicontrol">Awaiting User Info</span>.</td></tr><tr class="row"><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2992 ">changes to</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2995 ">[State][changes to][Awaiting User Info]</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e2998 ">CHANGESTO</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e3001 ">stateCHANGESTO4^EQ</td><td class="entry cellrowborder" style="vertical-align:top;" headers="d305862e3004 ">All records in which the <span class="ph uicontrol">State</span> field is updated to <span class="ph uicontrol">Awaiting User Info</span> after previously being any other value.</td></tr></tbody></table> </div> </div> <div class="related-links"> <div class="familylinks"> <div class="parentlink"><strong>Parent Topic:</strong> <a class="link" href="../../../use/common-ui-elements/task/create-cond-state-using-cond-build.html" title="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.">Create a condition statement using the condition builder</a></div> </div> <div class="linklist relinfo relconcepts"><strong>Related concepts</strong><br /> <ul class="linklist"><li class="linklist"><a class="link" href="../../../use/common-ui-elements/concept/c_ConditionBuilder.html" title="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.">Condition builder</a></li></ul></div> </div></body></html></div>