Type: Function
Function: LENGTH_LESS_THAN_EQUAL
Syntax: LENGTH_LESS_THAN_EQUAL(list, number)
Description: Returns true if the number of values in the list is less than or equal to the number.
The list is a field holding several values, such as label_names or assignee_usernames. Its number of values is the one LENGTH returns.
LENGTH_LESS_THAN_EQUAL(list, number) is the same as LESS_THAN_EQUAL(ARRAY_LENGTH(list), number).
It is the same condition as the length <= 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:
LENGTH_LESS_THAN_EQUAL(assignee_usernames, 1)returnstruefor the records with one assignee or none.