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:

Relative Time: Beginning/End of day, week, month, quarter, year
Static Time: A specific calendar date from a date picker
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

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