Documentation
Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage
  1. Docs
  2. /
  3. Reference
  4. /
  5. Hook Conditions
  6. /
  7. contains all

contains all

The CONTAINS ALL and NOT CONTAINS ALL operator is used to evaluate whether a particular set includes all the given values.

Syntax 

  <set> CONTAINS ALL (<value>, <value>, ...)

  <set> NOT CONTAINS ALL (<value>, <value>, ...)

Parameters

<set>
A set of values to consider.

Returns

TRUE
If the set contains all the values provided. This includes if any of the values provided are null and the set contains at least one null. Or FALSE in the case of the NOT CONTAINS ALL operator.
FALSE
If the set does not contain all the provided values. Or TRUE in the case of the NOT CONTAINS ALL operator
NULL
If the set contains at least one null and does not contain all the values provided and the values are not null.

Examples 

DATABASES CONTAINS ALL ("MY DATABASE", "OTHER DATABASE")

DATABASES CONTAINS ALL (null, "MY DATABASE")

DATABASES NOT CONTAINS ALL (null, "MY DATABASE")