Data types

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.