| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Barry Trotz | Nashville Predators | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 8 | 500,000$ |
| Bruce Boudreau | Anaheim Ducks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 72 | 8 | 500,000$ |
| Claude Julien | Boston Bruins | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 67 | 8 | 500,000$ |
| Craig Berube | Vegas Golden Knights | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 73 | 1 | 575,000$ |
| DJ Smith | Ottawa Senators | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 47 | 9 | 1,000,000$ |
| Dan Bylsma | New York Islanders | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 56 | 8 | 500,000$ |
| Darryl Sutter | Los Angeles Kings | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 67 | 8 | 500,000$ |
| Dave Hakstol | Seattle Kraken | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 61 | 1 | 1,000,000$ |
| Dave Tippett | Arizona Coyotes | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 51 | 8 | 750,000$ |
| Gerard Gallant | Washington Capitals | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 65 | 8 | 800,000$ |
| Glen Gulutzan | Toronto Maple Leafs | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 55 | 1 | 500,000$ |
| Jared Bednar | Vancouver Canucks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 52 | 2 | 1,000,000$ |
| Jay Woodcroft | New Jersey Devils | 80 | 80 | 80 | 80 | 80 | 80 | 80 | YES | 46 | 3 | 500,000$ |
| Joe Sacco | Colorado Avalanche | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 58 | 8 | 500,000$ |
| Joel Quenneville | Chicago Blackhawks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 68 | 8 | 6,000,000$ |
| John Tortorella | Calgary Flames | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 68 | 5 | 500,000$ |
| Jon Cooper | Carolina Hurricanes | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 62 | 8 | 850,000$ |
| Ken Hitchcock | Columbus Blue Jackets | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 75 | 1 | 500,000$ |
| Kevin Dineen | Florida Panthers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 63 | 8 | 500,000$ |
| Lane Lambert | Edmonton Oilers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 51 | 3 | 750,000$ |
| Lindy Ruff | Buffalo Sabres | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 67 | 2 | 500,000$ |
| Martin St. Louis | Tampa Bay Lightning | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 48 | 4 | 750,000$ |
| Michel Therrien | Montreal Canadiens | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 1 | 500,000$ |
| Mike Babcock | Detroit Red Wings | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 9 | 6,250,000$ |
| Mike Johnston | Minnesota Wild | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 73 | 9 | 1,500,000$ |
| Mike Sullivan | Pittsburgh Penguins | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 61 | 8 | 1,000,000$ |
| Mike Yeo | New York Rangers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 53 | 8 | 500,000$ |
| Peter Laviolette | Philadelphia Flyers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 62 | 8 | 500,000$ |
| Rick Bowness | Dallas Stars | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 70 | 9 | 1,000,000$ |
| Rod Brind'Amour | St. Louis Blues | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 55 | 9 | 1,000,000$ |
| Todd McLellan | San Jose Sharks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 59 | 1 | 500,000$ |
| Willie Desjardins | Winnipeg Jets | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 73 | 8 | 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 | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Adam Oates | Springfield Thunderbirds | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 3 | 500,000$ |
| Alexei Kovalev | Hershey Bears | 80 | 80 | 80 | 80 | 80 | 80 | 80 | RUS | 57 | 8 | 1,000,000$ |
| Marian Hossa | Rockford IceHogs | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CZE | 44 | 4 | 1,000,000$ |
| Mike Rupp | Wilkes-Barre/Scranton Penguins | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 44 | 2 | 500,000$ |
| Paul Maurice | Syracuse Crunch | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 58 | 3 | 1,000,000$ |
| Ralph Kruger | Bakersfield Condors | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 51 | 8 | 750,000$ |
| Tom Barrasso | Binghamton Devils | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 63 | 3 | 575,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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Patrick Roy | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 3 | 775,000$ |
| Rick Tocchet | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 63 | 0 | 850,000$ |