Filter statements for string data types are case-insensitive, and can use comparisons, simple wildcard rules, or regex.
Symbol
Meaning
Example(s)
= (or empty)
Text equals
=spy
AAPL
!=
Text does not equal
!=spy
!=MSFT
*
Wildcard. Follows *. Java regex; zero or more letters.
A* ( matches A or AMD or AAPL)
*Z (matches XYZ)
~
Text contains
~sp
!~
Text does not contain
!~sp
null
Text field is empty (no value)
null
=null
!null
Text field is not empty
!null
!=null
Note
Filtering statements can also be combined. For example, !=A* is the equivalent to "Text does not equal any value that starts with A".
\null can be escaped to match "null" as a string vs value.
If the value starts and ends with a regex-like string, pass it through: "/regex/i". Any reserved character here can be used if it is escaped first with an escape character "".
Date/Time Data Types
Date/Time filter statements are similar to filter statements for numeric data types. Date values that can be used in the filter statement include the year, month, and day. Time values can also be used in conjunction with date values, including hour and minute, and optionally seconds and nanoseconds (e.g., 2018-01-25 09:25).
Magic words such as "now", "today", "yesterday" can also be used. When "now" is used, the values include the timestamp down to the millisecond using the appropriate time zone.
Symbol
Meaning
Example
>
Greater than (after)
>2018-01-25
>yesterday
>=
Greater than or equal to
>=2018
>=today
<
Less than (before)
<2018-01-25
<tomorrow
<=
Less than or equal to
<=2018
<=tomorrow
= (or empty)
Equal to
=2018-01-25
2018-01
=yesterday
today
!=
Not equal to
!=2018-01-25
!today
null
No value
null
!null
Not null (has a value)
!null
Boolean Data Types
Boolean filtering statements work on columns displayed as "true" or "false".
To filter boolean columns, you can use any derivation of the words true or false, and in any letter case. For example, the "true" value could be filtered using true, T, True, t, tru, tRUe, TRUE, etc.
The binary 0 or 1 could also be used to filter for true or false respectively.
"Null" (also case insensitive) can also be used to filter for empty values in columns containing boolean values.