Operators Reference

The operators you can use depend on the column’s data type. This page covers every operator.

Text (String) columns

String columns have the most operators, including pattern matching.

Operator	Description	Example
Equals	Exact match (case-sensitive)	Company Name Equals "Acme Corp"
Not Equal	Everything except this value	Status Not Equal "Closed"
Contains	Text includes the value anywhere	Description Contains "urgent"
Does Not Contain	Text doesn’t include the value	Subject Does Not Contain "test"
Starts With	Text begins with the value	Ticket ID Starts With "INC"
Ends With	Text ends with the value	Email Ends With "@company.com"
Is Blank	Empty string or null	Notes Is Blank
Is Not Blank	Has any value	Assignee Is Not Blank

Multiple value selection

For string columns, these operators support selecting multiple values:

• Equals / Not Equal
• Contains / Does Not Contain
• Starts With
• Ends With

When you select multiple values:

• Equals: Matches ANY of the values (implicit OR)
• Not Equal: Excludes ALL of the values (implicit AND)
• Contains: Text includes ANY of the values

Example: Status Equals ["Open", "Pending", "In Progress"]

This matches records where Status is Open OR Pending OR In Progress.

---

Number columns (Integer/Float)

Numeric columns support comparison operators.

Operator	Description	Example
Equals	Exact numeric match	Priority Equals 1
Not Equal	Any value except this	Priority Not Equal 0
Greater Than	Values above threshold	Amount Greater Than 1000
Less Than	Values below threshold	Age Less Than 18
Greater Than or Equal	At or above threshold	Score Greater Than or Equal 80
Less Than or Equal	At or below threshold	Quantity Less Than or Equal 100
Is Blank	No value (null)	Revenue Is Blank
Is Not Blank	Has any numeric value	Cost Is Not Blank

Entering numeric values

• Type the number directly
• Decimal values work for float columns
• Negative values are supported

---

Date and Datetime columns

Date columns have specialized operators for time-based filtering.

Operator	Description	Example
On	Matches a specific date	Created Date On Today
Not On	Any date except this one	Due Date Not On Yesterday
Before	Dates prior to the value	Start Date Before End of Last Month
After	Dates following the value	Modified Date After Start of This Week
Between	Date range (relative only)	Created Date Between Last 30 Days
Is Blank	No date set (null)	Resolved Date Is Blank
Is Not Blank	Has any date value	Due Date Is Not Blank

Date value options

Each date operator (except Is Blank/Is Not Blank) supports three modes:

1. Relative Time: Beginning/End of day, week, month, quarter, year
2. Static Time: A specific calendar date from a date picker
3. Current Time with Offset: Now plus/minus days, hours, minutes

See Date Filtering for detailed examples.

The Between operator

Between is unique:

• Uses relative time units only (no static date ranges)
• Configures a start and end boundary
• Each boundary can use different time units
• Supports hour-level precision

See Date Filtering for configuration details.

---

Boolean columns (True/False)

Boolean columns have simple equality operators.

Operator	Description	Example
Equals	Matches true or false	Is Active Equals true
Not Equal	Opposite of the value	Is Deleted Not Equal true
Is Blank	No value set (null)	Is Verified Is Blank
Is Not Blank	Has true or false value	Is Approved Is Not Blank

Entering boolean values

A toggle button appears with two options: true and false. Click to select.

---

Timedelta columns (Duration)

Timedelta columns represent durations (time elapsed, time remaining).

Operator	Description	Example
Equals	Exact duration match	Response Time Equals 1 hour
Not Equal	Any duration except this	Wait Time Not Equal 0
Greater Than	Longer than threshold	Resolution Time Greater Than 4 hours
Less Than	Shorter than threshold	Response Time Less Than 30 minutes
Greater Than or Equal	At least this duration	Active Time Greater Than or Equal 1 day
Less Than or Equal	At most this duration	Idle Time Less Than or Equal 5 minutes
Is Blank	No duration set	Pause Duration Is Blank
Is Not Blank	Has a duration value	Work Time Is Not Blank

Entering duration values

Duration values are stored in seconds internally but displayed in human-readable format. The input supports days, hours, and minutes.

---

Null/Blank handling

Understanding how null values behave is important for accurate filtering.

Is Blank vs Is Not Blank

Operator	Matches
Is Blank	null, empty string "", missing value
Is Not Blank	Any non-null, non-empty value

Not Equal and nulls

Important: Not Equal typically excludes null values.

Example: Assignee Not Equal "John"

This returns records where:

• Assignee is someone other than John
• Does NOT include records where Assignee is blank

To include blanks, use a group with OR logic:

( Assignee Not Equal "John"
    OR
  Assignee Is Blank )

---

Operator behavior summary

Behavior	Text	Number	Date	Boolean	Timedelta
Equality	Yes	Yes	On/Not On	Yes	Yes
Comparison (>,<)	No	Yes	Before/After	No	Yes
Pattern Matching	Yes	No	No	No	No
Range (Between)	No	No	Yes	No	No
Multiple Values	Yes	No	No	No	No
Blank Check	Yes	Yes	Yes	Yes	Yes

---

Related topics

• Date Filtering — Detailed guide for date operators
• Advanced Values — Column comparison and filter variables
• Examples & Use Cases — Real-world filtering scenarios