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
