{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":42384,"path":"platform-user-interface/r_OpAvailableFiltersQueries.md","title":"Operators available for filters and queries","bundle":null,"doc_type":null,"release":"australia","body":"\n# Operators available for filters and queries\n\nThe 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.\n\n## Operators available for condition builders\n\n<table id=\"table_jb1_r21_ft\"><thead><tr><th>\n\nOperator label\n\n</th><th>\n\nExample condition\n\n</th><th>\n\nEquivalent query operator\n\n</th><th>\n\nExample query\n\n</th><th>\n\nExample output\n\n</th></tr></thead><tbody><tr><td>\n\nAND\n\n</td><td>\n\n\\[Active\\]\\[is\\]\\[True\\]\\[AND\\]\\[Caller\\]\\[is not empty\\]\n\n</td><td>\n\n^\n\n</td><td>\n\nactive=true^CallerISNOTEMPTY\n\n</td><td>\n\nAll records that have both of the following:-   **Active** field is **True**\n-   **Caller** field has any value\n\n</td></tr><tr><td>\n\nOR condition\n\n</td><td>\n\n\\[Short description\\]\\[is empty\\]\\[OR\\]\\[Description\\]\\[is empty\\]\n\n</td><td>\n\n^OR\n\n</td><td>\n\nshort\\_descriptionISEMPTY^ORdescriptionISEMPTY\n\n</td><td>\n\nAll records that have at least one of the following:-   **Short description** field has no value\n-   **Description** field has no value\n\n</td></tr><tr><td>\n\nOR filter\n\n</td><td>\n\nAll these conditions must be met\n\n \\[Short description\\]\\[is empty\\]\n\n OR all these conditions must be met\n\n \\[Description\\]\\[is not empty\\]\n\n</td><td>\n\n^NQ\n\n new query\n\n</td><td>\n\nshort\\_descriptionISEMPTY^NQdescriptionISNOTEMPTY\n\n</td><td>\n\nAll records that have at least one of the following:-   **Short description** field has no value\n-   **Description** field has no value\n\n</td></tr></tbody>\n</table>## Operators available for string fields\n\n<table id=\"table_egn_qcy_dt\"><thead><tr><th>\n\nOperator label\n\n</th><th>\n\nExample condition\n\n</th><th>\n\nEquivalent query operator\n\n</th><th>\n\nExample query\n\n</th><th>\n\nExample output\n\n</th></tr></thead><tbody><tr><td>\n\nstarts with\n\n</td><td>\n\n\\[Short description\\]\\[starts with\\]\\[SAP\\]\n\n</td><td>\n\nSTARTSWITH\n\n</td><td>\n\nshort\\_descriptionSTARTSWITHSAP\n\n</td><td>\n\nAll records in which the characters \"SAP\" appear at the beginning of the value for the **Short description** field.\n\n</td></tr><tr><td>\n\nends with\n\n</td><td>\n\n\\[Short description\\]\\[ends with\\]\\[outage\\]\n\n</td><td>\n\n-   %\n-   ENDSWITH\n\n</td><td>\n\nshort\\_descriptionENDSWITHoutage\n\n</td><td>\n\nAll records in which the string \"outage\" appears at the end of the value for the **Short description** field.\n\n</td></tr><tr><td>\n\ncontains\n\n</td><td>\n\n\\[Short description\\]\\[contains\\]\\[SAP\\]\n\n</td><td>\n\n-   \\*\n-   LIKE\n\n</td><td>\n\nshort\\_descriptionLIKESAP\n\n</td><td>\n\nAll records in which the characters \"SAP\" appear anywhere in the value for the **Short description** field.\n\n</td></tr><tr><td>\n\ndoes not contain\n\n</td><td>\n\n\\[Short description\\]\\[does not contain\\]\\[SAP\\]\n\n</td><td>\n\n-   !\\*\n-   NOT LIKE\n\n</td><td>\n\nshort\\_descriptionNOT LIKESAP\n\n</td><td>\n\nAll records in which the characters \"SAP\" do not appear anywhere in the value for the **Short description** field.\n\n</td></tr><tr><td>\n\nis\n\n</td><td>\n\n\\[Short description\\]\\[is\\]\\[Network storage unavailable\\]\n\n</td><td>\n\n=\n\n</td><td>\n\nshort\\_description=Network storage unavailable\n\n</td><td>\n\nAll records in which the **Short description** says nothing else but \"Network storage is unavailable.\"\n\n</td></tr><tr><td>\n\nis not\n\n</td><td>\n\n\\[Short description\\]\\[is not\\]\\[Network storage unavailable\\]\n\n</td><td>\n\n!=\n\n</td><td>\n\nshort\\_description!=Network storage unavailable\n\n</td><td>\n\nAll records in which the value for the **Short description** field says anything but \"Network storage is unavailable.\"\n\n</td></tr><tr><td>\n\nis empty\n\n</td><td>\n\n\\[Short description\\]\\[is empty\\]\n\n</td><td>\n\nISEMPTY\n\n</td><td>\n\nshort\\_descriptionISEMPTY\n\n</td><td>\n\nAll records in which there is no value in the **Short description** field.\n\n</td></tr><tr><td>\n\nis not empty\n\n</td><td>\n\n\\[Short description\\]\\[is not empty\\]\n\n</td><td>\n\nISNOTEMPTY\n\n</td><td>\n\nshort\\_descriptionISNOTEMPTY\n\n</td><td>\n\nAll records in which there is any value in the **Short description** field.\n\n</td></tr><tr><td>\n\nis anything\n\n</td><td>\n\n\\[Short description\\]\\[is anything\\]\n\n</td><td>\n\nANYTHING\n\n</td><td>\n\nshort\\_descriptionANYTHING\n\n</td><td>\n\nAll records in which the **Short description** field is one of the following:-   any value\n-   empty\n-   NULL\n\n</td></tr><tr><td>\n\nis empty string\n\n</td><td>\n\n\\[Short description\\]\\[is empty string\\]\n\n</td><td>\n\nEMPTYSTRING\n\n</td><td>\n\nshort\\_descriptionEMPTYSTRING\n\n</td><td>\n\nAll records in which there is no value in the **Short description** field.\n\n</td></tr><tr><td>\n\nless than or is\n\n</td><td>\n\n\\[Short description\\]\\[less than or is\\]\\[s\\]\n\n</td><td>\n\n&lt;=\n\n</td><td>\n\nshort\\_descriptionlt;=s\n\n</td><td>\n\nAll 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\"\n-   the exact value is \"s\"\n\n</td></tr><tr><td>\n\ngreater than or is\n\n</td><td>\n\n\\[Short description\\]\\[greater than or is\\]\\[s\\]\n\n</td><td>\n\n&gt;=\n\n</td><td>\n\nshort\\_description&gt;=s\n\n</td><td>\n\nAll 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\"\n-   the exact value is \"s\"\n\n</td></tr><tr><td>\n\nbetween\n\n</td><td>\n\n\\[Short description\\]\\[between\\]\\[q\\] and \\[t\\]\n\n</td><td>\n\nBETWEEN\n\n</td><td>\n\nshort\\_descriptionBETWEENq@t\n\n</td><td>\n\nAll records in which the first letter in the **Short description** field is \"q,\" \"r,\" \"s,\" or \"t.\"\n\n</td></tr><tr><td>\n\nis same\n\n</td><td>\n\n\\[Short description\\]\\[is same\\] as \\[Description\\]\n\n</td><td>\n\nSAMEAS\n\n</td><td>\n\nshort\\_descriptionSAMEASdescription\n\n</td><td>\n\nAll records in which there exist matching values for the **Short description** and **Description** fields.\n\n</td></tr><tr><td>\n\nis different\n\n</td><td>\n\n\\[Short description\\]\\[is different\\] from \\[Description\\]\n\n</td><td>\n\nNSAMEAS\n\n</td><td>\n\nshort\\_descriptionNSAMEASdescription\n\n</td><td>\n\nAll records in which there exist differing values for the **Short description** and **Description** fields.\n\n</td></tr></tbody>\n</table>## Operators available for reference fields\n\n<table id=\"table_cz1_q2y_dt\"><thead><tr><th>\n\nOperator label\n\n</th><th>\n\nExample condition\n\n</th><th>\n\nEquivalent query operator\n\n</th><th>\n\nExample query\n\n</th><th>\n\nExample output\n\n</th></tr></thead><tbody><tr><td>\n\nis\n\n</td><td>\n\n\\[Caller\\]\\[is\\]\\[Don Goodliffe\\]\n\n</td><td>\n\n=\n\n</td><td>\n\ncaller\\_id=9ee1b13dc6112271007f9d0efdb69cd0\n\n</td><td>\n\nAll records in which the **Caller** is no one else but Don Goodliffe.\n\n</td></tr><tr><td>\n\nis not\n\n</td><td>\n\n\\[Caller\\]\\[is not\\]\\[Don Goodliffe\\]\n\n</td><td>\n\n!=\n\n</td><td>\n\ncaller\\_id!=9ee1b13dc6112271007f9d0efdb69cd0\n\n</td><td>\n\nAll records in which the **Caller** field is populated by any user record but Don Goodliffe.\n\n</td></tr><tr><td>\n\nis empty\n\n</td><td>\n\n\\[Caller\\]\\[is empty\\]\n\n</td><td>\n\nISEMPTY\n\n</td><td>\n\ncaller\\_idISEMPTY\n\n</td><td>\n\nAll records in which the **Caller** field has no value.\n\n</td></tr><tr><td>\n\nis not empty\n\n</td><td>\n\n\\[Caller\\]\\[is not empty\\]\n\n</td><td>\n\nISNOTEMPTY\n\n</td><td>\n\ncaller\\_idISNOTEMPTY\n\n</td><td>\n\nAll records in which there is any value in the **Caller** field.\n\n</td></tr><tr><td>\n\nstarts with\n\n</td><td>\n\n\\[Caller\\]\\[starts with\\]\\[Don\\]\n\n</td><td>\n\nSTARTSWITH\n\n</td><td>\n\ncaller\\_idSTARTSWITHDon\n\n</td><td>\n\nAll records in which the name in the **Caller** field begins with \"Don.\"\n\n</td></tr><tr><td>\n\nends with\n\n</td><td>\n\n\\[Caller\\]\\[ends with\\]\\[liffe\\]\n\n</td><td>\n\n-   %\n-   ENDSWITH\n\n</td><td>\n\ncaller\\_idENDSWITHliffe\n\n</td><td>\n\nAll records in which the name in the **Caller** field has the letters \"liffe\" at the end.\n\n</td></tr><tr><td>\n\ncontains\n\n</td><td>\n\n\\[Caller\\]\\[contains\\]\\[on\\]\n\n</td><td>\n\n-   \\*\n-   LIKE\n\n</td><td>\n\ncaller\\_idLIKEon\n\n</td><td>\n\nAll records in which the characters \"on\" appear anywhere in the name for the **Caller** field.\n\n</td></tr><tr><td>\n\ndoes not contain\n\n</td><td>\n\n\\[Caller\\]\\[does not contain\\]\\[on\\]\n\n</td><td>\n\n-   !\\*\n-   NOT LIKE\n\n</td><td>\n\ncaller\\_idNOT LIKEon\n\n</td><td>\n\nAll records in which the characters \"on\" do not appear anywhere in the name for the **Caller** field.\n\n</td></tr><tr><td>\n\nis anything\n\n</td><td>\n\n\\[Caller\\]\\[is anything\\]\n\n</td><td>\n\nANYTHING\n\n</td><td>\n\ncaller\\_idANYTHING\n\n</td><td>\n\nAll records in which the **Caller** field is one of the following:-   any value\n-   empty\n-   NULL\n\n</td></tr><tr><td>\n\nis same\n\n</td><td>\n\n\\[Caller\\]\\[is same\\] as \\[Assigned to\\]\n\n</td><td>\n\nSAMEAS\n\n</td><td>\n\ncaller\\_idSAMEASassigned\\_to\n\n</td><td>\n\nAll records in which the same user record is referenced in the **Caller** and **Assigned to** fields.\n\n</td></tr><tr><td>\n\nis different\n\n</td><td>\n\n\\[Caller\\]\\[is different\\] from \\[Assigned to\\]\n\n</td><td>\n\nNSAMEAS\n\n</td><td>\n\ncaller\\_idNSAMEASassigned\\_to\n\n</td><td>\n\nAll records in which the user records in the **Caller** and **Assigned to** fields do no match.\n\n</td></tr><tr><td>\n\nis empty string\n\n</td><td>\n\n\\[Caller\\]\\[is empty string\\]\n\n</td><td>\n\nEMPTYSTRING\n\n</td><td>\n\ncaller\\_idEMPTYSTRING\n\n</td><td>\n\nAll records in which the **Caller** field has no value.\n\n</td></tr><tr><td>\n\nis \\(dynamic\\)\n\n</td><td>\n\n\\[Caller\\]\\[is \\(dynamic\\)\\]\\[Me\\]\n\n</td><td>\n\nDYNAMIC\n\n</td><td>\n\ncaller\\_idDYNAMIC54635e965f510100a9ad2572f2b4774c\n\n</td><td>\n\nAll records in which your user record populates the **Caller** field.\n\n</td></tr><tr><td>\n\nis in hierarchy\n\n</td><td>\n\n\\[Manager\\]\\[is in hierarchy\\]\\[Manager Hierarchy\\] starting at \\[Don Goodliffe\\] which is \\[Included\\]\n\n</td><td>\n\nIN\\_HIERARCHY\n\n</td><td>\n\nmanagerIN\\_HIERARCHYfdd0fa0f93f5d2505bd0bd886cba1015%409ee1b13dc6112271007f9d0efdb69cd0\n\n</td><td>\n\nAll records throughout the Manager hierarchy in which the manager is Don Goodliffe or a user reporting up to Don Goodliffe.\n\n</td></tr><tr><td>\n\nis in hierarchy \\(dynamic\\)\n\n</td><td>\n\n\\[Manager\\]\\[is in hierarchy \\(dynamic\\)\\]\\[Manager Hierarchy\\] starting at \\[Me\\] which is \\[Included\\]\n\n</td><td>\n\nIN\\_HIERARCHY\\_DYNAMIC\n\n</td><td>\n\nmanagerIN\\_HIERARCHY\\_DYNAMICfdd0fa0f93f5d2505bd0bd886cba1015%4090d1921e5f510100a9ad2572f2b477fe\n\n</td><td>\n\nAll 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 .\n\n</td></tr></tbody>\n</table>**Note:** Not all operators are available for all reference types. Depending on the reference you select, you may see a shorter list of operators.\n\n## Operators available for choice fields containing strings\n\n<table id=\"table_mjd_4fy_dt\"><thead><tr><th>\n\nOperator label\n\n</th><th>\n\nExample condition\n\n</th><th>\n\nEquivalent query operator\n\n</th><th>\n\nExample query\n\n</th><th>\n\nExample output\n\n</th></tr></thead><tbody><tr><td>\n\nis\n\n</td><td>\n\n\\[Subcategory\\]\\[is\\]\\[Email\\]\n\n</td><td>\n\n=\n\n</td><td>\n\nsubcategory=email\n\n</td><td>\n\nAll records in which the **Subcategory** is nothing else but **Email**.\n\n</td></tr><tr><td>\n\nis not\n\n</td><td>\n\n\\[Subcategory\\]\\[is not\\]\\[Email\\]\n\n</td><td>\n\n!=\n\n</td><td>\n\nsubcategory!=email\n\n</td><td>\n\nAll records in which the **Subcategory** field is populated by any value except **Email**.\n\n</td></tr><tr><td>\n\nis one of\n\n</td><td>\n\n\\[Subcategory\\]\\[is one of\\]\\[DB2, MS SQL Server, Oraclel\\]\n\n</td><td>\n\nIN\n\n</td><td>\n\nsubcategoryINdb2,sql server,oracle\n\n</td><td>\n\nAll records in which the **Subcategory** field is populated by one of the following values:-   DB2\n-   MS SQL Server\n-   Oraclel\n\n</td></tr><tr><td>\n\nis not one of\n\n</td><td>\n\n\\[Subcategory\\]\\[is not one of\\]\\[DB2, MS SQL Server, Oraclel\\]\n\n</td><td>\n\nNOT IN\n\n</td><td>\n\nsubcategoryNOT INdb2,sql server,oracle\n\n</td><td>\n\nAll records in which the **Subcategory** field is populated by anything except the following values:-   DB2\n-   MS SQL Server\n-   Oraclel\n\n</td></tr><tr><td>\n\ncontains\n\n</td><td>\n\n\\[Subcategory\\]\\[contains\\]\\[Em\\]\n\n</td><td>\n\nLIKE\n\n</td><td>\n\nsubcategoryLIKEem\n\n</td><td>\n\nAll records in which the characters \"Em\" appear anywhere in the value for the **Subcategory** field.\n\n</td></tr><tr><td>\n\nstarts with\n\n</td><td>\n\n\\[Subcategory\\]\\[starts with\\]\\[Em\\]\n\n</td><td>\n\nSTARTSWITH\n\n</td><td>\n\nsubcategorySTARTSWITHem\n\n</td><td>\n\nAll records in which the characters \"Em\" appear at the beginning of the value for the **Subcategory** field.\n\n</td></tr><tr><td>\n\nends with\n\n</td><td>\n\n\\[Subcategory\\]\\[ends with\\]\\[il\\]\n\n</td><td>\n\n-   %\n-   ENDSWITH\n\n</td><td>\n\nsubcategoryENDSWITHil\n\n</td><td>\n\nAll records in which the characters \"il\" appear at the end of the value for the **Subcategory** field.\n\n</td></tr><tr><td>\n\ndoes not contain\n\n</td><td>\n\n\\[Subcategory\\]\\[does not contain\\]\\[Em\\]\n\n</td><td>\n\nNOT LIKE\n\n</td><td>\n\nsubcategoryNOT LIKEem\n\n</td><td>\n\nAll records in which the characters \"Em\" do not appear anywhere in the value for the **Subcategory** field.\n\n</td></tr><tr><td>\n\nis anything\n\n</td><td>\n\n\\[Subcategory\\]\\[is anything\\]\n\n</td><td>\n\nANYTHING\n\n</td><td>\n\nsubcategoryANYTHING\n\n</td><td>\n\nAll records in which the **Subcategory** field is one of the following:-   any value\n-   empty\n-   NULL\n\n</td></tr><tr><td>\n\nis same\n\n</td><td>\n\n\\[Subcategory\\]\\[is same\\] as \\[Category\\]\n\n</td><td>\n\nSAMEAS\n\n</td><td>\n\nsubcategorySAMEAScategory\n\n</td><td>\n\nAll records in which there exist matching values for the **Subcategory** and **Category** fields.\n\n</td></tr><tr><td>\n\nis different\n\n</td><td>\n\n\\[Subcategory\\]\\[is different\\] from \\[Category\\]\n\n</td><td>\n\nNSAMEAS\n\n</td><td>\n\nsubcategoryNSAMEAScategory\n\n</td><td>\n\nAll records in which there exist differing values for the **Subcategory** and **Category** fields.\n\n</td></tr></tbody>\n</table>## Operators available for choice fields containing integers\n\n<table id=\"table_b5h_hgy_dt\"><thead><tr><th>\n\nOperator label\n\n</th><th>\n\nExample condition\n\n</th><th>\n\nEquivalent query operator\n\n</th><th>\n\nExample query\n\n</th><th>\n\nExample output\n\n</th></tr></thead><tbody><tr><td>\n\nis\n\n</td><td>\n\n\\[Impact\\]\\[is\\]\\[1 - High\\]\n\n</td><td>\n\n=\n\n</td><td>\n\nimpact=1\n\n</td><td>\n\nAll records in which the value in the **Impact** field is nothing else but **1 - High**.\n\n</td></tr><tr><td>\n\nis not\n\n</td><td>\n\n\\[Impact\\]\\[is not\\]\\[1 - High\\]\n\n</td><td>\n\n!=\n\n</td><td>\n\nimpact!=1\n\n</td><td>\n\nAll records in which the value in the **Impact** field is anything but **1 - High**.\n\n</td></tr><tr><td>\n\nis one of\n\n</td><td>\n\n\\[Impact\\]\\[is one of\\]\\[1 - High, 2 - Medium\\]\n\n</td><td>\n\nIN\n\n</td><td>\n\nimpactIN1,2\n\n</td><td>\n\nAll records in which the **Impact** field is populated by one of the following values:-   **1 - High**\n-   **2 - Medium**\n\n</td></tr><tr><td>\n\nis not one of\n\n</td><td>\n\n\\[Impact\\]\\[is not one of\\]\\[1 - High, 2 - Medium\\]\n\n</td><td>\n\nNOT IN\n\n</td><td>\n\nimpactNOT IN1,2\n\n</td><td>\n\nAll records in which the **Impact** field is populated by anything except the following values:-   **1 - High**\n-   **2 - Medium**\n\n</td></tr><tr><td>\n\nis empty\n\n</td><td>\n\n\\[Impact\\]\\[is empty\\]\n\n</td><td>\n\nEMPTY\n\n</td><td>\n\nimpactISEMPTY\n\n</td><td>\n\nAll records in which the **Impact** field has no value.\n\n</td></tr><tr><td>\n\nis not empty\n\n</td><td>\n\n\\[Impact\\]\\[is not empty\\]\n\n</td><td>\n\nNOTEMPTY\n\n</td><td>\n\nimpactISNOTEMPTY\n\n</td><td>\n\nAll records in which the **Impact** field has any value.\n\n</td></tr><tr><td>\n\nless than\n\n</td><td>\n\n\\[Impact\\]\\[less than\\]\\[2 - Medium\\]\n\n</td><td>\n\n&lt;\n\n</td><td>\n\nimpact&lt;2\n\n</td><td>\n\nAll records in which the **Impact** field has a value of **1 - High**.\n\n</td></tr><tr><td>\n\ngreater than\n\n</td><td>\n\n\\[Impact\\]\\[greater than\\]\\[2 - Medium\\]\n\n</td><td>\n\n&gt;\n\n</td><td>\n\nimpact&gt;2\n\n</td><td>\n\nAll records in which the **Impact** field has a value of **3 - Low**\n\n</td></tr><tr><td>\n\nless than or is\n\n</td><td>\n\n\\[Impact\\]\\[less than or is\\]\\[2 - Medium\\]\n\n</td><td>\n\n&lt;=\n\n</td><td>\n\nimpact&lt;=2\n\n</td><td>\n\nAll records in which the **Impact** field has a value of **1 - High** or **2 - Medium**.\n\n</td></tr><tr><td>\n\ngreater than or is\n\n</td><td>\n\n\\[Impact\\]\\[greater than or is\\]\\[2 - Medium\\]\n\n</td><td>\n\n&gt;=\n\n</td><td>\n\nimpact&gt;=2\n\n</td><td>\n\nAll records in which the **Impact** field has a value of **2 - Medium** or **3 - Low**.\n\n</td></tr><tr><td>\n\nbetween\n\n</td><td>\n\n\\[Impact\\]\\[between\\]\\[1 - High\\] and \\[3 - Low\\]\n\n</td><td>\n\nBETWEEN\n\n</td><td>\n\nimpactBETWEEN1@2\n\n</td><td>\n\nAll records in which the **Impact** field has one of the following values:-   **1 - High**\n-   **2 - Medium**\n-   **3 - Low**\n\n.\n\n</td></tr><tr><td>\n\nis anything\n\n</td><td>\n\n\\[Impact\\]\\[is anything\\]\n\n</td><td>\n\nANYTHING\n\n</td><td>\n\nimpactANYTHING\n\n</td><td>\n\nAll records in which the **Impact** field is one of the following:-   any value\n-   empty\n-   NULL\n\n</td></tr><tr><td>\n\nis same\n\n</td><td>\n\n\\[Impact\\]\\[is same\\] as \\[Urgency\\]\n\n</td><td>\n\nSAMEAS\n\n</td><td>\n\nimpactSAMEASurgency\n\n</td><td>\n\nAll records in which there exist matching values for the **Impact** and **Urgency** fields.\n\n</td></tr><tr><td>\n\nis different\n\n</td><td>\n\n\\[Impact\\]\\[is different\\] from \\[Urgency\\]\n\n</td><td>\n\nNSAMEAS\n\n</td><td>\n\nimpactNSAMEASurgency\n\n</td><td>\n\nAll records in which there exist differing values for the **Impact** and **Urgency** fields.\n\n</td></tr></tbody>\n</table>**Note:** The operators ‘less than or is’ and ‘greater than or is’ are not supported for integer fields in the condition builder. Use a scripted condition instead.\n\n## Operators available for date-time fields\n\n<table id=\"table_url_chy_dt\"><thead><tr><th>\n\nOperator label\n\n</th><th>\n\nExample condition\n\n</th><th>\n\nEquivalent query operator\n\n</th><th>\n\nExample query\n\n</th><th>\n\nExample output\n\n</th></tr></thead><tbody><tr><td>\n\non\n\n</td><td>\n\n\\[SLA due\\]\\[on\\]\\[Today\\]\n\n</td><td>\n\nONToday\n\n</td><td>\n\nsla\\_dueONToday@javascript:gs.daysAgoStart\\(0\\)@javascript:gs.daysAgoEnd\\(0\\)\n\n</td><td>\n\nAll records in which the value for the **SLA due** field matches the date for today.\n\n</td></tr><tr><td>\n\nnot on\n\n</td><td>\n\n\\[SLA due\\]\\[not on\\]\\[Today\\]\n\n</td><td>\n\nNOTONToday\n\n</td><td>\n\nsla\\_dueNOTONToday@javascript:gs.daysAgoStart\\(0\\)@javascript:gs.daysAgoEnd\\(0\\)\n\n</td><td>\n\nAll records in which the value for the **SLA due** field is any other date but today.\n\n</td></tr><tr><td>\n\nbefore\n\n</td><td>\n\n\\[SLA due\\]\\[before\\]\\[Today\\]\n\n</td><td>\n\n&lt;\n\n</td><td>\n\nsla\\_due&lt;javascript:gs.daysAgoStart\\(0\\)\n\n</td><td>\n\nAll records in which the value for the **SLA due** field is any date previous to today.\n\n</td></tr><tr><td>\n\nat or before\n\n</td><td>\n\n\\[SLA due\\]\\[at or before\\]\\[Today\\]\n\n</td><td>\n\n&lt;=\n\n</td><td>\n\nsla\\_due&lt;=javascript:gs.daysAgoEnd\\(0\\)\n\n</td><td>\n\nAll records in which the value for the **SLA due** field is one of the following:-   any date previous to today\n-   today\n\n</td></tr><tr><td>\n\nafter\n\n</td><td>\n\n\\[SLA due\\]\\[after\\]\\[Today\\]\n\n</td><td>\n\n&gt;\n\n</td><td>\n\nsla\\_due&gt;javascript:gs.daysAgoEnd\\(0\\)\n\n</td><td>\n\nAll records in which the value for the **SLA due** field is any date after today.\n\n</td></tr><tr><td>\n\nat or after\n\n</td><td>\n\n\\[SLA due\\]\\[at or after\\]\\[Today\\]\n\n</td><td>\n\n&gt;=\n\n</td><td>\n\nsla\\_due&gt;=javascript:gs.daysAgoStart\\(0\\)\n\n</td><td>\n\nAll records in which the date value for the **SLA due** field is one of the following:-   today\n-   any date after today\n\n</td></tr><tr><td>\n\nbetween\n\n</td><td>\n\n\\[SLA due\\]\\[between\\]\\[Yesterday\\] and \\[Today\\]\n\n</td><td>\n\nBETWEEN\n\n</td><td>\n\nsla\\_dueBETWEENjavascript:gs.daysAgoStart\\(1\\)@javascript:gs.daysAgoEnd\\(0\\)\n\n</td><td>\n\nAll records in which the value for the **SLA due** field is either yesterday's or today's date.\n\n</td></tr><tr><td>\n\ntrend \\(on or after\\)\n\n</td><td>\n\n\\[SLA due\\]\\[trend\\]\\[on or after\\]\\[Monday\\]\n\n</td><td>\n\nDATEPART\n\n</td><td>\n\nsla\\_dueDATEPARTMonday@javascript:gs.datePart\\('dayofweek','monday','GE'\\)\n\n</td><td>\n\nAll records in which the date in the **SLA due** field is on any day of the week except a Sunday.\n\n</td></tr><tr><td>\n\ntrend \\(on or before\\)\n\n</td><td>\n\n\\[SLA due\\]\\[trend\\]\\[on or before\\]\\[Monday\\]\n\n</td><td>\n\nDATEPART\n\n</td><td>\n\nsla\\_dueDATEPARTMonday@javascript:gs.datePart\\('dayofweek','monday','LE'\\)\n\n</td><td>\n\nAll records in which the date in the **SLA due** field is on either a Sunday or a Monday.\n\n</td></tr><tr><td>\n\ntrend \\(after\\)\n\n</td><td>\n\n\\[SLA due\\]\\[trend\\]\\[after\\]\\[Monday\\]\n\n</td><td>\n\nDATEPART\n\n</td><td>\n\nsla\\_dueDATEPARTMonday@javascript:gs.datePart\\('dayofweek','monday','GT'\\)\n\n</td><td>\n\nAll records in which the date in the **SLA due** field is on any day of the week except a Sunday or a Monday.\n\n</td></tr><tr><td>\n\ntrend \\(before\\)\n\n</td><td>\n\n\\[SLA due\\]\\[trend\\]\\[before\\]\\[Monday\\]\n\n</td><td>\n\nDATEPART\n\n</td><td>\n\nsla\\_dueDATEPARTMonday@javascript:gs.datePart\\('dayofweek','monday','LT'\\)\n\n</td><td>\n\nAll records in which the date in the **SLA due** field is on a Sunday.\n\n</td></tr><tr><td>\n\ntrend \\(on\\)\n\n</td><td>\n\n\\[SLA due\\]\\[trend\\]\\[on\\]\\[Monday\\]\n\n</td><td>\n\nDATEPART\n\n</td><td>\n\nsla\\_dueDATEPARTMonday@javascript:gs.datePart\\('dayofweek','monday','EE'\\)\n\n</td><td>\n\nAll records in which the date in the **SLA due** field is on a Monday.\n\n</td></tr><tr><td>\n\nrelative \\(after\\)\n\n</td><td>\n\n\\[SLA due\\]\\[relative\\]\\[after\\]\\[1\\]\\[Hours\\]\\[ago\\]\n\n</td><td>\n\nRELATIVEGT\n\n</td><td>\n\nsla\\_dueRELATIVEGT@hour@ago@1\n\n</td><td>\n\nAll records in which the time on the **SLA due** field is no more than an hour before the time that you entered the query.\n\n</td></tr><tr><td>\n\nrelative \\(before\\)\n\n</td><td>\n\n\\[SLA due\\]\\[relative\\]\\[before\\]\\[1\\]\\[Hours\\]\\[ago\\]\n\n</td><td>\n\nRELATIVELT\n\n</td><td>\n\nsla\\_dueRELATIVELT@hour@ago@1\n\n</td><td>\n\nAll records in which the time on the **SLA due** field is less than an hour before the time that you entered the query.\n\n</td></tr><tr><td>\n\nis empty\n\n</td><td>\n\n\\[SLA due\\]\\[is empty\\]\n\n</td><td>\n\nISEMPTY\n\n</td><td>\n\nsla\\_dueISEMPTY\n\n</td><td>\n\nAll records in which the **SLA due** field has no value.\n\n</td></tr><tr><td>\n\nis not empty\n\n</td><td>\n\n\\[SLA due\\]\\[is not empty\\]\n\n</td><td>\n\nISNOTEMPTY\n\n</td><td>\n\nsla\\_dueISNOTEMPTY\n\n</td><td>\n\nAll records in which the **SLA due** is populated by any value.\n\n</td></tr><tr><td>\n\nis anything\n\n</td><td>\n\n\\[SLA due\\]\\[is anything\\]\n\n</td><td>\n\nANYTHING\n\n</td><td>\n\nsla\\_dueANYTHING\n\n</td><td>\n\nAll records in which the **SLA due** field is one of the following:-   any value\n-   empty\n-   NULL\n\n</td></tr><tr><td>\n\nis same\n\n</td><td>\n\n\\[SLA due\\]\\[is same\\] as \\[Activity due\\]\n\n</td><td>\n\nSAMEAS\n\n</td><td>\n\nsla\\_dueSAMEASactivity\\_due@day\n\n</td><td>\n\nAll records in which there are matching values for the **SLA due** and **Activity due** fields.\n\n</td></tr><tr><td>\n\nis different\n\n</td><td>\n\n\\[SLA due\\]\\[is different\\] from \\[Activity due\\]\n\n</td><td>\n\nNSAMEAS\n\n</td><td>\n\nsla\\_dueNSAMEASactivity\\_due@day\n\n</td><td>\n\nAll records in which there are differing values for the **SLA due** and **Activity due** fields.\n\n</td></tr><tr><td>\n\nis more than\n\n</td><td>\n\n\\[SLA due\\]\\[is more than\\]\\[1\\]\\[Days\\]\\[before\\]\\[Activity due\\]\n\n</td><td>\n\nMORETHAN\n\n</td><td>\n\nsla\\_dueMORETHANactivity\\_due@day@before@1\n\n</td><td>\n\nAll 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.\n\n</td></tr><tr><td>\n\nis less than\n\n</td><td>\n\n\\[SLA due\\]\\[is less than\\]\\[3\\]\\[Days\\]\\[before\\]\\[Activity due\\]\n\n</td><td>\n\nLESSTHAN\n\n</td><td>\n\nsla\\_dueLESSTHANactivity\\_due@day@before@3\n\n</td><td>\n\nAll 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.\n\n</td></tr></tbody>\n</table>## Operators available for numeric fields\n\n<table id=\"table_yz1_shy_dt\"><thead><tr><th>\n\nOperator label\n\n</th><th>\n\nExample condition\n\n</th><th>\n\nEquivalent query operator\n\n</th><th>\n\nExample query\n\n</th><th>\n\nExample output\n\n</th></tr></thead><tbody><tr><td>\n\nis\n\n</td><td>\n\n\\[Reassignment count\\]\\[is\\]\\[0\\]\n\n</td><td>\n\n=\n\n</td><td>\n\nreassignment\\_count=0\n\n</td><td>\n\nAll records in which the **Reassignment count** is nothing else but **0**.\n\n</td></tr><tr><td>\n\nis not\n\n</td><td>\n\n\\[Reassignment count\\]\\[is not\\]\\[0\\]\n\n</td><td>\n\n!=\n\n</td><td>\n\nreassignment\\_count!=0\n\n</td><td>\n\nAll records in which the value for the **Reassignment count** is any number but **0**.\n\n</td></tr><tr><td>\n\nis empty\n\n</td><td>\n\n\\[Reassignment count\\]\\[is empty\\]\n\n</td><td>\n\nEMPTY\n\n</td><td>\n\nreassignment\\_countISEMPTY\n\n</td><td>\n\nAll records in which there is no value in the **Reassignment count** field.\n\n</td></tr><tr><td>\n\nis not empty\n\n</td><td>\n\n\\[Reassignment count\\]\\[is not empty\\]\n\n</td><td>\n\nNOTEMPTY\n\n</td><td>\n\nreassignment\\_countISNOTEMPTY\n\n</td><td>\n\nAll records in which there is any number in the **Reassignment count** field.\n\n</td></tr><tr><td>\n\nless than\n\n</td><td>\n\n\\[Reassignment count\\]\\[less than\\]\\[2\\]\n\n</td><td>\n\n&lt;\n\n</td><td>\n\nreassignment\\_count&lt;2\n\n</td><td>\n\nAll records in which the value in the **Reassignment count** field is any number less than \\(but not equal to\\) **2**.\n\n</td></tr><tr><td>\n\ngreater than\n\n</td><td>\n\n\\[Reassignment count\\]\\[greater than\\]\\[2\\]\n\n</td><td>\n\n&gt;\n\n</td><td>\n\nreassignment\\_count&gt;2\n\n</td><td>\n\nAll records in which the value in the **Reassignment count** field is any number greater than \\(but not equal to\\) **2**.\n\n</td></tr><tr><td>\n\nless than or is\n\n</td><td>\n\n\\[Reassignment count\\]\\[less than or is\\]\\[2\\]\n\n</td><td>\n\n&lt;=\n\n</td><td>\n\nreassignment\\_count&lt;=2\n\n</td><td>\n\nAll records in which the value in the **Reassignment count** field is one of the following:-   a number less than 2\n-   2\n\n</td></tr><tr><td>\n\ngreater than or is\n\n</td><td>\n\n\\[Reassignment count\\]\\[greater than or is\\]\\[2\\]\n\n</td><td>\n\n&gt;=\n\n</td><td>\n\nreassignment\\_count&gt;=2\n\n</td><td>\n\nAll records in which the value in the **Reassignment count** field is one of the following:-   2\n-   a number greater than 2\n\n</td></tr><tr><td>\n\nbetween\n\n</td><td>\n\n\\[Reassignment count\\]\\[between\\]\\[1\\] and \\[3\\]\n\n</td><td>\n\nBETWEEN\n\n</td><td>\n\nreassignment\\_countBETWEEN1@3\n\n</td><td>\n\nAll records in which the number in the **Reassignment count** is either 1, 2, or 3.\n\n</td></tr><tr><td>\n\nis anything\n\n</td><td>\n\n\\[Reassignment count\\]\\[is anything\\]\n\n</td><td>\n\nANYTHING\n\n</td><td>\n\nreassignment\\_countANYTHING\n\n</td><td>\n\nAll records in which the **Reassignment count** field is one of the following:-   any value\n-   empty\n-   NULL\n\n</td></tr><tr><td>\n\nis same\n\n</td><td>\n\n\\[Reassignment count\\]\\[is same\\] as \\[Reopen count\\]\n\n</td><td>\n\nSAMEAS\n\n</td><td>\n\nreassignment\\_countSAMEASreopen\\_count\n\n</td><td>\n\nAll records in which there are matching numbers for the **Reassignment count** and **Reopen count** fields.\n\n</td></tr><tr><td>\n\nis different\n\n</td><td>\n\n\\[Reassignment count\\]\\[is different\\] from \\[Reopen count\\]\n\n</td><td>\n\nNSAMEAS\n\n</td><td>\n\nreassignment\\_countNSAMEASreopen\\_count\n\n</td><td>\n\nAll records in which there are differing values between the **Reassignment count** and **Reopen count** fields.\n\n</td></tr><tr><td>\n\ngreater than field\n\n</td><td>\n\n\\[Reassignment count\\]\\[greater than field\\]\\[Reopen count\\]\n\n</td><td>\n\nGT\\_FIELD\n\n</td><td>\n\nreassignment\\_countGT\\_FIELDreopen\\_count\n\n</td><td>\n\nAll records in which the number in the **Reassignment count** field is greater than \\(but not equal to\\) the number in the **Reopen count** field.\n\n</td></tr><tr><td>\n\nless than field\n\n</td><td>\n\n\\[Reassignment count\\]\\[less than field\\]\\[Reopen count\\]\n\n</td><td>\n\nLT\\_FIELD\n\n</td><td>\n\nreassignment\\_countLT\\_FIELDreopen\\_count\n\n</td><td>\n\nAll records in which the number in the **Reassignment count** field is less than \\(but not equal to\\) the number in the **Reopen count** field.\n\n</td></tr><tr><td>\n\ngreater than or is field\n\n</td><td>\n\n\\[Reassignment count\\]\\[greater than or is field\\]\\[Reopen count\\]\n\n</td><td>\n\nGT\\_OR\\_EQUALS\\_FIELD\n\n</td><td>\n\nreassignment\\_countGT\\_OR\\_EQUALS\\_FIELDreopen\\_count\n\n</td><td>\n\nAll records in which the number in the **Reassignment count** field is one of the following:-   greater than the number in the **Reopen count** field\n-   equal to the number in the **Reopen count** field\n\n</td></tr><tr><td>\n\nless than or is field\n\n</td><td>\n\n\\[Reassignment count\\]\\[less than or is field\\]\\[Reopen count\\]\n\n</td><td>\n\nLT\\_OR\\_EQUALS\\_FIELD\n\n</td><td>\n\nreassignment\\_countLT\\_OR\\_EQUALS\\_FIELDreopen\\_count\n\n</td><td>\n\nAll records in which the number in the **Reassignment count** field is one of the following:-   less than the number in the **Reopen count** field\n-   equal to the number in the **Reopen count** field\n\n</td></tr></tbody>\n</table>## Operators available for Boolean fields\n\n<table id=\"table_vfm_d3y_dt\"><thead><tr><th>\n\nOperator label\n\n</th><th>\n\nExample condition\n\n</th><th>\n\nEquivalent query operator\n\n</th><th>\n\nExample query\n\n</th><th>\n\nExample output\n\n</th></tr></thead><tbody><tr><td>\n\nis\n\n</td><td>\n\n\\[Active\\]\\[is\\]\\[true\\]\n\n</td><td>\n\n=\n\n</td><td>\n\nactive=true\n\n</td><td>\n\nAll records in which the **Active** field is **True**.\n\n</td></tr><tr><td>\n\nis not\n\n</td><td>\n\n\\[Active\\]\\[is not\\]\\[true\\]\n\n</td><td>\n\n!=\n\n</td><td>\n\nactive!=true\n\n</td><td>\n\nAll records in which the **Active** field is **False**, empty, or NULL.\n\n</td></tr><tr><td>\n\nis empty\n\n</td><td>\n\n\\[Active\\]\\[is empty\\]\n\n</td><td>\n\nISEMPTY\n\n</td><td>\n\nactiveISEMPTY\n\n</td><td>\n\nAll records in which there is no value in the **Active** field.\n\n</td></tr><tr><td>\n\nis not empty\n\n</td><td>\n\n\\[Active\\]\\[is not empty\\]\n\n</td><td>\n\nISNOTEMPTY\n\n</td><td>\n\nactiveISNOTEMPTY\n\n</td><td>\n\nAll records in which the **Active** field is either **True** or **False**.\n\n</td></tr><tr><td>\n\nis anything\n\n</td><td>\n\n\\[Active\\]\\[is anything\\]\n\n</td><td>\n\nANYTHING\n\n</td><td>\n\nactiveANYTHING\n\n</td><td>\n\nAll records in which the **Active** field is one of the following:-   True\n-   False\n-   empty\n-   NULL\n\n</td></tr><tr><td>\n\nis same\n\n</td><td>\n\n\\[Active\\]\\[is same\\] as \\[Made SLA\\]\n\n</td><td>\n\nSAMEAS\n\n</td><td>\n\nactiveSAMEASmade\\_sla\n\n</td><td>\n\nAll records in which there are matching values for the **Active** and **Made SLA** fields.\n\n</td></tr><tr><td>\n\nis different\n\n</td><td>\n\n\\[Active\\]\\[is different\\] from \\[Made SLA\\]\n\n</td><td>\n\nNSAMEAS\n\n</td><td>\n\nactiveNSAMEASmade\\_sla\n\n</td><td>\n\nAll records in which there are differing values for the **Active** and **Made SLA** fields.\n\n</td></tr></tbody>\n</table>## Operators available for email notifications\n\n|Operator label|Example condition|Equivalent query operator|Example query|Example output|\n|--------------|-----------------|-------------------------|-------------|--------------|\n|changes|\\[State\\]\\[changes\\]|VALCHANGES|stateVALCHANGES|All records in which the **State** field is updated.|\n|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\\).|\n|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.|\n\n## Operators available for tags\n\n|Operator label|Example condition|Equivalent query operator|Example query|Example output|\n|--------------|-----------------|-------------------------|-------------|--------------|\n|have|\\[Tag\\]\\[have\\]\\[Most Active\\]|=|sys\\_tags.6c361e12471331007f47563dbb9a7135=6c361e12471331007f47563dbb9a7135|All records that have the **Tag** in the value field.|\n|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.|\n|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.|\n\n**Parent Topic:**[Create a condition statement using the condition builder](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-user-interface/create-cond-state-using-cond-build.md)\n\n**Related topics**  \n\n\n[Condition builder]()\n\n"}}