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.

Screenshot 2022-11-14 at 11.39.32 AM.png

Has / Contains

• Step 1: Click the search input and then click the "has" operator button.

Screenshot 2022-11-16 at 1.59.49 PM.png

• Step 2: Type a few characters or choose one of the options from the autocomplete box.

Screenshot 2022-11-14 at 11.40.01 AM.png

• Step 3: Click "Apply"

Screenshot 2022-11-16 at 1.47.40 PM.png

• Step 4: Filter will be applied in the sidebar. Click "x" to clear the filter.

Screenshot 2022-11-16 at 1.47.15 PM.png

Regular Expressions (regex)

• Step 1: Click the search input and then click the "regex" operator button.

Screenshot 2022-11-16 at 1.59.49 PM.png

Screenshot 2022-11-14 at 11.44.18 AM.png

• Step 4: Filter will be applied in the sidebar. Click "x" to clear the filter.

Screenshot 2022-11-14 at 11.43.42 AM.png

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.

Screenshot 2022-11-16 at 1.59.49 PM.png

• Step 2: Type a few characters and select an option from the autocomplete box.

Screenshot 2022-11-16 at 2.22.53 PM.png

• Step 3: Click "Apply"

Screenshot 2022-11-16 at 2.22.22 PM.png

• Step 4: Filter will be applied in the sidebar. Click "x" to clear the filter.

image 1.jpg

Empty / Not Empty

• Step 1: Click the search input and then click the "Empty" or "Not Empty" operator button.

Screenshot 2022-11-16 at 1.59.49 PM.png

Screenshot 2022-11-16 at 1.59.49 PM.png

• Step 2: Filter will be applied in the sidebar. Click "x" to clear the filter.