| 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 | 57 | 9 | 1,000,000$ | |
| Doug Gilmour | Hartford Whalers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 61 | 8 | 1,000,000$ | |
| Henrik Sedin | Vancouver Millionaires | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 43 | 9 | 1,000,000$ | |
| Igor Larionov | Detroit Red Wings | 80 | 80 | 80 | 80 | 80 | 80 | 80 | RUS | 63 | 8 | 1,000,000$ | |
| Jari Kurri | California Golden Seals | 80 | 80 | 80 | 80 | 80 | 80 | 80 | FIN | 63 | 8 | 1,000,000$ | |
| Jeremy Roenick | Kansas City Scouts | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 53 | 8 | 1,000,000$ | |
| Joel Quenneville | New Jersey Devils | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 68 | 10 | 1,000,000$ | |
| Jon Cooper | Anaheim Ducks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 62 | 9 | 1,000,000$ | |
| Marian Gaborik | San Jose Sharks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SVK | 41 | 9 | 1,000,000$ | |
| Marian Hossa | Chicago Blackhawks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SVK | 44 | 8 | 1,000,000$ | |
| Mario Lemieux | Pittsburgh Penguins | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 58 | 9 | 1,000,000$ | |
| Mats Sundin | Toronto Maple Leafs | 80 | 80 | 80 | 80 | 80 | 80 | 80 | Swe | 53 | 8 | 1,000,000$ | |
| Michal Handzus | St Louis Blues | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SVK | 46 | 8 | 1,000,000$ | |
| Sergei Fedorov | Portland Winterhawks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | RUS | 54 | 8 | 1,000,000$ | |
| Steve Yzerman | Tampa Bay Lightning | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 58 | 8 | 1,000,000$ | |
| Trevor Linden | Winnipeg Jets | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 53 | 8 | 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 | 48 | 8 | 1,000,000$ | |
| Chris Pronger |  O'Fallon Madcats | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 49 | 8 | 1,000,000$ | |
| Dan Bylsma |  Wheeling Nailers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 56 | 9 | 1,000,000$ | |
| Daniel Sedin |  Sudbury Wolves | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 43 | 9 | 1,000,000$ | |
| Emilio Estevez |  San Diego Spartans | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 61 | 9 | 1,000,000$ | |
| Felix Potvin |  IUP Crimson Hawks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 51 | 8 | 1,000,000$ | |
| Jeff Blashill |  Orlando Solar Bears | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 50 | 8 | 1,000,000$ | |
| Kari Lehtonen |  Lillehammer IK | 80 | 80 | 80 | 80 | 80 | 80 | 80 | FIN | 39 | 9 | 1,000,000$ | |
| Kevin Dineen |  Utica Comets | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 63 | 9 | 1,000,000$ | |
| Mike Rupp |  Cleveland Monsters | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 44 | 9 | 1,000,000$ | |
| Nick Lidstrom |  Rogle BK | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 53 | 8 | 1,000,000$ | |
| Niklas Hjalmarsson |  Tucson Roadrunners | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 36 | 8 | 10,000,000$ | |
| Peter Forsberg |  Skelleftea AIK | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 50 | 8 | 1,000,000$ | |
| Rod Brind'Amour |  Saskatoon Blades | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 55 | 9 | 1,000,000$ | |
| Stan Smyl |  Calgary Canucks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 65 | 8 | 1,000,000$ | |
| Wayne Gretzky |  Hershey Bears | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 65 | 9 | 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 | 64 | 10 | 1,000,000$ | |
| Barry Trotz | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 10 | 1,000,000$ | |
| Bruce Boudreau | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 72 | 10 | 1,000,000$ | |
| Claude Julien | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 67 | 10 | 1,000,000$ | |
| Craig Berube | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 73 | 10 | 1,000,000$ | |
| DJ Smith | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 47 | 10 | 1,000,000$ | |
| Darryl Sutter | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 67 | 10 | 1,000,000$ | |
| Dave Hakstol | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 61 | 10 | 1,000,000$ | |
| Dave Tippett | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 51 | 10 | 1,000,000$ | |
| Gerard Gallant | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 65 | 10 | 1,000,000$ | |
| Glen Gulutzan | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 55 | 10 | 1,000,000$ | |
| Jared Bednar | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 52 | 10 | 1,000,000$ | |
| Joe Sacco | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 58 | 10 | 1,000,000$ | |
| John Tortorella | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 68 | 10 | 1,000,000$ | |
| Ken Hitchcock | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 75 | 10 | 1,000,000$ | |
| Lane Lambert | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 51 | 10 | 1,000,000$ | |
| Lindy Ruff | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 67 | 9 | 1,000,000$ | |
| Martin St. Louis | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 48 | 10 | 1,000,000$ | |
| Michel Therrien | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 10 | 1,000,000$ | |
| Mike Babcock | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 10 | 1,000,000$ | |
| Mike Johnston | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 73 | 10 | 1,000,000$ | |
| Mike Sullivan | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 61 | 9 | 1,000,000$ | |
| Mike Yeo | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 53 | 10 | 1,000,000$ | |
| Patrick Roy | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 10 | 1,000,000$ | |
| Paul Maurice | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 58 | 10 | 1,000,000$ | |
| Peter Laviolette | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 62 | 10 | 1,000,000$ | |
| Ralph Kruger | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 51 | 10 | 1,000,000$ | |
| Rick Bowness | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 70 | 10 | 1,000,000$ | |
| Rick Tocchet | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 63 | 10 | 1,000,000$ | |
| Todd McLellan | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 59 | 10 | 1,000,000$ | |
| Tom Barrasso | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 63 | 10 | 1,000,000$ | |
| Willie Desjardins | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 73 | 10 | 1,000,000$ |