Type: Function
Function: NOT_IN
Syntax: NOT_IN(value, list)
Description: Returns true if the value is equal to none of the elements of the list.
NOT_IN is the opposite of IN: NOT_IN(value, list) is the same as NOT(IN(value, list)).
It is the same condition as the equals none 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_IN(state, ["CLOSED", "MERGED"])returnstruefor the issues and pull requests which are neither closed nor merged.COUNT_IF(NOT_IN(state, ["CLOSED", "MERGED"]))as a metric counts them.