Type: Function
Function: NOT_INCLUDE_ALL_OF
Syntax: NOT_INCLUDE_ALL_OF(list, values)
Description: Returns true if the list misses at least one of the values.
NOT_INCLUDE_ALL_OF is the opposite of CONTAINS_ALL: NOT_INCLUDE_ALL_OF(list, values) is the same as NOT(CONTAINS_ALL(list, values)).
It is the same condition as the does not contain all of filter of the insight designer (see Using filters). Use it in a custom formula, to count, group or label records on that condition, or as a filter in a query sent through the Keypup API or MCP server.
Sample usage:
NOT_INCLUDE_ALL_OF(label_names, ["bug", "urgent"])returnstruefor the records not labelled both "bug" and "urgent": those with one of the two labels, or neither.