{"id":911,"date":"2018-01-02T17:31:47","date_gmt":"2018-01-02T17:31:47","guid":{"rendered":"http:\/\/kb.powercode.com\/?post_type=ht_kb&p=911"},"modified":"2018-01-02T17:31:47","modified_gmt":"2018-01-02T17:31:47","slug":"query-sorting","status":"publish","type":"ht_kb","link":"https:\/\/kb.powercode.com\/?ht_kb=query-sorting","title":{"rendered":"Query Sorting"},"content":{"rendered":"

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<\/p>\n

1. Logical “or” (Vertical bar)<\/h3>\n
| or  OR<\/pre>\n
Filter the column for content that matches text from either side of the bar.<\/p>\n
example:<\/p>\n
box|bat<\/pre>\n
matches a column cell with either “box” or “bat”<\/p>\n
2. Logical “and”<\/h3>\n
 &&  or  AND<\/pre>\n
Filter the column for content that matches text from either side of the operator.<\/p>\n
box && bat<\/pre>\n
matches a column cell that contains both “box” and “bat”<\/p>\n
3. Regex<\/h3>\n
\/\\d\/     (or any regex)<\/pre>\n
Add any regex to the query to use in the query (“mig” flags can be included ie. \/\\w\/mig)<\/p>\n
\/b[aeiou]g\/i<\/pre>\n
finds “bag”, “beg”, “BIG”, “Bug”, etc<\/p>\n
\/r$\/<\/pre>\n
matches text that ends with an “r”<\/p>\n
4. Greater than\/Less Than<\/h3>\n
< <= >= ><\/pre>\n
Find alphabetical or numerical values less than or greater than or equal to the filtered query<\/p>\n
>= 10<\/pre>\n
find values greater than or equal to 10<\/p>\n
5. Not Operator<\/h3>\n
! or !=<\/pre>\n
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.<\/p>\n
!fe<\/pre>\n
hide rows with “female” in that column, but shows rows with “male”<\/p>\n
6. Equals Operator<\/h3>\n
\" or =<\/pre>\n
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and\/or end of the query<\/p>\n
abc\" or abc=<\/pre>\n
exactly match “abc”<\/p>\n
7. Find a range of values.<\/h3>\n
-  or  to<\/pre>\n
Make sure there is a space before and after the dash (or the word “to”<\/p>\n
10 - 30 or 10 to 30<\/pre>\n
match values between 10 and 30<\/p>\n
8. Single Character Wildcard<\/h3>\n
?<\/pre>\n
Wildcard for a single, non-space character.<\/p>\n
J?n<\/pre>\n
finds “Jan” and “Jun”, but not “Joan”<\/p>\n
9. Wildcard<\/h3>\n
*<\/pre>\n
Wildcard for zero or more non-space characters.<\/p>\n
B*k<\/pre>\n
matches “Black” and “Book”<\/p>\n
10. Fuzzy Search<\/h3>\n
~<\/pre>\n
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query.<\/p>\n
~bee<\/pre>\n
matches “Bruce Lee” and “Brenda Dexter”<\/p>\n
~piano<\/pre>\n
matches “Philip Aaron Wong”<\/p>\n
11. text<\/h3>\n
Any text entered in the filter will match text found within the column<\/p>\n
aaron<\/pre>\n
finds “Aaron” and “Philip Aaron Wong”<\/p>\n","protected":false},"excerpt":{"rendered":"
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…<\/p>\n","protected":false},"author":4,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[5],"ht-kb-tag":[],"_links":{"self":[{"href":"https:\/\/kb.powercode.com\/index.php?rest_route=\/wp\/v2\/ht-kb\/911"}],"collection":[{"href":"https:\/\/kb.powercode.com\/index.php?rest_route=\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/kb.powercode.com\/index.php?rest_route=\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/kb.powercode.com\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.powercode.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=911"}],"version-history":[{"count":1,"href":"https:\/\/kb.powercode.com\/index.php?rest_route=\/wp\/v2\/ht-kb\/911\/revisions"}],"predecessor-version":[{"id":912,"href":"https:\/\/kb.powercode.com\/index.php?rest_route=\/wp\/v2\/ht-kb\/911\/revisions\/912"}],"wp:attachment":[{"href":"https:\/\/kb.powercode.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=911"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/kb.powercode.com\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-category&post=911"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/kb.powercode.com\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-tag&post=911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}