Skip to main content

NOT_INCLUDE_ONLY

Written by Tom Williams

Type: Function

Function: NOT_INCLUDE_ONLY

Syntax: NOT_INCLUDE_ONLY(list, values)

Description: Returns true if the list contains a value which is not one of the values.

NOT_INCLUDE_ONLY is the opposite of CONTAINS_ONLY: NOT_INCLUDE_ONLY(list, values) is the same as NOT(CONTAINS_ONLY(list, values)).

It is the same condition as the does not contain only 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_ONLY(label_names, ["bug", "urgent"]) returns true for the records with a label other than "bug" and "urgent". A record with no label returns false.

Did this answer your question?