Quick Filters
Access Quick Filters by right-clicking on a column header in a table and selecting "Quick Filters" from the drop-down menu:
Now you can type filter statements into the Quick Filter field to filter columns:
The filter statement options for each column are dependent on the column's data type. The following sections provide a list of filter statement options for each data type.
Quick Filter Statement Options
Number Data Types
| Symbol | Meaning | Example(s) |
|---|---|---|
| = (or nothing) | Equal to |
|
| != | Not equal to |
|
| > | Greater than | >50 |
| >= | Greater than or equal to | >=50 |
| < | Less than | <50 |
| <= | Less than or equal to | <=50 |
| && | Greater than X and less than Y | >10 && <50 |
| || | Or | NYSE || Nasdaq |
| null | No value | null |
Note
You can combine multiple filtering statements in one Quick Filter field.
String Data Types
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 |
|
| != | Text does not equal |
|
* | Wildcard. Follows *. Java regex; zero or more letters. |
|
| ~ | Text contains | ~sp |
| !~ | Text does not contain | !~sp |
| null | Text field is empty (no value) |
|
| !null | Text field is not empty |
|
Note
- You can combine filtering statements. For example,
!=A*is 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. You can also use time values in conjunction with date values, including hour and minute, and optionally seconds and nanoseconds (e.g., 2018-01-25 09:25).
You can also use magic words such as "now", "today", and "yesterday". When "now" is used, the values include the timestamp down to the millisecond using the appropriate time zone.
| Symbol | Meaning | Example |
|---|---|---|
| > | Greater than (after) |
|
| >= | Greater than or equal to |
|
| < | Less than (before) |
|
| <= | Less than or equal to |
|
| = (or empty) | Equal to |
|
| != | Not equal to |
|
| 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, you can filter the "true" value using true, T, True, t, tru, tRUe, TRUE, etc.
- You can also use the binary values 0 (true) or 1 (false) to filter boolean columns.
- Use "Null" (also case insensitive) to filter for empty values in boolean columns.