| 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 | COQUITLAM KNIGHTS | 95 | 68 | 96 | 85 | 99 | 99 | 52 | CAN | 58 | 1 | 1,773,200$ |
| Andy Murray | DETROIT RED WINGS | 68 | 80 | 84 | 85 | 99 | 99 | 25 | CAN | 68 | 3 | 1,554,300$ |
| Barry Trotz | CHICAGO CRUSHERS | 93 | 95 | 99 | 89 | 99 | 99 | 45 | CAN | 56 | 3 | 1,975,000$ |
| Bill Barber | PENSACOLA BADGERS | 92 | 72 | 82 | 81 | 99 | 99 | 50 | USA | 67 | 2 | 823,000$ |
| Brad Shaw | COLORADO WOLVES | 79 | 93 | 78 | 64 | 99 | 99 | 50 | CAN | 55 | 4 | 870,000$ |
| Cory Clouston | BROOKLYN BLAZERS | 70 | 94 | 92 | 80 | 94 | 98 | 51 | CAN | 49 | 5 | 1,100,000$ |
| Doug Risebrough | PHILADELPHIA MADMEN | 76 | 84 | 92 | 91 | 99 | 99 | 38 | CAN | 66 | 3 | 1,846,000$ |
| Jacques Martin | HALIFAX HIGHLANDERS | 99 | 94 | 97 | 99 | 99 | 99 | 39 | CAN | 66 | 1 | 1,000,000$ |
| Joe Sacco | NORTH VAN ROCKERS | 99 | 90 | 99 | 89 | 99 | 99 | 35 | USA | 50 | 2 | 1,160,000$ |
| Joel Quenneville | CALGARY COWBOYS | 78 | 94 | 78 | 73 | 91 | 91 | 59 | CAN | 60 | 2 | 1,409,000$ |
| John Stevens | CAPE FEAR PROWLERS | 87 | 85 | 94 | 82 | 99 | 96 | 22 | CAN | 53 | 1 | 800,000$ |
| John Tortorella | VANCOUVER MILLIONAIRES | 84 | 87 | 76 | 86 | 99 | 99 | 57 | USA | 60 | 1 | 1,760,000$ |
| Ken Hitchcock | LAS CRUCES SPURS | 88 | 81 | 92 | 94 | 99 | 99 | 40 | CAN | 67 | 3 | 1,100,000$ |
| Martin Skoula | HAWAII TYPHOON | 77 | 82 | 82 | 84 | 91 | 91 | 59 | CZE | 43 | 2 | 1,000,000$ |
| Mike Bossy | MANHATTAN ISLANDERS | 76 | 87 | 99 | 76 | 99 | 99 | 42 | CAN | 63 | 3 | 1,808,000$ |
| Mike Haviland | SYRACUSE BULLDOGS | 84 | 85 | 75 | 85 | 91 | 91 | 59 | USA | 52 | 3 | 784,000$ |
| Peter Laviolette | SAN JOSE BLASPHEMERS | 91 | 70 | 78 | 79 | 99 | 99 | 11 | USA | 54 | 1 | 1,000,000$ |
| Rod Brind'Amour | PINCHER CREEK PREDATORS | 70 | 76 | 75 | 80 | 89 | 89 | 61 | CAN | 47 | 2 | 1,009,000$ |
| Sergei Federov | EDMONTON BUSCHWACKERS | 78 | 62 | 79 | 83 | 88 | 88 | 62 | RUS | 50 | 3 | 1,124,000$ |
| Todd McLellan | BANGOR BEAGLES | 93 | 99 | 88 | 89 | 99 | 99 | 32 | CAN | 51 | 3 | 1,100,000$ |
| Trevor Linden | NEWTON NIGHTMARES | 76 | 81 | 79 | 84 | 94 | 94 | 56 | CAN | 49 | 1 | 1,550,000$ |
| Ulf Samuelsson | CAPE BRETON CELTS | 90 | 77 | 99 | 71 | 99 | 99 | 51 | SWE | 55 | 1 | 3,308,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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Alex Tanguay |  MANHATTAN SWEDES | 71 | 65 | 79 | 78 | 80 | 80 | 65 | CAN | 43 | 3 | 1,200,000$ |
| Andy Rogers |  HAWAII PUNCH | 51 | 77 | 75 | 72 | 51 | 76 | 69 | CAN | 37 | 2 | 800,000$ |
| Brent Sutter |  PHILADELPHIA PHANTOMS | 75 | 75 | 85 | 87 | 85 | 80 | 67 | CAN | 57 | 2 | 1,411,000$ |
| Brian Sutter |  COQUITLAM EXPRESS | 81 | 99 | 81 | 88 | 99 | 99 | 46 | CAN | 63 | 2 | 829,400$ |
| Curtis Hunt |  CAPE FEAR WILDCATS | 81 | 80 | 90 | 76 | 99 | 99 | 51 | USA | 52 | 3 | 1,300,000$ |
| Darryl Sutter |  BROOKLYN GRINDERS | 79 | 78 | 76 | 91 | 99 | 99 | 51 | CAN | 59 | 2 | 1,132,000$ |
| Duane Sutter |  EDMONTON OILERS | 85 | 70 | 94 | 84 | 99 | 99 | 50 | CAN | 59 | 3 | 1,302,000$ |
| Greg Ireland |  BANGOR PUPPIES | 78 | 78 | 94 | 76 | 99 | 99 | 50 | CAN | 53 | 3 | 1,176,000$ |
| Hayley Wickenheiser |  NEWTON NIGHTHAWKS | 56 | 79 | 87 | 80 | 93 | 93 | 57 | CAN | 45 | 1 | 1,150,000$ |
| Jeremy Roenick |  LAS CRUCES MESCALEROS | 72 | 90 | 87 | 84 | 77 | 87 | 53 | USA | 52 | 2 | 1,595,000$ |
| Jim Playfair |  CAPE BRETON LEPRECHAUNS | 90 | 81 | 96 | 79 | 93 | 93 | 57 | CAN | 55 | 1 | 2,157,000$ |
| Joe Pavelski |  PENSACOLA BLACK BEARS | 66 | 78 | 71 | 74 | 77 | 77 | 73 | USA | 39 | 2 | 900,000$ |
| Kevin Lowe |  VANCOUVER THOUSANDAIRES | 87 | 75 | 80 | 68 | 99 | 99 | 40 | CAN | 60 | 1 | 870,000$ |
| Lindy Ruff |  DETROIT STEELERS | 72 | 94 | 64 | 80 | 99 | 99 | 51 | CAN | 59 | 3 | 1,001,000$ |
| Mark Giordano |  SAN JOSE AVACADOES | 70 | 79 | 78 | 77 | 79 | 79 | 71 | CAN | 40 | 1 | 900,000$ |
| Marty St Louis |  SYRACUSE BABY BULLS | 76 | 90 | 95 | 87 | 97 | 97 | 53 | CAN | 47 | 3 | 1,200,000$ |
| Mike Babcock |  NORTH VAN ROCKERS | 78 | 91 | 91 | 78 | 99 | 99 | 51 | CAN | 56 | 4 | 1,747,000$ |
| Paul Maurice |  CHICAGO UNDERTAKERS | 77 | 80 | 68 | 73 | 99 | 99 | 1 | CAN | 52 | 3 | 1,000,000$ |
| Randy Carlyle |  PINCHER CREEK WOLVERINES | 88 | 85 | 99 | 74 | 98 | 98 | 52 | CAN | 63 | 1 | 1,561,000$ |
| Ron Wilson |  COLORADO CUBS | 99 | 95 | 85 | 90 | 99 | 99 | 43 | CAN | 64 | 1 | 1,000,000$ |
| Vincent Lecavalier |  HALIFAX HELL | 77 | 77 | 74 | 69 | 77 | 72 | 68 | CAN | 43 | 2 | 800,000$ |
| Wayne Gretzky |  CALGARY WRANGLERS | 84 | 80 | 75 | 84 | 99 | 99 | 49 | CAN | 58 | 1 | 1,419,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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Alexei Morozov | 70 | 70 | 80 | 70 | 75 | 70 | 80 | RUS | 46 | 3 | 1,100,000$ |
| Bill Stewart | 74 | 74 | 95 | 78 | 99 | 99 | 41 | USA | 62 | 1 | 1,249,400$ |
| Bob Boughner | 80 | 70 | 70 | 65 | 75 | 70 | 70 | CAN | 52 | 2 | 875,000$ |
| Brent Johnson | 52 | 83 | 63 | 81 | 72 | 72 | 68 | USA | 46 | 0 | 780,000$ |
| Bruce Cassidy | 70 | 75 | 70 | 65 | 65 | 70 | 70 | CAN | 58 | 3 | 1,000,000$ |
| Charlie Huddy | 56 | 63 | 66 | 64 | 74 | 64 | 37 | CAN | 60 | 4 | 1,230,000$ |
| Chris Phillips | 70 | 80 | 70 | 70 | 60 | 70 | 70 | USA | 44 | 2 | 800,000$ |
| Claude Noel | 73 | 66 | 74 | 74 | 99 | 95 | 44 | CAN | 63 | 1 | 1,117,500$ |
| Corey Hirsch | 77 | 79 | 69 | 77 | 76 | 76 | 74 | CAN | 47 | 2 | 1,229,000$ |
| Craig MacTavish | 56 | 63 | 62 | 62 | 60 | 58 | 35 | CAN | 60 | 4 | 1,457,000$ |
| Dan Bylsma | 75 | 69 | 71 | 81 | 77 | 77 | 73 | USA | 49 | 0 | 1,661,000$ |
| Dan Cleary | 60 | 75 | 65 | 65 | 75 | 70 | 70 | CAN | 44 | 1 | 750,000$ |
| Daniel Alfredsson | 58 | 75 | 78 | 72 | 79 | 79 | 66 | SWE | 50 | 1 | 1,200,000$ |
| Dave Barr | 62 | 65 | 69 | 69 | 61 | 55 | 39 | CAN | 58 | 2 | 900,000$ |
| Dave Hakstol | 75 | 70 | 70 | 65 | 65 | 65 | 70 | CAN | 55 | 2 | 925,000$ |
| Dave Tippett | 66 | 75 | 87 | 73 | 90 | 90 | 60 | CAN | 57 | 1 | 1,742,400$ |
| David Legwand | 70 | 80 | 70 | 70 | 70 | 70 | 80 | USA | 43 | 2 | 970,000$ |
| Davis Payne | 80 | 79 | 73 | 70 | 68 | 64 | 76 | CAN | 48 | 2 | 525,000$ |
| Dean Chynoweth | 55 | 62 | 61 | 64 | 57 | 52 | 60 | CAN | 50 | 3 | 777,400$ |
| Dean Evason | 66 | 62 | 75 | 68 | 67 | 61 | 60 | CAN | 54 | 1 | 780,000$ |
| Denis Savard | 63 | 64 | 69 | 67 | 72 | 70 | 48 | CAN | 58 | 2 | 800,000$ |
| Doug Houda | 59 | 73 | 62 | 65 | 62 | 57 | 54 | CAN | 53 | 1 | 750,000$ |
| Doug Sulliman | 65 | 77 | 75 | 72 | 73 | 68 | 43 | CAN | 59 | 1 | 525,000$ |
| Ed Olcyzk | 74 | 71 | 67 | 76 | 77 | 77 | 73 | USA | 53 | 0 | 1,010,000$ |
| Gary Agnew | 61 | 70 | 71 | 68 | 71 | 63 | 32 | CAN | 59 | 1 | 600,000$ |
| Geoff Ward | 63 | 77 | 66 | 69 | 69 | 65 | 42 | CAN | 57 | 1 | 600,000$ |
| Gerard Gallant | 65 | 70 | 70 | 65 | 70 | 70 | 70 | CAN | 60 | 3 | 1,100,000$ |
| Glen Gulutzan | 62 | 67 | 67 | 70 | 72 | 72 | 68 | CAN | 52 | 0 | 900,000$ |
| Glen Murray | 56 | 61 | 81 | 72 | 84 | 79 | 66 | CAN | 51 | 0 | 1,250,000$ |
| Guy Boucher | 57 | 56 | 72 | 64 | 56 | 53 | 53 | CAN | 52 | 2 | 525,000$ |
| Guy Carbonneau | 75 | 75 | 69 | 75 | 75 | 75 | 75 | CAN | 59 | 0 | 1,611,000$ |
| JJ Daigneault | 79 | 71 | 76 | 66 | 96 | 96 | 54 | CAN | 54 | 0 | 897,600$ |
| Jack Capuano | 75 | 64 | 81 | 73 | 65 | 69 | 77 | USA | 55 | 2 | 1,385,000$ |
| James Patrick | 58 | 72 | 64 | 65 | 61 | 56 | 49 | CAN | 56 | 2 | 828,000$ |
| Jamie Langenbrunner | 65 | 70 | 75 | 75 | 70 | 70 | 70 | USA | 48 | 3 | 1,250,000$ |
| Jarome Iginla | 75 | 70 | 90 | 70 | 75 | 75 | 80 | CAN | 46 | 3 | 1,500,000$ |
| Jean-Sébastien Giguère | 50 | 85 | 70 | 80 | 80 | 75 | 70 | CAN | 46 | 3 | 900,000$ |
| Jeff Blashill | 60 | 65 | 70 | 65 | 60 | 65 | 65 | USA | 50 | 1 | 800,000$ |
| Jim Johnson | 57 | 64 | 67 | 62 | 59 | 54 | 54 | USA | 56 | 1 | 500,000$ |
| Joe Juneau | 70 | 75 | 75 | 70 | 60 | 70 | 70 | CAN | 54 | 3 | 900,000$ |
| Joe Mullen | 60 | 68 | 76 | 61 | 71 | 60 | 28 | USA | 62 | 1 | 1,000,000$ |
| John Anderson | 73 | 73 | 74 | 74 | 68 | 65 | 72 | CAN | 62 | 1 | 525,000$ |
| John Hynes | 55 | 75 | 65 | 80 | 60 | 65 | 65 | USA | 48 | 1 | 575,000$ |
| John Torchetti | 75 | 78 | 71 | 72 | 75 | 68 | 59 | USA | 54 | 4 | 525,000$ |
| Jon Cooper | 64 | 68 | 69 | 78 | 52 | 62 | 78 | CAN | 54 | 1 | 950,000$ |
| Kelly Buchberger | 75 | 77 | 71 | 75 | 75 | 75 | 75 | CAN | 52 | 0 | 1,269,000$ |
| Kevin Constantine | 75 | 70 | 73 | 75 | 75 | 75 | 75 | USA | 61 | 0 | 1,123,000$ |
| Kevin Weekes | 50 | 80 | 60 | 70 | 80 | 80 | 70 | CAN | 48 | 2 | 970,000$ |
| Kirk Muller | 76 | 77 | 74 | 77 | 68 | 74 | 55 | CAN | 53 | 1 | 525,000$ |
| Lane Lambert | 75 | 75 | 70 | 75 | 75 | 75 | 75 | USA | 55 | 0 | 1,226,000$ |
| Marc Crawford | 79 | 73 | 69 | 80 | 77 | 77 | 73 | CAN | 58 | 0 | 1,186,000$ |
| Mario Tremblay | 62 | 70 | 76 | 70 | 78 | 71 | 37 | CAN | 62 | 4 | 1,000,000$ |
| Mark Hardy | 56 | 64 | 70 | 64 | 67 | 53 | 38 | CAN | 60 | 2 | 1,000,000$ |
| Michel Therrien | 67 | 64 | 80 | 74 | 75 | 75 | 74 | CAN | 57 | 3 | 1,437,500$ |
| Mike Kitchen | 77 | 71 | 68 | 74 | 79 | 79 | 71 | CAN | 63 | 0 | 816,000$ |
| Mike Komisarek | 80 | 75 | 60 | 65 | 70 | 70 | 70 | USA | 41 | 1 | 500,000$ |
| Mike Ramsey | 56 | 66 | 68 | 68 | 71 | 54 | 69 | USA | 58 | 2 | 1,000,000$ |
| Mike Sullivan | 59 | 66 | 64 | 61 | 60 | 52 | 61 | USA | 51 | 1 | 645,000$ |
| Mike Yeo | 67 | 72 | 77 | 63 | 71 | 67 | 80 | CAN | 45 | 1 | 500,000$ |
| Nelson Emerson | 75 | 65 | 75 | 75 | 75 | 75 | 75 | USA | 52 | 1 | 901,000$ |
| Newell Brown | 61 | 68 | 75 | 66 | 80 | 64 | 43 | CAN | 57 | 2 | 1,000,000$ |
| Nicklas Lidstrom | 71 | 82 | 74 | 65 | 78 | 78 | 62 | SWE | 53 | 0 | 1,500,000$ |
| Patrick Roy | 77 | 71 | 72 | 81 | 52 | 87 | 73 | CAN | 56 | 1 | 1,750,000$ |
| Paul MacLean | 65 | 76 | 74 | 73 | 77 | 69 | 34 | CAN | 61 | 2 | 1,000,000$ |
| Pavel Datsyuk | 50 | 70 | 80 | 70 | 70 | 70 | 70 | RUS | 45 | 3 | 1,200,000$ |
| Peter DeBoer | 73 | 76 | 72 | 78 | 74 | 73 | 58 | CAN | 51 | 2 | 525,000$ |
| Peter Horachek | 66 | 66 | 78 | 75 | 78 | 72 | 42 | CAN | 59 | 1 | 1,000,000$ |
| Phil Housley | 60 | 75 | 70 | 70 | 75 | 75 | 70 | USA | 59 | 2 | 1,000,000$ |
| Rick Tocchet | 79 | 68 | 76 | 71 | 66 | 60 | 65 | CAN | 55 | 2 | 1,000,000$ |
| Rick Wamsley | 58 | 71 | 65 | 63 | 70 | 60 | 65 | CAN | 60 | 1 | 600,000$ |
| Ron Rolston | 60 | 82 | 64 | 72 | 57 | 64 | 66 | USA | 55 | 2 | 1,078,500$ |
| Ryan Getzlaf | 70 | 70 | 80 | 70 | 75 | 75 | 80 | CAN | 39 | 3 | 900,000$ |
| Ryan McGill | 77 | 68 | 68 | 73 | 84 | 84 | 66 | USA | 50 | 0 | 1,255,000$ |
| Scott Arniel | 64 | 75 | 75 | 66 | 64 | 57 | 53 | CAN | 56 | 1 | 525,000$ |
| Scott Gordon | 73 | 74 | 73 | 74 | 72 | 68 | 37 | USA | 56 | 3 | 525,000$ |
| Scott Stevens | 70 | 71 | 71 | 73 | 66 | 72 | 60 | CAN | 58 | 3 | 750,000$ |
| Shane Doan | 83 | 76 | 78 | 74 | 81 | 81 | 69 | CAN | 46 | 2 | 1,000,000$ |
| Steve Konowalchuk | 63 | 71 | 71 | 69 | 62 | 60 | 78 | CAN | 46 | 2 | 525,000$ |
| Stu Barnes | 58 | 65 | 68 | 66 | 58 | 54 | 69 | CAN | 48 | 2 | 700,000$ |
| Todd Richards | 73 | 74 | 76 | 73 | 65 | 60 | 57 | USA | 52 | 1 | 525,000$ |
| Tommy Albelin | 58 | 68 | 66 | 66 | 62 | 61 | 57 | SWE | 55 | 3 | 1,250,000$ |
| Tony Granato | 61 | 73 | 73 | 64 | 70 | 62 | 57 | USA | 54 | 2 | 1,000,000$ |
| Travis Green | 60 | 65 | 65 | 75 | 65 | 65 | 70 | CAN | 53 | 2 | 900,000$ |
| Trent Yawney | 63 | 75 | 76 | 67 | 69 | 63 | 62 | CAN | 53 | 2 | 1,000,000$ |