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.
|
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: |
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 |
Conditions to include interactions where Employee ID is unknown