Skip to main content

Filter

Redirect: if you were looking for filter-links please refer to the filter-links documentation page.

The filter operator accepts a dataframe and applies a set of filter conditions to it. As shown in the following animation, multiple filter conditions can be applied at once. The filter conditions can be combined with either AND/OR logical operators.

Currently, the following types of filter conditions are supported:

Data TypeOperator
String

equals

contains

contains any

contains all

starts with

ends with

does not contain

is null

is not null

is empty

Numeric

equals (==)

does not equal (!=)

greater than (>)

greater than or equal to (>=)

less than (<)

less than or equal to (<=)

range

is null

is not null

Date

is

before

on or before

after

on or after

range

is null

is not null

Boolean

is

is not

is null

is not null