| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Alexei Kovalev | Columbus Blue Jackets | 80 | 80 | 80 | 80 | 80 | 80 | 80 | RUS | 58 | 8 | 1,000,000$ | |
| Doug Gilmour | Hartford Whalers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 62 | 7 | 1,000,000$ | |
| Henrik Sedin | Vancouver Millionaires | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 44 | 8 | 1,000,000$ | |
| Igor Larionov | Detroit Red Wings | 80 | 80 | 80 | 80 | 80 | 80 | 80 | RUS | 64 | 7 | 1,000,000$ | |
| Jari Kurri | California Golden Seals | 80 | 80 | 80 | 80 | 80 | 80 | 80 | FIN | 64 | 7 | 1,000,000$ | |
| Jason Payne | Cincinnati Cyclones | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 40 | 9 | 750,000$ | |
| Jeremy Roenick | Kansas City Scouts | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 54 | 7 | 1,000,000$ | |
| Joel Quenneville | New Jersey Devils | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 69 | 9 | 1,000,000$ | |
| Jon Cooper | Anaheim Ducks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 63 | 8 | 1,000,000$ | |
| Marian Gaborik | San Jose Sharks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SVK | 42 | 8 | 1,000,000$ | |
| Marian Hossa | Chicago Blackhawks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SVK | 45 | 7 | 1,000,000$ | |
| Mario Lemieux | Pittsburgh Penguins | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 59 | 8 | 1,000,000$ | |
| Mats Sundin | Toronto Maple Leafs | 80 | 80 | 80 | 80 | 80 | 80 | 80 | Swe | 54 | 7 | 1,000,000$ | |
| Michal Handzus | St Louis Blues | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SVK | 47 | 7 | 1,000,000$ | |
| Steve Yzerman | Tampa Bay Lightning | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 59 | 7 | 1,000,000$ | |
| Trevor Linden | Winnipeg Jets | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 54 | 7 | 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 | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Contrat Signature Date | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Alex Daigle |  Greenville Swamp Rabbits | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 49 | 7 | 1,000,000$ | |
| Chris Pronger |  O'Fallon Madcats | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 50 | 7 | 1,000,000$ | |
| Dan Bylsma |  Wheeling Nailers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 57 | 8 | 1,000,000$ | |
| Daniel Sedin |  Sudbury Wolves | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 44 | 8 | 1,000,000$ | |
| Emilio Estevez |  San Diego Spartans | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 62 | 8 | 1,000,000$ | |
| Felix Potvin |  IUP Crimson Hawks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 52 | 7 | 1,000,000$ | |
| Jeff Blashill |  Orlando Solar Bears | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 51 | 7 | 1,000,000$ | |
| Jerome Bechard |  Columbus River Dragons | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 40 | 9 | 750,000$ | |
| Kari Lehtonen |  Lillehammer IK | 80 | 80 | 80 | 80 | 80 | 80 | 80 | FIN | 40 | 8 | 1,000,000$ | |
| Kevin Dineen |  Utica Comets | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 8 | 1,000,000$ | |
| Mike Rupp |  Cleveland Monsters | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 45 | 8 | 1,000,000$ | |
| Niklas Hjalmarsson |  Tucson Roadrunners | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 37 | 7 | 10,000,000$ | |
| Peter Forsberg |  Skelleftea AIK | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 51 | 7 | 1,000,000$ | |
| Rod Brind'Amour |  Saskatoon Blades | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 56 | 8 | 1,000,000$ | |
| Stan Smyl |  Calgary Canucks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 66 | 7 | 1,000,000$ | |
| Wayne Gretzky |  Hershey Bears | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 66 | 8 | 1$ |
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Adam Oates | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 65 | 10 | 1,000,000$ | |
| Barry Trotz | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 65 | 10 | 1,000,000$ | |
| Bruce Boudreau | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 73 | 10 | 1,000,000$ | |
| Claude Julien | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 68 | 10 | 1,000,000$ | |
| Craig Berube | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 74 | 10 | 1,000,000$ | |
| DJ Smith | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 48 | 10 | 1,000,000$ | |
| Darryl Sutter | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 68 | 10 | 1,000,000$ | |
| Dave Hakstol | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 62 | 10 | 1,000,000$ | |
| Dave Tippett | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 52 | 10 | 1,000,000$ | |
| Gerard Gallant | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 66 | 10 | 1,000,000$ | |
| Glen Gulutzan | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 56 | 10 | 1,000,000$ | |
| Jared Bednar | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 53 | 10 | 1,000,000$ | |
| Joe Sacco | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 59 | 10 | 1,000,000$ | |
| John Tortorella | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 69 | 10 | 1,000,000$ | |
| Ken Hitchcock | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 76 | 10 | 1,000,000$ | |
| Lane Lambert | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 52 | 10 | 1,000,000$ | |
| Lindy Ruff | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 68 | 9 | 1,000,000$ | |
| Martin St. Louis | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 49 | 10 | 1,000,000$ | |
| Michel Therrien | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 65 | 10 | 1,000,000$ | |
| Mike Babcock | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 65 | 10 | 1,000,000$ | |
| Mike Johnston | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 74 | 10 | 1,000,000$ | |
| Mike Sullivan | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 62 | 9 | 1,000,000$ | |
| Mike Yeo | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 54 | 10 | 1,000,000$ | |
| Nick Lidstrom | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 54 | 7 | 1,000,000$ | |
| Patrick Roy | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 65 | 10 | 1,000,000$ | |
| Paul Maurice | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 59 | 10 | 1,000,000$ | |
| Peter Laviolette | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 63 | 10 | 1,000,000$ | |
| Ralph Kruger | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 52 | 10 | 1,000,000$ | |
| Rick Bowness | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 71 | 10 | 1,000,000$ | |
| Rick Tocchet | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 10 | 1,000,000$ | |
| Sergei Fedorov | 80 | 80 | 80 | 80 | 80 | 80 | 80 | RUS | 55 | 7 | 1,000,000$ | |
| Todd McLellan | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 60 | 10 | 1,000,000$ | |
| Tom Barrasso | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 64 | 10 | 1,000,000$ | |
| Willie Desjardins | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 74 | 10 | 1,000,000$ |