The operands you can use to filter your data table vary based on your selected column's data type:

Short text

The following operands are available:

• Equals
• Is not equal to
• Starts with
• Is null
• Is not null

Long text

The following operands are available:

• Equals
• Is not equal to
• Starts with
• Is null
• Is not null

Integer

The following operands are available:

• Equals
• Is not equal to
• Is less than
• Is greater than
• Is less or equals
• Is greater or equals
• Is null
• Is not null

Decimal

The following operands are available:

• Equals
• Is not equal to
• Is less than
• Is greater than
• Is less or equals
• Is greater or equals
• Is null
• Is not null

Boolean

The following operands are available:

• Is true
• Is false
• Is null
• Is not null

Date

The following operands are available:

• Equals
• Is not equal to
• Is before
• Is after
• Is on or before
• Is on or after
• Is null
• Is not null

DateTime

The following operands are available:

• Equals
• Is not equal to
• Is before
• Is after
• Is on or before
• Is on or after
• Is null
• Is not null

Link to a table

The following operands are available:

• Equals
• Is not equal to
• In
• Is null
• Is not null

File

The following operands are available:

• Equals
• Is not equal to
• Is null
• Is not null

Multi-value

The following operands are available:

• Contains
• Is not null
• Is null