| 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 | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Alain Vigneault | Panthers | 72 | 96 | 79 | 66 | 93 | 74 | 55 | CAN | 51 | 3 | 3,500,000$ |
| Barry Trotz | Stars | 69 | 83 | 75 | 86 | 83 | 80 | 56 | CAN | 50 | 2 | 1,150,000$ |
| Bruce Boudreau | Blue Jackets | 80 | 68 | 89 | 76 | 49 | 71 | 49 | CAN | 57 | 1 | 1,000,000$ |
| Dave Tippett | Devils | 83 | 81 | 74 | 80 | 71 | 73 | 55 | CAN | 51 | 2 | 2,000,000$ |
| Guy Boucher | Golden Knights | 73 | 78 | 72 | 78 | 38 | 78 | 65 | CAN | 41 | 3 | 2,000,000$ |
| Guy Carbonneau | Senateurs | 75 | 91 | 58 | 89 | 43 | 77 | 54 | CAN | 51 | 1 | 650,000$ |
| Jacques Lemaire | Capitals | 69 | 92 | 80 | 76 | 99 | 99 | 39 | Can | 66 | 3 | 900,000$ |
| Jacques Martin | Islanders | 79 | 85 | 97 | 76 | 99 | 99 | 46 | CAN | 60 | 2 | 4,000,000$ |
| Joel Quenneville | Maple Leafs | 78 | 73 | 74 | 78 | 90 | 82 | 52 | CAN | 54 | 1 | 800,000$ |
| John Tortorella | Lightning | 91 | 58 | 90 | 63 | 79 | 59 | 52 | Can | 53 | 3 | 1,500,000$ |
| Jon Cooper | Blackhawks | 69 | 66 | 68 | 69 | 35 | 55 | 79 | Can | 47 | 4 | 1,500,000$ |
| Ken Hitchcock | Kings | 66 | 78 | 72 | 87 | 99 | 70 | 45 | CAN | 61 | 2 | 2,000,000$ |
| Lindy Ruff | Flames | 87 | 64 | 75 | 78 | 88 | 88 | 54 | CAN | 52 | 2 | 2,000,000$ |
| Marc Crawford | Bruins | 74 | 71 | 92 | 70 | 81 | 72 | 55 | CAN | 51 | 1 | 750,000$ |
| Michel Therrien | Rangers | 81 | 73 | 81 | 76 | 72 | 74 | 57 | CAN | 49 | 1 | 1,500,000$ |
| Mike Babcock | Canadiens | 75 | 83 | 81 | 78 | 77 | 77 | 57 | Can | 51 | 4 | 2,000,000$ |
| Mike Keenan | Avalanche | 86 | 74 | 84 | 71 | 99 | 73 | 43 | CAN | 63 | 2 | 600,000$ |
| Pat Burns | Penguins | 79 | 89 | 88 | 76 | 99 | 99 | 46 | CAN | 60 | 2 | 2,000,000$ |
| Pat Quinn | Flyers | 82 | 83 | 87 | 73 | 99 | 88 | 37 | CAN | 69 | 1 | 2,500,000$ |
| Patrick Roy | Sharks | 79 | 85 | 67 | 58 | 37 | 80 | 59 | Can | 50 | 3 | 900,000$ |
| Paul Kariya | Blues | 62 | 77 | 79 | 82 | 55 | 70 | 67 | CAN | 39 | 2 | 650,000$ |
| Peter Laviolette | Canucks | 83 | 88 | 82 | 77 | 69 | 86 | 58 | USA | 48 | 1 | 3,100,000$ |
| Randy Carlyle | Predators | 87 | 77 | 83 | 67 | 62 | 87 | 50 | CAN | 56 | 1 | 2,000,000$ |
| Ted Nolan | Jets | 78 | 80 | 77 | 80 | 76 | 56 | 52 | CAN | 54 | 3 | 2,200,000$ |
| Terry Murray | Red Wings | 70 | 74 | 86 | 93 | 95 | 85 | 44 | CAN | 62 | 2 | 2,200,000$ |
| Todd McLellan | Oilers | 66 | 62 | 78 | 79 | 43 | 69 | 57 | CAN | 49 | 2 | 500,000$ |
| 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 | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Adams Oates |  Moose | 53 | 56 | 85 | 72 | 37 | 59 | 54 | CAN | 52 | 2 | 950,000$ |
| Alex Kovalev |  Penguins | 66 | 64 | 69 | 70 | 40 | 42 | 58 | RUS | 46 | 4 | 500,000$ |
| Claude Julien |  Little Stars | 82 | 83 | 74 | 74 | 59 | 61 | 55 | CAN | 52 | 1 | 1,000,000$ |
| Claude Noël |  Punishers | 69 | 65 | 65 | 70 | 41 | 51 | 49 | Can | 56 | 2 | 300,000$ |
| Craig MacTavish |  Reign | 78 | 75 | 69 | 75 | 76 | 67 | 52 | CAN | 54 | 1 | 750,000$ |
| Dale Hunter |  Barracuda | 77 | 81 | 66 | 64 | 43 | 68 | 54 | Can | 65 | 3 | 650,000$ |
| Dan Bylsma |  Heat | 77 | 70 | 68 | 70 | 49 | 50 | 64 | USA | 42 | 1 | 800,000$ |
| Dave Semenko |  Condors | 73 | 79 | 66 | 71 | 91 | 63 | 53 | CAN | 53 | 1 | 500,000$ |
| Denis Savard |  Crunch | 60 | 52 | 95 | 76 | 60 | 65 | 55 | Can | 62 | 3 | 500,000$ |
| Doug Gilmour |  Icehogs | 67 | 66 | 80 | 70 | 37 | 80 | 57 | CAN | 49 | 2 | 700,000$ |
| Gerard Gallant |  Bears | 65 | 66 | 64 | 72 | 38 | 65 | 57 | CAN | 1 | 3 | 550,000$ |
| Jack Capuano |  Wolfpack | 63 | 70 | 61 | 56 | 47 | 44 | 58 | USA | 48 | 3 | 350,000$ |
| Joël Bouchard |  Eagles | 80 | 75 | 63 | 79 | 61 | 63 | 50 | CAN | 56 | 2 | 600,000$ |
| Kevin Dineen |  Phantoms | 73 | 65 | 66 | 79 | 32 | 72 | 57 | Can | 48 | 5 | 500,000$ |
| Kirk Muller |  Griffins | 79 | 74 | 72 | 83 | 34 | 67 | 60 | CAN | 46 | 2 | 850,000$ |
| Lanne MacDonald |  Comets | 75 | 58 | 63 | 70 | 34 | 62 | 37 | USA | 70 | 2 | 325,000$ |
| Larry Robinson |  Devils | 77 | 93 | 56 | 82 | 99 | 83 | 45 | Can | 74 | 2 | 750,000$ |
| Mario Lemieux |  Senators | 58 | 69 | 72 | 72 | 51 | 55 | 55 | CAN | 52 | 2 | 1,000,000$ |
| Paul Maurice |  Sound Tigers | 73 | 94 | 61 | 68 | 78 | 82 | 61 | Can | 49 | 1 | 250,000$ |
| Pavel Bure |  Thunderbirds | 54 | 60 | 76 | 66 | 33 | 45 | 63 | RUS | 46 | 4 | 800,000$ |
| Peter DeBoer |  Marlies | 67 | 71 | 73 | 86 | 54 | 63 | 62 | Can | 55 | 4 | 666,000$ |
| Rick Tocchet |  Rocket | 71 | 64 | 73 | 69 | 34 | 49 | 58 | USA | 41 | 3 | 500,000$ |
| Ron Wilson |  Wolves | 83 | 81 | 64 | 66 | 55 | 71 | 49 | USA | 57 | 1 | 500,000$ |
| Teemu Selanne |  Rampage | 77 | 69 | 73 | 90 | 87 | 74 | 45 | Fin | 39 | 3 | 650,000$ |
| Tony Twist |  Monsters | 76 | 56 | 69 | 70 | 33 | 56 | 63 | USA | 52 | 4 | 550,000$ |
| Wayne Gretzky |  Admirals | 70 | 62 | 82 | 91 | 52 | 68 | 55 | Can | 63 | 1 | 1,000,000$ |
| 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 | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|
| André Tourigny | 75 | 58 | 63 | 70 | 34 | 62 | 47 | Can | 59 | 1 | 250,000$ |
| Brent Sutter | 90 | 64 | 69 | 87 | 40 | 59 | 56 | Can | 49 | 1 | 250,000$ |
| Dominique Ducharme | 69 | 60 | 69 | 75 | 38 | 65 | 55 | Can | 42 | 1 | 250,000$ |
| Joe Sacco | 61 | 66 | 65 | 62 | 31 | 55 | 63 | USA | 42 | 1 | 250,000$ |
| John Anderson | 67 | 73 | 66 | 66 | 45 | 85 | 51 | Can | 54 | 1 | 250,000$ |
| Mario Tremblay | 68 | 75 | 64 | 67 | 47 | 57 | 50 | Can | 55 | 1 | 250,000$ |
| Mike Yeo | 61 | 64 | 68 | 67 | 35 | 37 | 66 | CAN | 40 | 2 | 1,000,000$ |
| Tony Granato | 69 | 61 | 65 | 82 | 49 | 59 | 58 | USA | 47 | 1 | 250,000$ |