Contactplan processes three main types of data:
String
Attributes with a string data type have alpha-numeric values that can be made up of more than one word. For example, the store name attribute can have value such as N.5 mall.
Permissible operators
- Equal to.
- Like.
- Not equal to.
- Is null.
- Is not null.
Permissible input fields
- Checkbox.
- Multiple options.
- Autocomplete.
- Free text.
- Drill down.
Note:
The actual operators that are available vary according to the input field type that is set for the attribute.
See Operator types and/or Input field types for more about each operator or input field.
Numeric
Attributes with a numeric data type can only have numeric values, such as integers, long integers, floats, real and so on. For example, the number of purchases attribute can have a value such as 1, 2, 3…, while the items in the order attribute can have a value such as 1, 2, 3…, or -1, -2…, when returns are involved.
Permissible operators
- Equal to.
- Not equal to.
- Greater than.
- Less than.
- Equal to or greater than.
- Equal to or less than.
- Between.
- Is null.
- Is not null.
Permissible input fields
- Checkbox.
- Multiple options.
- Number.
Note:
The actual operators that are available vary according to the input field type that is set for the attribute.
See Operator types and/or Input field types for more about each operator or input field.
Date
Attributes with a date data type have a value that uses the DD/MM/YYYY format.
Permissible operators
- Equal to.
- Not equal to.
- Greater than.
- Less than.
- Equal to or greater than.
- Equal to or less than.
- Between.
- Is null.
- Is not null.
Note:
The following applies when expressing conditions for attributes with a date data type:
- Greater than = After the specified date.
- Less than = Before the specified date.
- Between = Within the range specified by the two dates.
Permissible input fields
- Calendar.
See Operator types and/or Input field types for more about each operator or input field.