Skip to main content

NOT_INCLUDE

Written by Tom Williams

Type: Function

Function: NOT_INCLUDE

Syntax: NOT_INCLUDE(list, value)

Description: Returns true if the list does not contain the value.

NOT_INCLUDE takes a single value. To exclude several values, use NOT_INCLUDE_ANY_OF.

It is the same condition as the does not contain 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(label_names, "wontfix") returns true for the records not labelled "wontfix", including the records with no label.

Did this answer your question?