field
operator
value
Data Field
you want to check (e.g., status
, priority
, deal_value
).=
, !=
, >
, <
)."DONE"
, "HIGH"
, 5000
).priority = "HIGH"
" "
). Numbers do not require quotes. Field and operator names are not case-sensitive, but Status
names often are.Operator | Meaning | Example |
---|---|---|
= | Equals | status = "DONE" |
!= | Does not equal | assignee != "John Doe" |
> | Greater than | deal_value > 10000 |
< | Less than | risk_score < 5 |
>= | Greater than or equal to | story_points >= 8 |
<= | Less than or equal to | tasks_completed <= 10 |
in | Is one of… (a list) | priority in ("HIGH", "URGENT") |
not in | Is not one of… (a list) | category not in ("Internal", "Archived") |
is empty | The field has no value | description is empty |
is not empty | The field has a value | assignee is not empty |
AND
& OR
AND
: Use AND
when you need all criteria to be true.
status = "OPEN" AND priority = "HIGH"
(Finds all 🧊 Objects
that are both open AND high priority).OR
: Use OR
when you need at least one of the criteria to be true.
assignee = "currentUser()" OR supervisor = "currentUser()"
(Finds all 🧊 Objects
where the current user is either the assignee OR the supervisor).( )
: For even more complex logic, you can group criteria with parentheses, just like in mathematics.
status = "OPEN" AND (priority = "HIGH" OR due_date < "today")
(Finds all open 🧊 Objects
that are either high priority OR overdue).assignee = "me" AND status.category != "Completed"
) into a text box, and the list of 🧊 Objects
below updates in real-time to reflect the filter.]