Skip to main content

NOT_INCLUDE_ANY_OF

Written by Tom Williams

Type: Function

Function: NOT_INCLUDE_ANY_OF

Syntax: NOT_INCLUDE_ANY_OF(list, values)

Description: Returns true if the list contains none of the values.

NOT_INCLUDE_ANY_OF is another name for NOT_CONTAINS: both names can be used.

It is the same condition as the does not contain any 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_ANY_OF(label_names, ["wontfix", "duplicate"]) returns true for the records labelled neither "wontfix" nor "duplicate".

Did this answer your question?