Skip to content
Last updated

Array Operators

When a field is used to record multiple values, it is recorded as an array. Those values can still be individually searchable and selectable. Array operators allow a user to create a rule that selects from those multiple values for a specific profile. The following is a list of array operators.

Array Operator


=is multiple
≠is not multiple
is null
is not null
contains
not contains
starts with
not starts with
ends with
not ends with

All of the array operators have the following options available:

any

  • This operator includes all of the records with at least one of the values in the array.

  • The array can have values not listed. (e.g. Africa)

only

  • This operator includes all the records containing only a combination of the values selected or an empty array.


at least

  • This operator includes all the records with at least x values in the array

  • The array can have values not listed (e.g. Africa

at most

  • This operator includes all the records with at most x values in the array

  • The array can have values not listed (e.g. Africa)

exactly

  • This operator includes all the records with at exactly x values in the array

  • The array can have values not listed (e.g. Africa)