Function WHERE()

 

Description
Returns items that meet a specified condition; outputs matching item names or IDs.

Syntax

WHERE(condition)

WHERE(condition, type)

Parameters

• condition – Boolean expression evaluated per item
• type (optional) – name, externalid, or internalid (default = name)

Return Value
ARRAY of TEXT (names or IDs)

 

Examples

Formula

WHERE(category == "Internal")

Result
["A","B","C"]

Formula

WHERE(category == "External", "externalid")

Result
[1004,1005,1006]

Formula

WHERE(Cost >= 4)

Result
["D","F"]

Formula

WHERE(Parent == {name})

Result
Returns child items for each item (e.g., A → [B,C,D], D → [E,F])

Notes

• Only usable in items (Items tab)
• Returns empty array if no matches
• Curly brackets {} evaluate per item context