1. Home
  2. Reports
  3. Query Sorting

Query Sorting

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”

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)


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

>= 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.


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”

9. Wildcard


Wildcard for zero or more non-space characters.


matches “Black” and “Book”


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”

11. text

Any text entered in the filter will match text found within the column


finds “Aaron” and “Philip Aaron Wong”

Updated on January 2, 2018

Was this article helpful?