Strings
How to use filter operators for facets containing values of string datatype.
If a particular table column is of the string datatype, clicking on the search input within that filter facet will display the list of available operators:
has - the column values contain a particular "substring" occurring anywhere in the value.
regex - the column values match a particular regular expression pattern.
not - the column values are not a particular "substring".
empty - the column values are empty.
not empty - the column values are not empty.
Has / Contains
Step 1: Click the search input and then click the "has" operator button.
Step 2: Type a few characters or choose one of the options from the autocomplete box.
Step 3: Click "Apply"
Step 4: Filter will be applied in the sidebar. Click "x" to clear the filter.
Regular Expressions (regex)
Step 1: Click the search input and then click the "regex" operator button.
Step 4: Filter will be applied in the sidebar. Click "x" to clear the filter.
Regular Expression Examples
Filtering using regex operator evaluates the regular expression pattern and determines if it is matched within a string.
The pattern only needs to match part of the string, rather than matching all of string. You can match the entire string by anchoring the pattern using ^ and $.
| Pattern | Description |
|---|---|
ID-.*open | Matches string containing ID- followed by anything which contains open string. |
ID-[0-9]+ | Matches string containing ID- followed by one or more numbers. |
open|closed | Matches string containing open or closed string. |
ID-.*(open|closed) | Matches string containing ID- followed by anything which contains open or closed string. |
^sample | Matches string which starts with sample string. |
.fa$ | Matches string which ends with .fa string. |
Not
Step 1: Click the search input and then click the "not" operator button.
Step 2: Type a few characters and select an option from the autocomplete box.
Step 3: Click "Apply"
Step 4: Filter will be applied in the sidebar. Click "x" to clear the filter.
Empty / Not Empty
Step 1: Click the search input and then click the "Empty" or "Not Empty" operator button.
Last updated
