| Priority | Type | Description |
|---|---|---|
| 1 | | or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar |
| 2 | && or AND | Logical "and". Filter the column for content that matches text from either side of the operator. |
| 3 | /\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig) |
| 4 | < <= >= > | Find alphabetical or numerical values less than or greater than or equal to the filtered query |
| 5 | ! or != | Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter. |
| 6 | " or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query |
| 7 | - or to | Find a range of values. Make sure there is a space before and after the dash (or the word "to") |
| 8 | ? | Wildcard for a single, non-space character. |
| 8 | * | Wildcard for zero or more non-space characters. |
| 9 | ~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query |
| 10 | text | Any text entered in the filter will match text found within the column |
| Coaches Name | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Contrat Signature Date | Salary |
|---|
| Priority | Type | Description |
|---|---|---|
| 1 | | or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar |
| 2 | && or AND | Logical "and". Filter the column for content that matches text from either side of the operator. |
| 3 | /\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig) |
| 4 | < <= >= > | Find alphabetical or numerical values less than or greater than or equal to the filtered query |
| 5 | ! or != | Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter. |
| 6 | " or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query |
| 7 | - or to | Find a range of values. Make sure there is a space before and after the dash (or the word "to") |
| 8 | ? | Wildcard for a single, non-space character. |
| 8 | * | Wildcard for zero or more non-space characters. |
| 9 | ~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query |
| 10 | text | Any text entered in the filter will match text found within the column |
| Coaches Name | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Contrat Signature Date | Salary |
|---|
| Priority | Type | Description |
|---|---|---|
| 1 | | or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar |
| 2 | && or AND | Logical "and". Filter the column for content that matches text from either side of the operator. |
| 3 | /\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig) |
| 4 | < <= >= > | Find alphabetical or numerical values less than or greater than or equal to the filtered query |
| 5 | ! or != | Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter. |
| 6 | " or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query |
| 7 | - or to | Find a range of values. Make sure there is a space before and after the dash (or the word "to") |
| 8 | ? | Wildcard for a single, non-space character. |
| 8 | * | Wildcard for zero or more non-space characters. |
| 9 | ~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query |
| 10 | text | Any text entered in the filter will match text found within the column |
| Coaches Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Contrat Signature Date | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Alek Valcourt | 95 | 76 | 89 | 71 | 90 | 88 | 74 | CAN | 52 | 3 | 4,236,328$ | |
| Conway Blankley | 66 | 73 | 78 | 95 | 56 | 93 | 88 | USA | 50 | 4 | 1,627,277$ | |
| Darcey Batchelor | 95 | 65 | 80 | 96 | 97 | 67 | 76 | USA | 36 | 3 | 3,951,494$ | |
| Dave Cohen | 87 | 77 | 90 | 74 | 93 | 87 | 85 | CAN | 42 | 4 | 3,193,408$ | |
| David Grove | 68 | 72 | 94 | 75 | 59 | 70 | 95 | CAN | 42 | 4 | 2,314,868$ | |
| Denny Talbot | 74 | 86 | 71 | 67 | 99 | 90 | 68 | CAN | 63 | 4 | 3,655,109$ | |
| Douglas Nickens | 79 | 92 | 89 | 67 | 92 | 95 | 87 | CAN | 41 | 3 | 3,598,301$ | |
| Erwin Minnis | 69 | 73 | 86 | 97 | 64 | 72 | 60 | USA | 50 | 3 | 1,686,411$ | |
| Gerry Vans | 89 | 99 | 77 | 79 | 58 | 92 | 81 | USA | 39 | 4 | 2,213,584$ | |
| Jeffry Hoover | 89 | 74 | 82 | 65 | 93 | 73 | 81 | USA | 36 | 4 | 4,242,709$ | |
| Jett Pyatt | 96 | 75 | 67 | 84 | 99 | 90 | 78 | CAN | 56 | 4 | 3,531,477$ | |
| Jim Fons | 82 | 92 | 97 | 83 | 83 | 73 | 67 | USA | 62 | 3 | 3,324,486$ | |
| Kevin Lali | 76 | 94 | 95 | 97 | 50 | 99 | 96 | CAN | 47 | 4 | 2,331,315$ | |
| Kyler Polacek | 72 | 92 | 96 | 66 | 50 | 95 | 97 | USA | 45 | 3 | 2,302,470$ | |
| Marv Pieper | 65 | 66 | 69 | 77 | 90 | 81 | 62 | USA | 52 | 4 | 4,035,835$ | |
| Matthieu Sloman | 77 | 99 | 84 | 98 | 74 | 87 | 74 | CAN | 47 | 3 | 1,882,542$ | |
| Nathaniel Malcom | 67 | 81 | 65 | 99 | 76 | 69 | 80 | USA | 42 | 4 | 4,428,576$ | |
| Nicolas Owens | 89 | 93 | 88 | 73 | 94 | 66 | 70 | USA | 52 | 4 | 4,013,652$ | |
| Owen Hung | 92 | 78 | 93 | 93 | 96 | 66 | 77 | CAN | 48 | 4 | 3,734,040$ | |
| Peter Corum | 95 | 89 | 73 | 95 | 70 | 77 | 93 | CAN | 41 | 3 | 2,229,993$ | |
| Robby Karpowich | 70 | 90 | 78 | 90 | 92 | 99 | 86 | USA | 40 | 4 | 3,369,216$ | |
| Shawn Giannangelo | 66 | 79 | 68 | 69 | 60 | 70 | 84 | CAN | 35 | 4 | 2,229,279$ | |
| Simon-Claude Garand | 68 | 90 | 88 | 83 | 65 | 74 | 95 | CAN | 54 | 4 | 2,429,544$ | |
| Skip Giles | 74 | 86 | 82 | 73 | 87 | 68 | 67 | USA | 59 | 3 | 3,202,486$ | |
| Steven Critchlow | 86 | 97 | 94 | 83 | 62 | 67 | 86 | USA | 48 | 3 | 1,933,817$ | |
| Travis Hayden | 71 | 78 | 84 | 86 | 96 | 75 | 81 | USA | 65 | 4 | 3,430,851$ | |
| Trent Beljo | 65 | 66 | 97 | 83 | 60 | 86 | 76 | CAN | 65 | 3 | 2,341,115$ | |
| Ty Bogart | 90 | 85 | 80 | 84 | 91 | 94 | 63 | CAN | 47 | 3 | 3,891,745$ | |
| Wilson Troy | 85 | 92 | 68 | 76 | 96 | 81 | 70 | USA | 57 | 4 | 4,187,818$ | |
| Zachery McCallister | 77 | 89 | 73 | 95 | 56 | 71 | 75 | CAN | 48 | 3 | 1,925,243$ |