Type: Function
Function: NOT_INCLUDE
Syntax: NOT_INCLUDE(list, value)
Description: Returns true if the list does not contain the value.
NOT_INCLUDE is another name for NOT_CONTAINS: both names can be used.
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")returnstruefor the records not labelled "wontfix", including the records with no label.