The text fields at the top of a query allow filtering the below results. The filter function priority breakdown below allows creation of more complicated filters and troubleshooting when a filter does not behave as expected. The filter order of how searches are checked in the following order; so an exact match will override “range” searches
1. Logical “or” (Vertical bar)
| or OR
Filter the column for content that matches text from either side of the bar.
matches a column cell with either “box” or “bat”
2. Logical “and”
&& or AND
Filter the column for content that matches text from either side of the operator.
box && bat
matches a column cell that contains both “box” and “bat”
/\d/ (or any regex)
Add any regex to the query to use in the query (“mig” flags can be included ie. /\w/mig)
finds “bag”, “beg”, “BIG”, “Bug”, etc
matches text that ends with an “r”
4. Greater than/Less Than
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
find values greater than or equal to 10
5. Not Operator
! or !=
Not operator, or exactly not match. Filter the column with content that does not match the query. Include an equal (=), single (‘) or double quote (“) to require exact match.
hide rows with “female” in that column, but shows rows with “male”
6. Equals Operator
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
abc" or abc=
exactly match “abc”
7. Find a range of values.
- or to
Make sure there is a space before and after the dash (or the word “to”
10 - 30 or 10 to 30
match values between 10 and 30
8. Single Character Wildcard
Wildcard for a single, non-space character.
finds “Jan” and “Jun”, but not “Joan”
Wildcard for zero or more non-space characters.
matches “Black” and “Book”
10. Fuzzy Search
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query.
matches “Bruce Lee” and “Brenda Dexter”
matches “Philip Aaron Wong”
Any text entered in the filter will match text found within the column
finds “Aaron” and “Philip Aaron Wong”