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.
example:
box|bat
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”
3. Regex
/\d/ (or any regex)
Add any regex to the query to use in the query (“mig” flags can be included ie. /\w/mig)
/b[aeiou]g/i
finds “bag”, “beg”, “BIG”, “Bug”, etc
/r$/
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
>= 10
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.
!fe
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.
J?n
finds “Jan” and “Jun”, but not “Joan”
9. Wildcard
*
Wildcard for zero or more non-space characters.
B*k
matches “Black” and “Book”
10. Fuzzy Search
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query.
~bee
matches “Bruce Lee” and “Brenda Dexter”
~piano
matches “Philip Aaron Wong”
11. text
Any text entered in the filter will match text found within the column
aaron
finds “Aaron” and “Philip Aaron Wong”