Data types and operators

Conditions allow you to restrict the recordings that are selected for archiving. Operators are used to define these conditions. For example, a commonly used operator is Equal To, used to restrict the selection to recordings in which a field has a specific value.

The value in each field is of a specific data type, such as DateTime or String. The data types available for selection vary depending on the operator.

Data types

Data Type

Description

Boolean

Boolean data types contain true/false values, such as on/off, yes/no. Enter values as 0 or 1, where

0 is No, False, or Off

1 is Yes, True, or On

DateTime

Calendar controls are available when entering dates and times.

  • To select a date on the calendar, click one. To use the current date, click Today.

  • Use the << and >> controls to move forward or back through the years.

  • Use the < and > controls to move forward or back through the months.

  • Click to select the unit of time (hour or minute). Then, type in the value or use the up and down controls for the field to set it. (U.S. time formats also include AM and PM. The arrow controls switch between the two.)

  • Once you type a value for a unit such as the hour, the focus will automatically move to the next unit to the right.

  • Use the Tab key to move through the time fields.

  • Click Set to use the selected date and time.

Numeric

Numeric values contain digits, 0-9.

String

String values contain text, such as the names of people.

Operators

Operator

Data Type

Description

Example

Greater Than

Numeric, Datetime

Use to specify a minimum value.

Select all interactions where the duration is 60 seconds or longer:
Call Duration Greater Than 59

Less Than

Numeric, Datetime

Use to specify a maximum value.

Select all interactions that started before midnight on 31 December 2017:

Startdate Less Than 2017/12/31 12:00:00 AM

Greater or Equal

Numeric, Datetime

Use to specify a minimum value for a field.

Select all recordings where duration is, at a minimum, 60 seconds:

Contact Duration Greater or Equal 60

Less or Equal

Numeric, Datetime

Use to specify a maximum value for a field.

Select all recordings where duration is at most 10 minutes (expressed as seconds):

Contact Duration Less or Equal 600

At Least

(Trading Only)

Numeric, Datetime

Use to specify a minimum value for a field.

Select all recordings where duration is equal to or greater than 60 seconds:

Call Duration At Least 60

At Most

(Trading Only)

Numeric, Datetime

Use to specify a maximum value for a field.

Select all recordings where duration is equal to or less than 10 minutes (expressed as seconds):

Contact Duration At Most 600

Any In List

String, Numeric

Use to specify a list of values. Calls containing any of those values are returned.

Select all interactions made by any of the specified values:

Any In List 'Jill';'Steve';'Louis'; 'Peter'

Not in list

String, Numeric

 

Use to exclude a specific list of values. Recordings containing any of those values are not returned.

Select all interactions except those interactions made by any of the specified values:

Name Not In List 'Jill';'Steve';'Louis'; 'Peter'

Contains

String

Use to search for a value within a field.

Select all interactions made by Pete:

Name Contains Pete

Equal to

String, Numeric,

Datetime, Boolean

Use this operator to search for interactions with a specific value for that field.

Select all interactions where the name field is equal to Peter Smith:

Name Equal To Peter Smith

In Range

Numeric, Datetime

Specifies a range of values for a field. When selected, two value fields are provided. Place the low value on the left and the high value on the right.

This operator is inclusive.

Select all interactions where the duration is between 60 and 90 seconds:

Call Duration In Range 60 90

Like

String

Use to search for a value within a field.

Select all interactions where the employee name is similar to Susan:

Caller name Like Sus

Not equal to

String, Numeric,

Datetime, Boolean

Use to exclude specific field values.

Select all interactions except those interactions made by agent Peter Smith:

Agent Not Equal to Peter Smith

Create a campaign

Edit a campaign

Delete a campaign

Conditions to include interactions where Employee ID is unknown