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