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