Contents Now Platform User Interface Previous Topic Next Topic Operators available for filters and queries Subscribe Log in to subscribe to topics and get notified when content changes. ... SAVE AS PDF Selected Topic Topic & Subtopics All Topics in Contents Share Operators available for filters and queries The system provides a set of operators for use with filters, condition builders, and encoded queries. A field's data type determines what operators are available for it. Table 1. Operators available for condition builders Operator label Example condition Equivalent query operator Example query AND [Active][is][True][AND][Caller][is not empty] ^ active=true^CallerISNOTEMPTY OR condition [Short description][is empty][OR][Description][is empty] ^OR short_descriptionISEMPTY^ORdescriptionISEMPTY OR filter All of these conditions must be met [Short description][is empty] OR all of these conditions must be met [Description][is not empty] ^NQ new query short_descriptionISEMPTY^NQdescriptionISNOTEMPTY Table 2. Operators available for string fields Operator label Example condition Equivalent query operator Example query starts with [Short description][starts with][SAP] STARTSWITH short_descriptionSTARTSWITHSAP ends with [Short description][ends with][outage] % ENDSWITH short_descriptionENDSWITHoutage contains [Short description][contains][SAP] * LIKE short_descriptionLIKESAP does not contain [Short description][does not contain][SAP] !* NOTLIKE short_descriptionNOT LIKESAP is [Short description][is][Network storage unavailable] = short_description=Network storage unavailable is not [Short description][is not][Network storage unavailable] != short_description!=Network storage unavailable is empty [Short description][is empty] ISEMPTY short_descriptionISEMPTY is not empty [Short description][is not empty] ISNOTEMPTY short_descriptionISNOTEMPTY is anything [Short description][is anything] ANYTHING short_descriptionANYTHING is empty string [Short description][is empty string] EMPTYSTRING short_descriptionEMPTYSTRING less than or is [Short description][less than or is][s] <= short_descriptionlt;=s greater than or is [Short description][greater than or is][s] >= short_description>=s between [Short description][between][q] and [t] BETWEEN short_descriptionBETWEENq@t is same [Short description][is same] as [Description] SAMEAS short_descriptionSAMEASdescription is different [Short description][is different] from [Description] NSAMEAS short_descriptionNSAMEASdescription Table 3. Operators available for reference fields Operator label Example condition Equivalent query operator Example query is [Caller][is][Don Goodliffe] = caller_id=9ee1b13dc6112271007f9d0efdb69cd0 is not [Caller][is not][Don Goodliffe] != caller_id!=9ee1b13dc6112271007f9d0efdb69cd0 is empty [Caller][is empty] ISEMPTY caller_idISEMPTY is not empty [Caller][is not empty] ISNOTEMPTY caller_idISNOTEMPTY starts with [Caller][starts with][Don] STARTSWITH caller_idSTARTSWITHDon ends with [Caller][ends with][liffe] % ENDSWITH caller_idENDSWITHliffe contains [Caller][contains][on] * LIKE caller_idLIKEon does not contain [Caller][does not contain][on] !* NOTLIKE caller_idNOT LIKEon is anything [Caller][is anything] ANYTHING caller_idANYTHING is same [Caller][is same] as [Assigned to] SAMEAS caller_idSAMEASassigned_to is different [Caller][is different] from [Assigned to] NSAMEAS caller_idNSAMEASassigned_to is empty string [Caller][is empty string] EMPTYSTRING caller_idEMPTYSTRING is (dyanmic) [Caller][is (dynamic)][Me] DYNAMIC caller_idDYNAMIC54635e965f510100a9ad2572f2b4774c Note: Not all operators are available for all reference types. Depending on the reference you select, you may see a shorter list of operators. Table 4. Operators available for choice fields containing strings Operator label Example condition Equivalent query operator Example query is [Subcategory][is][Email] = subcategory=email is not [Subcategory][is not][Email] != subcategory!=email is one of [Subcategory][is one of][DB2, MS SQL Server, Oraclel] IN subcategoryINdb2,sql server,oracle is not one of [Subcategory][is not one of][DB2, MS SQL Server, Oraclel] NOT IN subcategoryNOT INdb2,sql server,oracle contains [Subcategory][contains][Em] LIKE subcategoryLIKEem starts with [Subcategory][starts with][Em] STARTSWITH subcategorySTARTSWITHem ends with [Subcategory][ends with][il] % ENDSWITH subcategoryENDSWITHil does not contain [Subcategory][does not contain][Em] NOT LIKE subcategoryNOT LIKEem is anything [Subcategory][is anything] ANYTHING subcategoryANYTHING is same [Subcategory][is same] as [Category] SAMEAS subcategorySAMEAScategory is different [Subcategory][is different] from [Category] NSAMEAS subcategoryNSAMEAScategory Table 5. Operators available for choice fields containing integers Operator label Example condition Equivalent query operator Example query is [Impact][is][1 - High] = impact=1 is not [Impact][is not][1 - High] != impact!=1 is one of [Impact][is one of][1 - High, 2 - Medium] IN impactIN1,2 is not one of [Impact][is not one of][1 - High, 2 - Medium] NOT IN impactNOT IN1,2 is empty [Impact][is empty] EMPTY impactISEMPTY is not empty [Impact][is not empty] NOTEMPTY impactISNOTEMPTY less than [Impact][less than][2 - Medium] < impact<2 greater than [Impact][greater than][2 - Medium] > impact>2 less than or is [Impact][less than or is][2 - Medium] <= impact<=2 greater than or is [Impact][greater than or is][2 - Medium] >= impact>=2 between [Impact][between][1 - High] and [2 - Medium] BETWEEN impactBETWEEN1@2 is anything [Impact][is anything] ANYTHING impactANYTHING is same [Impact][is same] as [Urgency] SAMEAS impactSAMEASurgency is different [Impact][is different] from [Urgency] NSAMEAS impactNSAMEASurgency 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. Table 6. Operators available for date-time fields Operator label Example condition Equivalent query operator Example query on [SLA due][on][Today] ONToday sla_dueONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0) not on [SLA due][not on][Today] NOTONToday sla_dueNOTONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0) before [SLA due][before][Today] < sla_due<javascript:gs.daysAgoStart(0) at or before [SLA due][at or before][Today] <= sla_due<=javascript:gs.daysAgoEnd(0) after [SLA due][after][Today] > sla_due>javascript:gs.daysAgoEnd(0) at or after [SLA due][at or after][Today] >= sla_due>=javascript:gs.daysAgoStart(0) between [SLA due][between][Yesterday] and [Today] BETWEEN sla_dueBETWEENjavascript:gs.daysAgoStart(1)@javascript:gs.daysAgoEnd(0) trend (on or after) [SLA due][trend][on or after][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GE') trend (on or before) [SLA due][trend][on or before][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','LE') trend (after) [SLA due][trend][after][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GT') trend (before) [SLA due][trend][before][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','LT') trend (on) [SLA due][trend][on][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','EE') relative (on or after) [SLA due][relative][on or after][1][Hours][ago] RELATIVEGE sla_dueRELATIVEGE@hour@ago@1 relative (on or before) [SLA due][relative][on or before][1][Hours][ago] RELATIVELE sla_dueRELATIVELE@hour@ago@1 relative (after) [SLA due][relative][after][1][Hours][ago] RELATIVEGT sla_dueRELATIVEGT@hour@ago@1 relative (before) [SLA due][relative][before][1][Hours][ago] RELATIVELT sla_dueRELATIVELT@hour@ago@1 relative (on) [SLA due][relative][on][1][Hours][ago] RELATIVEEE sla_dueRELATIVEEE@hour@ago@1 is empty [SLA due][is empty] ISEMPTY sla_dueISEMPTY is not empty [SLA due][is not empty] ISNOTEMPTY sla_dueISNOTEMPTY is anything [SLA due][is anything] ANYTHING sla_dueANYTHING is same [SLA due][is same] as [Activity due] SAMEAS sla_dueSAMEASactivity_due@day is different [SLA due][is different] from [Activity due] NSAMEAS sla_dueNSAMEASactivity_due@day is more than [SLA due][is more than][1][Days][before][Activity due] MORETHAN sla_dueMORETHANactivity_due@day@before@1 is less than [SLA due][is less than][3][Days][before][Activity due] LESSTHAN sla_dueLESSTHANactivity_due@day@before@3 Table 7. Operators available for numeric fields Operator label Example condition Equivalent query operator Example query is [Reassignment count][is][0] = reassignment_count=0 is not [Reassignment count][is not][0] != reassignment_count!=0 is empty [Reassignment count][is empty] EMPTY reassignment_countISEMPTY is not empty [Reassignment count][is not empty] NOTEMPTY reassignment_countISNOTEMPTY less than [Reassignment count][less than][2] < reassignment_count<2 greater than [Reassignment count][greater than][2] > reassignment_count>2 less than or is [Reassignment count][less than or is][2] <= reassignment_count<=2 greater than or is [Reassignment count][greater than or is][2] >= reassignment_count>=2 between [Reassignment count][between][1] and [2] BETWEEN reassignment_countBETWEEN1@2 is anything [Reassignment count][is anything] ANYTHING reassignment_countANYTHING is same [Reassignment count][is same] as [Reopen count] SAMEAS reassignment_countSAMEASreopen_count is different [Reassignment count][is different] from [Reopen count] NSAMEAS reassignment_countNSAMEASreopen_count greater than field [Reassignment count][greater than field][Reopen count] GT_FIELD reassignment_countGT_FIELDreopen_count less than field [Reassignment count][less than field][Reopen count] LT_FIELD reassignment_countLT_FIELDreopen_count greater than or is field [Reassignment count][greater than or is field][Reopen count] GT_OR_EQUALS_FIELD reassignment_countGT_OR_EQUALS_FIELDreopen_count less than or is field [Reassignment count][less than or is field][Reopen count] LT_OR_EQUALS_FIELD reassignment_countLT_OR_EQUALS_FIELDreopen_count Table 8. Operators available for boolean fields Operator label Example condition Equivalent query operator Example query is [Active][is][true] = active=true is not [Active][is not][true] != active!=true is empty [Active][is empty] ISEMPTY activeISEMPTY is not empty [Active][is not empty] ISNOTEMPTY activeISNOTEMPTY is anything [Active][is anything] ANYTHING activeANYTHING is same [Active][is same] as [Made SLA] SAMEAS activeSAMEASmade_sla is different [Active][is different] from [Made SLA] NSAMEAS activeNSAMEASmade_sla Table 9. Operators available for email notifications Operator label Example condition Equivalent query operator Example query changes [State][changes] VALCHANGES stateVALCHANGES changes from [State][changes from][Awaiting User Info] CHANGESFROM stateCHANGESFROM4^EQ changes to [State][changes to][Awaiting User Info] CHANGESTO stateCHANGESTO4^EQ On this page Send Feedback Previous Topic Next Topic
Operators available for filters and queries The system provides a set of operators for use with filters, condition builders, and encoded queries. A field's data type determines what operators are available for it. Table 1. Operators available for condition builders Operator label Example condition Equivalent query operator Example query AND [Active][is][True][AND][Caller][is not empty] ^ active=true^CallerISNOTEMPTY OR condition [Short description][is empty][OR][Description][is empty] ^OR short_descriptionISEMPTY^ORdescriptionISEMPTY OR filter All of these conditions must be met [Short description][is empty] OR all of these conditions must be met [Description][is not empty] ^NQ new query short_descriptionISEMPTY^NQdescriptionISNOTEMPTY Table 2. Operators available for string fields Operator label Example condition Equivalent query operator Example query starts with [Short description][starts with][SAP] STARTSWITH short_descriptionSTARTSWITHSAP ends with [Short description][ends with][outage] % ENDSWITH short_descriptionENDSWITHoutage contains [Short description][contains][SAP] * LIKE short_descriptionLIKESAP does not contain [Short description][does not contain][SAP] !* NOTLIKE short_descriptionNOT LIKESAP is [Short description][is][Network storage unavailable] = short_description=Network storage unavailable is not [Short description][is not][Network storage unavailable] != short_description!=Network storage unavailable is empty [Short description][is empty] ISEMPTY short_descriptionISEMPTY is not empty [Short description][is not empty] ISNOTEMPTY short_descriptionISNOTEMPTY is anything [Short description][is anything] ANYTHING short_descriptionANYTHING is empty string [Short description][is empty string] EMPTYSTRING short_descriptionEMPTYSTRING less than or is [Short description][less than or is][s] <= short_descriptionlt;=s greater than or is [Short description][greater than or is][s] >= short_description>=s between [Short description][between][q] and [t] BETWEEN short_descriptionBETWEENq@t is same [Short description][is same] as [Description] SAMEAS short_descriptionSAMEASdescription is different [Short description][is different] from [Description] NSAMEAS short_descriptionNSAMEASdescription Table 3. Operators available for reference fields Operator label Example condition Equivalent query operator Example query is [Caller][is][Don Goodliffe] = caller_id=9ee1b13dc6112271007f9d0efdb69cd0 is not [Caller][is not][Don Goodliffe] != caller_id!=9ee1b13dc6112271007f9d0efdb69cd0 is empty [Caller][is empty] ISEMPTY caller_idISEMPTY is not empty [Caller][is not empty] ISNOTEMPTY caller_idISNOTEMPTY starts with [Caller][starts with][Don] STARTSWITH caller_idSTARTSWITHDon ends with [Caller][ends with][liffe] % ENDSWITH caller_idENDSWITHliffe contains [Caller][contains][on] * LIKE caller_idLIKEon does not contain [Caller][does not contain][on] !* NOTLIKE caller_idNOT LIKEon is anything [Caller][is anything] ANYTHING caller_idANYTHING is same [Caller][is same] as [Assigned to] SAMEAS caller_idSAMEASassigned_to is different [Caller][is different] from [Assigned to] NSAMEAS caller_idNSAMEASassigned_to is empty string [Caller][is empty string] EMPTYSTRING caller_idEMPTYSTRING is (dyanmic) [Caller][is (dynamic)][Me] DYNAMIC caller_idDYNAMIC54635e965f510100a9ad2572f2b4774c Note: Not all operators are available for all reference types. Depending on the reference you select, you may see a shorter list of operators. Table 4. Operators available for choice fields containing strings Operator label Example condition Equivalent query operator Example query is [Subcategory][is][Email] = subcategory=email is not [Subcategory][is not][Email] != subcategory!=email is one of [Subcategory][is one of][DB2, MS SQL Server, Oraclel] IN subcategoryINdb2,sql server,oracle is not one of [Subcategory][is not one of][DB2, MS SQL Server, Oraclel] NOT IN subcategoryNOT INdb2,sql server,oracle contains [Subcategory][contains][Em] LIKE subcategoryLIKEem starts with [Subcategory][starts with][Em] STARTSWITH subcategorySTARTSWITHem ends with [Subcategory][ends with][il] % ENDSWITH subcategoryENDSWITHil does not contain [Subcategory][does not contain][Em] NOT LIKE subcategoryNOT LIKEem is anything [Subcategory][is anything] ANYTHING subcategoryANYTHING is same [Subcategory][is same] as [Category] SAMEAS subcategorySAMEAScategory is different [Subcategory][is different] from [Category] NSAMEAS subcategoryNSAMEAScategory Table 5. Operators available for choice fields containing integers Operator label Example condition Equivalent query operator Example query is [Impact][is][1 - High] = impact=1 is not [Impact][is not][1 - High] != impact!=1 is one of [Impact][is one of][1 - High, 2 - Medium] IN impactIN1,2 is not one of [Impact][is not one of][1 - High, 2 - Medium] NOT IN impactNOT IN1,2 is empty [Impact][is empty] EMPTY impactISEMPTY is not empty [Impact][is not empty] NOTEMPTY impactISNOTEMPTY less than [Impact][less than][2 - Medium] < impact<2 greater than [Impact][greater than][2 - Medium] > impact>2 less than or is [Impact][less than or is][2 - Medium] <= impact<=2 greater than or is [Impact][greater than or is][2 - Medium] >= impact>=2 between [Impact][between][1 - High] and [2 - Medium] BETWEEN impactBETWEEN1@2 is anything [Impact][is anything] ANYTHING impactANYTHING is same [Impact][is same] as [Urgency] SAMEAS impactSAMEASurgency is different [Impact][is different] from [Urgency] NSAMEAS impactNSAMEASurgency 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. Table 6. Operators available for date-time fields Operator label Example condition Equivalent query operator Example query on [SLA due][on][Today] ONToday sla_dueONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0) not on [SLA due][not on][Today] NOTONToday sla_dueNOTONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0) before [SLA due][before][Today] < sla_due<javascript:gs.daysAgoStart(0) at or before [SLA due][at or before][Today] <= sla_due<=javascript:gs.daysAgoEnd(0) after [SLA due][after][Today] > sla_due>javascript:gs.daysAgoEnd(0) at or after [SLA due][at or after][Today] >= sla_due>=javascript:gs.daysAgoStart(0) between [SLA due][between][Yesterday] and [Today] BETWEEN sla_dueBETWEENjavascript:gs.daysAgoStart(1)@javascript:gs.daysAgoEnd(0) trend (on or after) [SLA due][trend][on or after][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GE') trend (on or before) [SLA due][trend][on or before][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','LE') trend (after) [SLA due][trend][after][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GT') trend (before) [SLA due][trend][before][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','LT') trend (on) [SLA due][trend][on][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','EE') relative (on or after) [SLA due][relative][on or after][1][Hours][ago] RELATIVEGE sla_dueRELATIVEGE@hour@ago@1 relative (on or before) [SLA due][relative][on or before][1][Hours][ago] RELATIVELE sla_dueRELATIVELE@hour@ago@1 relative (after) [SLA due][relative][after][1][Hours][ago] RELATIVEGT sla_dueRELATIVEGT@hour@ago@1 relative (before) [SLA due][relative][before][1][Hours][ago] RELATIVELT sla_dueRELATIVELT@hour@ago@1 relative (on) [SLA due][relative][on][1][Hours][ago] RELATIVEEE sla_dueRELATIVEEE@hour@ago@1 is empty [SLA due][is empty] ISEMPTY sla_dueISEMPTY is not empty [SLA due][is not empty] ISNOTEMPTY sla_dueISNOTEMPTY is anything [SLA due][is anything] ANYTHING sla_dueANYTHING is same [SLA due][is same] as [Activity due] SAMEAS sla_dueSAMEASactivity_due@day is different [SLA due][is different] from [Activity due] NSAMEAS sla_dueNSAMEASactivity_due@day is more than [SLA due][is more than][1][Days][before][Activity due] MORETHAN sla_dueMORETHANactivity_due@day@before@1 is less than [SLA due][is less than][3][Days][before][Activity due] LESSTHAN sla_dueLESSTHANactivity_due@day@before@3 Table 7. Operators available for numeric fields Operator label Example condition Equivalent query operator Example query is [Reassignment count][is][0] = reassignment_count=0 is not [Reassignment count][is not][0] != reassignment_count!=0 is empty [Reassignment count][is empty] EMPTY reassignment_countISEMPTY is not empty [Reassignment count][is not empty] NOTEMPTY reassignment_countISNOTEMPTY less than [Reassignment count][less than][2] < reassignment_count<2 greater than [Reassignment count][greater than][2] > reassignment_count>2 less than or is [Reassignment count][less than or is][2] <= reassignment_count<=2 greater than or is [Reassignment count][greater than or is][2] >= reassignment_count>=2 between [Reassignment count][between][1] and [2] BETWEEN reassignment_countBETWEEN1@2 is anything [Reassignment count][is anything] ANYTHING reassignment_countANYTHING is same [Reassignment count][is same] as [Reopen count] SAMEAS reassignment_countSAMEASreopen_count is different [Reassignment count][is different] from [Reopen count] NSAMEAS reassignment_countNSAMEASreopen_count greater than field [Reassignment count][greater than field][Reopen count] GT_FIELD reassignment_countGT_FIELDreopen_count less than field [Reassignment count][less than field][Reopen count] LT_FIELD reassignment_countLT_FIELDreopen_count greater than or is field [Reassignment count][greater than or is field][Reopen count] GT_OR_EQUALS_FIELD reassignment_countGT_OR_EQUALS_FIELDreopen_count less than or is field [Reassignment count][less than or is field][Reopen count] LT_OR_EQUALS_FIELD reassignment_countLT_OR_EQUALS_FIELDreopen_count Table 8. Operators available for boolean fields Operator label Example condition Equivalent query operator Example query is [Active][is][true] = active=true is not [Active][is not][true] != active!=true is empty [Active][is empty] ISEMPTY activeISEMPTY is not empty [Active][is not empty] ISNOTEMPTY activeISNOTEMPTY is anything [Active][is anything] ANYTHING activeANYTHING is same [Active][is same] as [Made SLA] SAMEAS activeSAMEASmade_sla is different [Active][is different] from [Made SLA] NSAMEAS activeNSAMEASmade_sla Table 9. Operators available for email notifications Operator label Example condition Equivalent query operator Example query changes [State][changes] VALCHANGES stateVALCHANGES changes from [State][changes from][Awaiting User Info] CHANGESFROM stateCHANGESFROM4^EQ changes to [State][changes to][Awaiting User Info] CHANGESTO stateCHANGESTO4^EQ
Operators available for filters and queries The system provides a set of operators for use with filters, condition builders, and encoded queries. A field's data type determines what operators are available for it. Table 1. Operators available for condition builders Operator label Example condition Equivalent query operator Example query AND [Active][is][True][AND][Caller][is not empty] ^ active=true^CallerISNOTEMPTY OR condition [Short description][is empty][OR][Description][is empty] ^OR short_descriptionISEMPTY^ORdescriptionISEMPTY OR filter All of these conditions must be met [Short description][is empty] OR all of these conditions must be met [Description][is not empty] ^NQ new query short_descriptionISEMPTY^NQdescriptionISNOTEMPTY Table 2. Operators available for string fields Operator label Example condition Equivalent query operator Example query starts with [Short description][starts with][SAP] STARTSWITH short_descriptionSTARTSWITHSAP ends with [Short description][ends with][outage] % ENDSWITH short_descriptionENDSWITHoutage contains [Short description][contains][SAP] * LIKE short_descriptionLIKESAP does not contain [Short description][does not contain][SAP] !* NOTLIKE short_descriptionNOT LIKESAP is [Short description][is][Network storage unavailable] = short_description=Network storage unavailable is not [Short description][is not][Network storage unavailable] != short_description!=Network storage unavailable is empty [Short description][is empty] ISEMPTY short_descriptionISEMPTY is not empty [Short description][is not empty] ISNOTEMPTY short_descriptionISNOTEMPTY is anything [Short description][is anything] ANYTHING short_descriptionANYTHING is empty string [Short description][is empty string] EMPTYSTRING short_descriptionEMPTYSTRING less than or is [Short description][less than or is][s] <= short_descriptionlt;=s greater than or is [Short description][greater than or is][s] >= short_description>=s between [Short description][between][q] and [t] BETWEEN short_descriptionBETWEENq@t is same [Short description][is same] as [Description] SAMEAS short_descriptionSAMEASdescription is different [Short description][is different] from [Description] NSAMEAS short_descriptionNSAMEASdescription Table 3. Operators available for reference fields Operator label Example condition Equivalent query operator Example query is [Caller][is][Don Goodliffe] = caller_id=9ee1b13dc6112271007f9d0efdb69cd0 is not [Caller][is not][Don Goodliffe] != caller_id!=9ee1b13dc6112271007f9d0efdb69cd0 is empty [Caller][is empty] ISEMPTY caller_idISEMPTY is not empty [Caller][is not empty] ISNOTEMPTY caller_idISNOTEMPTY starts with [Caller][starts with][Don] STARTSWITH caller_idSTARTSWITHDon ends with [Caller][ends with][liffe] % ENDSWITH caller_idENDSWITHliffe contains [Caller][contains][on] * LIKE caller_idLIKEon does not contain [Caller][does not contain][on] !* NOTLIKE caller_idNOT LIKEon is anything [Caller][is anything] ANYTHING caller_idANYTHING is same [Caller][is same] as [Assigned to] SAMEAS caller_idSAMEASassigned_to is different [Caller][is different] from [Assigned to] NSAMEAS caller_idNSAMEASassigned_to is empty string [Caller][is empty string] EMPTYSTRING caller_idEMPTYSTRING is (dyanmic) [Caller][is (dynamic)][Me] DYNAMIC caller_idDYNAMIC54635e965f510100a9ad2572f2b4774c Note: Not all operators are available for all reference types. Depending on the reference you select, you may see a shorter list of operators. Table 4. Operators available for choice fields containing strings Operator label Example condition Equivalent query operator Example query is [Subcategory][is][Email] = subcategory=email is not [Subcategory][is not][Email] != subcategory!=email is one of [Subcategory][is one of][DB2, MS SQL Server, Oraclel] IN subcategoryINdb2,sql server,oracle is not one of [Subcategory][is not one of][DB2, MS SQL Server, Oraclel] NOT IN subcategoryNOT INdb2,sql server,oracle contains [Subcategory][contains][Em] LIKE subcategoryLIKEem starts with [Subcategory][starts with][Em] STARTSWITH subcategorySTARTSWITHem ends with [Subcategory][ends with][il] % ENDSWITH subcategoryENDSWITHil does not contain [Subcategory][does not contain][Em] NOT LIKE subcategoryNOT LIKEem is anything [Subcategory][is anything] ANYTHING subcategoryANYTHING is same [Subcategory][is same] as [Category] SAMEAS subcategorySAMEAScategory is different [Subcategory][is different] from [Category] NSAMEAS subcategoryNSAMEAScategory Table 5. Operators available for choice fields containing integers Operator label Example condition Equivalent query operator Example query is [Impact][is][1 - High] = impact=1 is not [Impact][is not][1 - High] != impact!=1 is one of [Impact][is one of][1 - High, 2 - Medium] IN impactIN1,2 is not one of [Impact][is not one of][1 - High, 2 - Medium] NOT IN impactNOT IN1,2 is empty [Impact][is empty] EMPTY impactISEMPTY is not empty [Impact][is not empty] NOTEMPTY impactISNOTEMPTY less than [Impact][less than][2 - Medium] < impact<2 greater than [Impact][greater than][2 - Medium] > impact>2 less than or is [Impact][less than or is][2 - Medium] <= impact<=2 greater than or is [Impact][greater than or is][2 - Medium] >= impact>=2 between [Impact][between][1 - High] and [2 - Medium] BETWEEN impactBETWEEN1@2 is anything [Impact][is anything] ANYTHING impactANYTHING is same [Impact][is same] as [Urgency] SAMEAS impactSAMEASurgency is different [Impact][is different] from [Urgency] NSAMEAS impactNSAMEASurgency 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. Table 6. Operators available for date-time fields Operator label Example condition Equivalent query operator Example query on [SLA due][on][Today] ONToday sla_dueONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0) not on [SLA due][not on][Today] NOTONToday sla_dueNOTONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0) before [SLA due][before][Today] < sla_due<javascript:gs.daysAgoStart(0) at or before [SLA due][at or before][Today] <= sla_due<=javascript:gs.daysAgoEnd(0) after [SLA due][after][Today] > sla_due>javascript:gs.daysAgoEnd(0) at or after [SLA due][at or after][Today] >= sla_due>=javascript:gs.daysAgoStart(0) between [SLA due][between][Yesterday] and [Today] BETWEEN sla_dueBETWEENjavascript:gs.daysAgoStart(1)@javascript:gs.daysAgoEnd(0) trend (on or after) [SLA due][trend][on or after][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GE') trend (on or before) [SLA due][trend][on or before][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','LE') trend (after) [SLA due][trend][after][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GT') trend (before) [SLA due][trend][before][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','LT') trend (on) [SLA due][trend][on][Monday] DATEPART sla_dueDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','EE') relative (on or after) [SLA due][relative][on or after][1][Hours][ago] RELATIVEGE sla_dueRELATIVEGE@hour@ago@1 relative (on or before) [SLA due][relative][on or before][1][Hours][ago] RELATIVELE sla_dueRELATIVELE@hour@ago@1 relative (after) [SLA due][relative][after][1][Hours][ago] RELATIVEGT sla_dueRELATIVEGT@hour@ago@1 relative (before) [SLA due][relative][before][1][Hours][ago] RELATIVELT sla_dueRELATIVELT@hour@ago@1 relative (on) [SLA due][relative][on][1][Hours][ago] RELATIVEEE sla_dueRELATIVEEE@hour@ago@1 is empty [SLA due][is empty] ISEMPTY sla_dueISEMPTY is not empty [SLA due][is not empty] ISNOTEMPTY sla_dueISNOTEMPTY is anything [SLA due][is anything] ANYTHING sla_dueANYTHING is same [SLA due][is same] as [Activity due] SAMEAS sla_dueSAMEASactivity_due@day is different [SLA due][is different] from [Activity due] NSAMEAS sla_dueNSAMEASactivity_due@day is more than [SLA due][is more than][1][Days][before][Activity due] MORETHAN sla_dueMORETHANactivity_due@day@before@1 is less than [SLA due][is less than][3][Days][before][Activity due] LESSTHAN sla_dueLESSTHANactivity_due@day@before@3 Table 7. Operators available for numeric fields Operator label Example condition Equivalent query operator Example query is [Reassignment count][is][0] = reassignment_count=0 is not [Reassignment count][is not][0] != reassignment_count!=0 is empty [Reassignment count][is empty] EMPTY reassignment_countISEMPTY is not empty [Reassignment count][is not empty] NOTEMPTY reassignment_countISNOTEMPTY less than [Reassignment count][less than][2] < reassignment_count<2 greater than [Reassignment count][greater than][2] > reassignment_count>2 less than or is [Reassignment count][less than or is][2] <= reassignment_count<=2 greater than or is [Reassignment count][greater than or is][2] >= reassignment_count>=2 between [Reassignment count][between][1] and [2] BETWEEN reassignment_countBETWEEN1@2 is anything [Reassignment count][is anything] ANYTHING reassignment_countANYTHING is same [Reassignment count][is same] as [Reopen count] SAMEAS reassignment_countSAMEASreopen_count is different [Reassignment count][is different] from [Reopen count] NSAMEAS reassignment_countNSAMEASreopen_count greater than field [Reassignment count][greater than field][Reopen count] GT_FIELD reassignment_countGT_FIELDreopen_count less than field [Reassignment count][less than field][Reopen count] LT_FIELD reassignment_countLT_FIELDreopen_count greater than or is field [Reassignment count][greater than or is field][Reopen count] GT_OR_EQUALS_FIELD reassignment_countGT_OR_EQUALS_FIELDreopen_count less than or is field [Reassignment count][less than or is field][Reopen count] LT_OR_EQUALS_FIELD reassignment_countLT_OR_EQUALS_FIELDreopen_count Table 8. Operators available for boolean fields Operator label Example condition Equivalent query operator Example query is [Active][is][true] = active=true is not [Active][is not][true] != active!=true is empty [Active][is empty] ISEMPTY activeISEMPTY is not empty [Active][is not empty] ISNOTEMPTY activeISNOTEMPTY is anything [Active][is anything] ANYTHING activeANYTHING is same [Active][is same] as [Made SLA] SAMEAS activeSAMEASmade_sla is different [Active][is different] from [Made SLA] NSAMEAS activeNSAMEASmade_sla Table 9. Operators available for email notifications Operator label Example condition Equivalent query operator Example query changes [State][changes] VALCHANGES stateVALCHANGES changes from [State][changes from][Awaiting User Info] CHANGESFROM stateCHANGESFROM4^EQ changes to [State][changes to][Awaiting User Info] CHANGESTO stateCHANGESTO4^EQ
