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